How do I copy a table in db2?
No Answer is Posted For this Question
Be the First to Post Answer
When Can you be sure that a query will return only one row?
What are foreign keys in db2?
Explain how can you do the explain of a dynamic sql statement?
How do you check for a null value in a db2 column?
What is db2 bind process?
Mention the location where the output received from explain statement is stored.
Where would you find information about the type of database authority held by the user?
what is different three logs in DB2?
What is null in db2?
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?
If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?
What is the difference between db2 and oracle?