Interested to Buy Any Domain ? << Click Here >> for more details...
What is the use of DELGEN in DB2? Can we Write the program
with out using it?
- 6 Answers
- 17482 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 a precompiler?
What is the picture clause of the null indicator variable?
What is dbrm? When it will be created?
What are the functions of Bind?
What is DCLGEN ?
Can you access the DB2 Directory table using SQL?
Comment whether the cursor is closed during commit or not.
How do you pull up a query which was previously saved in qmf?
what is consistency token
What is the difference between using bind () and rebind () methods of naming class?
What is a synonym ?
What are bind parameters in db2?
COBOL 
