Interested to Buy Any Domain ? << Click Here >> for more details...
What's the Maximum Length of SQLCA and what's the content
of SQLCABC?
- 2 Answers
- 18879 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 |
What are some SQL aggregates and other built-in functions?
What is filter factor?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
My SQL is not performing well. Describe how will you fine tune it?
How many buffer pools are there in DB2?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
Define db2 and its databases?
How do I add a column to an existing table in db2?
What are catalog tables in db2?
Is schema the same as database?
COBOL 
