What is the use of DELGEN in DB2? Can we Write the program
with out using it?

Answer Posted / deepak gairola

DCLGEN(Declaration Genrator) is used to generate DB2
equivalent Cobol Datatypes. We can write a cobol Db2
program without using it but we will have to declare cobol
variables in our Program and for sure it need to be DB2
Equivalent... but it is preffered to use DCLgen as it gives
you the accurate... equivalent... of db2 datatype...and it
enhances the performance no doubt...

For Sql Datatype is Name Varchar(20).
so cobol equivalent is
01 Name.
49 Name-len PIC s9(04) comp.
49 Name-text pic x(2).

Is This Answer Correct ?    9 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is db2 connect?

841


What are catalog tables in db2?

817


How to rename a table in DB2 ?

859


What are the various data types available in db2?

847


What is the difference between bind and rebind in db2?

1227


What is image copy in db2?

789


Is db2 a database?

775


Which isolation level provides maximum concurrency?

932


Define sqlca.

889


Explain how can you do the explain of a dynamic sql statement?

890


What is database reorganization?

872


How does db2 sample database connect?

812


What is db2 and what is the use of db2 optimizer?

866


what is utility for parm lib

2138


Is db2 a mainframe?

815