What is a plan and package in db2?
No Answer is Posted For this Question
Be the First to Post Answer
What is dclgen in db2?
Describe major components of db2?
What is EXPLAIN?
What is FREEPAGE and PCTFREE in TABLESPACE creation?
How can we define a table? How can we apply SEARCH ALL on it ?
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 are leaf pages?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What is null value in db2?
What is runstats utility in db2?
which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM
How can the duplicate values be eliminated from db2 select?