Search results for query: *

Thanks for that Marc.

Dear Members, Although it would very much depend on the application, can anybody inform me what is the usual (most often) course of action that is taken when an SQL Insert returns a -803 (duplicate row)? Thanks in advance for any assistance given.

Hi Marc, Thanks for the links. Great stuff once again.

Hi Marc, Many thanks once again.

Dear Members, Can anybody enlighten me as to what UR stands for and how locks are handled at the isolation level when this option is chosen in a cursor declaration as opposed to CS or RR? Thanks in advance for any assistance given.

Hi Marc, Once the null indicator has been checked and is found to contain a -1, what is the normal course of action one takes. Would it be advisable to abort via an exit-error-para or can you handle this situation in some way and continue processing. It is the course of action taken in the...

Dear Members, Can anybody tell what is normally done when a null is retrieved by a fetch into a host variable given that a null indicator has been coded for that host variable and both the variable itself and indicator have been initialized prior to the fetch? Would you normally be content that...

Dear Marc, Maybe the question was set wrong or posed as an intentional red herring! Many thanks once again for the expert insight on this matter.

Dear Marc, Thanks once again for the assistance.

Dear Members, Does anybody know why the use of a cursor to reconcile result set v row at a time processing is not necessary when accessing DB2 tables using the Natural programming language? Many thanks in advance for any assistance given.

Dear Members, Can anybody detail for me the whole pre-compile, compile, link and bind process? Thanks in advance for any assistance given.

Dear Marclodge, Many thanks for taking the time and trouble to reply to the questions above. The question relating to attributes was posed in a recent technical test and which I was unable to answer at the time because I had never come across it before. To the best of my recollection we were...

Many thanks for the information. Most helpful.

Can any member assist me with answers and examples to the following questions: 1.What is a DBRM? 2.Why is it not necessary to bind when using a DBRM? 3.What is the COBOL syntax for defining an attribute? 4.What is the COBOL syntax for defining an attribute or a number of attributes where both a...