What's the maximum number of characters that a tablename
can have?
Answer Posted / s
In DB2 V8, it is increased to 128 bytes.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain dclgen.
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What is a plan and package in db2?
How can you quickly find out the # of rows updated after an update statement?
What is the difference between spufi and qmf?
How to view db2 table structure?
What is a db2 collection?
What is declare cursor?
How to compare data between two tables in db2?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What is the syntax for FETCH in DB2 ?
What does db2 plan contain?
Which isolation level provides highest data integrity?
What is null indicator in db2?
What is dclgen (declaration generator)?