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 copy pending status in db2?

879


What is bind plan?

812


What is cloudant database?

853


How to check table size in db2 sap?

796


What is database reorganization?

844


How do you select a row using indexes in db2?

859


Which command is used to remove all rows from a table?

796


What r the comman abends in db2, jcl and cobol???????

2030


Mention the location where the output received from explain statement is stored.

865


Define declaration generator (dclgen).

891


How do I import a csv file into db2?

765


Is db2 a mainframe?

802


Highlight all the advantages that are attached to a package.

894


What is coalesce in db2?

879


What is host variable in db2 cobol?

822