What are the various data types available in db2?
No Answer is Posted For this Question
Be the First to Post Answer
why we go for SPUFI for creating tables or for sql queries?
How would one remove old reorg information from the DB2 catalog?
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?
What is query for your birthday date should be in hours,minute and seconds format?
how can we retrieve the 100 records of the file ?
How can deadlocks be resolved?
What is the difference between Primary key and unique index?
What are the various data types available in db2?
I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.
How can you do the explain of a dynamic sql statement?
One program calling 5 subprograms, its a cobol db2 program, after precompilation how many plans and packages will created?
How do you leave the cursor open after issuing a COMMIT? (for DB2 2.3 or above only)