What is the use of DELGEN in DB2? Can we Write the program
with out using it?
- 6 Answers
- 16081 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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 is REORG? what is the use?
What is an asychronous write?
What is -904 sql code? How to resolve it?
What type of database is db2?
my project is insurance management system,how to explain my work environment in interview?
what is copy pending and check pending ?
Write a query to extract first 5 characters of a name in the column Stud_Name?
What are packages in db2?
in a table consist of 1000 records among that i was updated 145 record how could i know that ..list of recently updated record's and where could i see those updated record's....pls help me out....
i have cobol+ db2 program but it contains n number of subprograms for this how many dbrm members i need to mention in bind process
What techniques are used to retrieve data from more than one table in a single SQL statement?
what is db2 restart?
COBOL 
