What is a plan and package in db2?
What do you mean by NOT NULL? When will you use it?
What is netezza database?
What is null indicator in cobol db2?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What do you do to keep the cursor from closing after a commit?
What is the purpose of the QUIESE Utility?
Suppose we are doing transaction in a table and abend happened in between. Suppose i have completed the transaction upto X rows and I want to start the transaction again where the abend happened. I don't want to do the transaction from the first record. Then what i have to do.
What do you mean by rollback?
What are the functions in DB2?
how many bytes timestamp token occupies?
6 Answers Boss Global, Cap Gemini, TCS,