What's the Maximum Length of SQLCA and what's the content
of SQLCABC?
Answers were Sorted based on User's Feedback
Answer / swetha dasari
Max length of SQLCA is 136.
SQLCABC holds the length of SQLCA.
| Is This Answer Correct ? | 21 Yes | 1 No |
Answer / swetha dasari
the source for the above answer is :
http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp
?topic=/com.ibm.db2.udb.doc/admin/r0002212.htm
i am not completely sure about the length
| Is This Answer Correct ? | 4 Yes | 2 No |
what are the bind parameters?
What are the 2 sqlcodes that are returned?
Q3. How will you fetch duplicate values from a DB2 table?
What is lock escalation?
Why do we use cursor?
Suppose we are doing transaction in a table and abend happened in between. Suppose i have completed the transaction upto X rows and I want to start the transaction again where the abend happened. I don't want to do the transaction from the first record. Then what i have to do.
What is the error code -803 ?
Can we use group-by clause in sub-query? If 'yes' means,Will it be executed successfully or else If 'no' means why should we not using that method? Give me your suggestion please....
how to copy the host variables from ps file into cobol program other than include statement
Request to database but database is not available so what is was abend is raised?
What is collection in db2 bind?
Explain db2.