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
- 17473 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 are the 4 environments which can access DB2 ?
how can u nderstand the sql stmts executed successfully or not ?
What is Declaration Generator(DCLGEN)?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
Hi. I am currently working as a application developer. I would like to persue a DB2 certification exam. Can anybody please provide me the details about this exam like Syllabus, Cost and how to take the certification?
What is a cursor?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
0 Answers ITC Infotech, Syntel,
how can i pull up a query which was previously stored in qmf
What is subquery ?
what types of copies can be made with the COPY Utility ?
What is filter factor?
What is the difference between using bind () and rebind () methods of naming class?
COBOL 
