Define declaration generator (dclgen).
No Answer is Posted For this Question
Be the First to Post Answer
What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?
How do you eliminate duplicate values in db2?
What is the purpose of the DSNC transaction ?
What is the use of dclgen in db2?
If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?
In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?
what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??
What is a view? Why use it?
How can you compare table column after update and before update?
What are packages in db2?
5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?
What is EXPLAIN?