What is the advantage in De-normalizing tables in DB2?
No Answer is Posted For this Question
Be the First to Post Answer
What is the syntax of SELECT statement when embedded in a COBOL program?
How to find primary key of a table in db2?
What is a dbrm in db2?
What is dbrm in db2 database?
What is dbrm?
I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?
For Read Stability locks are not applicable for phantoms, What is Phantoms?
How do you leave the cursor open after issuing a COMMIT? (for DB2 2.3 or above only)
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.
how to identify the pseudo conversation by seeing the program
What is the physical storage length of time data type?
What is db2? Explain.