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 |
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
how will you retrieve first record in table
DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?
How to insert more than one record using insert?
What will happen, while trying to close the closed cursor.
What is coalesce in db2?
What type of database is db2?
What is cursor with hold option in db2?
What is a Cartesian product?
if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.
what is SMP/E? and what are the major steps of it? thanks...
DB2 is a A) data base/data communication system B) data base C) RDBMS D) Programming language