What is the max length of sqlca?
- 1 Answers
- 1309 Views
- I also Faced
- E-Mail Answers
Answer / Deevesh Pratap Arun
The maximum length of SQLCA (SQL Communications Area) varies depending on the database and programming language being used. In DB2 for z/OS, the maximum size of SQLCA is 8192 bytes.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is a DB2 plan?
Can I use LOCK TABLE on a view?
What is DB2 (IBM Database 2)?
What do you do to keep the cursor from closing after a commit?
This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.
What language is db2 written in?
What is a predicate?
What are types of indexes?
What is the difference between plan and package in db2?
How do you find the maximum value in a column in db2?
How to select the duplicate rows from a table?
can any one expalin check point with an example?
COBOL 
