How can the firstname and the lastname from the emp table be concatenated to generate complete names?
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?
can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?
What is a composite index and how does it differ from a multiple index?
How to know the primary key of a table without defining the primary key in the table?
What does db2 plan contain?
what happend with out using Commit,when closing cursor and program?
My SQL is not performing well. Describe how will you fine tune it?
What are the contents of a DCLGEN?
pls explain the precompilation process of cobol-db2 pgm
How to test SQL -911 error while developing COB-DB2 program
Name the various locking levels available?
Explain packages.