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
- 17196 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 system catalog table in db2?
What is deadlock?
How to resolve -917 sql code in DB2?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What is meant by explain?
What is the latest version of ibm db2?
Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?
Which transaction use a command thread ?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
How does one remove entries from the SCT02 table?
Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?
max number of columns in a db2 table?
COBOL 
