What's the Maximum Length of SQLCA and what's the content
of SQLCABC?
- 2 Answers
- 18291 Views
- I also Faced
- E-Mail Answers
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 |
Define data page.
How to test SQL -911 error while developing COB-DB2 program
Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?
What's the difference between DB2 active log and archive log? Thanks a lot...
What is the maximum number of tables that can be stored on a Partitioned Table Space ?
What are the different methods of accessing db2 from tso? How is the connection established between TSO & DB2?
we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?
What are foreign keys?
What is cursor stability in db2?
What is check constraint. Explain with example.
can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?
Can a array declared with an index be displayed(readable format) in spool?
COBOL 
