Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
- 1 Answers
- 1135 Views
- I also Faced
- E-Mail Answers
Answer / Mohammad Shavab
DCLGEN is not always mandatory. It's a utility in DB2 that generates database control language (DBDL) statements for creating and altering tables, indexes, and other database objects. However, these can also be written manually. DCLGEN can be useful when creating complex structures or when dealing with large numbers of objects.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is Skeleton cursor table (SKCT)?
select * from orders where odate between '2010-01-01'and '2010-03-31' How do u fetch this into cursor?
Can you Average the Characters ?
Can a Db2 table data be retrived through JCL?
What is the role of data manager in the db2 database?
What is a Resource Control Table(RCT)? Describe its characteristics.
What are data types?
What is the information associated with sysibm.syslinks table?
What is the default page size of buffer pools?
How do you prepare a COBOL + DB2 program from coading till execution ?
What is the maximum size of a char data type in db2?
What is a DB2 bind?
COBOL 
