Answer Posted / s
DSNDB07 database is a work file database and is used by SQL
statements that require working storage like sorts.
| Is This Answer Correct ? | 25 Yes | 1 No |
Post New Answer View All Answers
What is the difference between db2 and oracle?
What are the 2 sqlcodes that are returned?
What is meant by dclgen?
Why do we use cursor?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What is meant by explain?
What action db2 takes when a program aborts in the middle of a transaction?
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 .....
How and when does the db2 enforces the unique key?
Can you use max on a char column?
What is coalesce in db2?
How can you count the number of rows from a table tab?
List some fields from sqlca?
How do I copy a table in db2?
How can you do the explain of a dynamic sql statement?