What is the command used by TSO users to invoke DB2?
Answers were Sorted based on User's Feedback
How does cobol compile db2 program?
What is ALTER ?
If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?
a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.
In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.
What is dbrm? When it will be created?
what types of copies can be made with the COPY Utility ?
What is a cursor?
I have a main program (A) where we delete some rows in table in a cursor, and we commit it in sub program(B). What will happen - will we get an error or not?
Explain what a plan is?
AGGREGATE function support by DB2. A) SUM & AVG B) SUM, MIN & AVG C) SUM, MAX, AVG , MIN &COUNT D) NONE
How will you delete duplicate records from a table?