What is the SQL Communications Area and what are some of
its key fields?
Answer Posted / s
SQL CA is a collection of variables that is updated after
the execution of an SQL statement.
SQLCODE - SQL return code indicates if the execution was
successful or not and no data found conditions.
SQLSTATE - SQL return codes that can be used to test
specific error conditions.
SQLERRD(3)-Contains the no. of rows updated/inserted/deleted
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Explain package in db2 and its advantages?
What is ibm db2 connect?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
can all users have the privilage to use the sql statement select * (dml)?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
Which components manage deadlocks in db2?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What is plan in cobol db2?
Is db2 relational database?
Highlight all the advantages that are attached to a package.
Is ibm db2 free?
Give a brief description of db2 isolation levels?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?