What is the use of DELGEN in DB2? Can we Write the program
with out using it?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / sachin borase
for varchr(40)
cobol eq valent will be
01 var-char
49 length s9(4) comp.
49 text x(20).
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / balaganesan p
DCLGEN is used to create the cobol copy book. But it is not
mandatory to use DCLGEN for that. We can hardcode that
cobol variables. For the purpose of reduce the manual
errors we use DCLGEN to create those copy books.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / yuvaevergreen
DCLGEN command is used to create
1.HOST VARIABLES.
2.TABLE DECLARATION.
INFO IS GOT FROM THE CATALOG TBLES.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / venkat
DCLGEN :DCLGEN INCLUDES DB2 TABLE DECLARATION AND HOST VARIABLE STRUCTURE
YES,WE CAN WRITE THE PROGRAM WITH OUT USING DCLGEN
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / g.kalyani
DELGEN is a declaration generator to generate the DB2
equivilant COBOL variables . It will improve the
performance of the program. Here only we can give the
NULLIND as 'YES' the automatically when ever null values
are specified in DB2 then it will move SPACES or ZEROS to
the COBOL variables
Is This Answer Correct ? | 2 Yes | 2 No |
What do you mean by between and in? Is between inclusive of specified range values?
How to resolve -504 sql code in DB2?
How many clustering indexes can be defined for a table?
What's The Error Code For Unique Index Voilation?
Can we use select * statement in cobol program without giving field names ???
What is the SQL Communications Area and what are some of its key fields?
Compare a subselect to a join?
How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?
What is role in db2?
can any one give the list of some important sql abend codes which r frequently asked in interviews?
What is reorg in DB2
What is rebind in db2?