Name some fields from SQLCA.

Answer Posted / s

SQLCODE, SQLSTATE, SQLERRD(3)

Is This Answer Correct ?    8 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is the primary key a clustered index?

615


What is the default page size of buffer pools?

652


can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

1810


I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

1938


Define db2.

674






Which component is used to execute the sql statements?

627


What is db2 and what is the use of db2 optimizer?

659


What happens in bind step in a db2 program?

569


Why do chiropractors use drop table?

666


Why cursor is used in db2?

577


What is ibm db2 used for?

604


Which isolation level provides maximum concurrency?

668


If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

706


While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

1824


What is scrollable cursor in db2?

588