pls explain the precompilation process of cobol-db2 pgm
Answers were Sorted based on User's Feedback
Answer / tej
Precompilation separates the SQL statements and non-SQL
statements of an application program.
From the precompilation step onwards the original source
code will be contained in two separate physical components.
The non-sql part of the program will have all the
sql-statements commented out by the precompiler and and
replaced with cobol call statements.
The colection of SQL that was extracted will be placed in a
DBRM(Database Request Module).Precompiler also places a
consitency token in both of its outputs.
| Is This Answer Correct ? | 33 Yes | 1 No |
Answer / yuvaevergreen
Precompiling does the following:
>> Replaces the SQL statements in your source programs with
calls to DB2 language interface modules.
>>Creates a database request module (DBRM), which
communicates your SQL requests to DB2 during the bind
process
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / siri
COBOL+DB2 COMPILATION PROCESS:-
1)PRE-COMPILATION :-
*PRE-COMPILATION PROCESS UTILITY IS DSNHPC
*IT IS THE PROCESS OF SEPARATING COBOL AND DB2 STATEMENTS
*IT CHECK THE SYNTAX ERRORS OF DB2 STATEMENTS AND ALSO IT PLACES THE ERROR FREE DB2 STATEMENTS IN DBRM
*AND ALSO IT PLACES THE TIME-STAMPS TOKEN IN MODIFIED SOURCECODE AND DBRM
*********MODIFIED SOURCE CODE:-IT PLACES ONLY COBOL CALL STATEMENTS...ALL DB2 STATEMENTS REPLACED BY THE COBOL CALL STATEMENTS*******
********DBRM(DATA BASE REQUEST MOODULE)..ONE DBRM IS CREATED FOR ONE PROGRAM***********
| Is This Answer Correct ? | 3 Yes | 0 No |
How do you retrieve the first 5 characters of firstname column of db2 table emp?
How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.
suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?
what's the error code for Unique Index Violation?
What will the FREE command do to a plan?
what is different three logs in DB2?
What does CURRENTDATA option in bind indicate
How to check table size in db2 sap?
What is a clustering index ?
Before you give the explain statement, what are the prerogatives?
how to execute qcmdexc in rpgle?plz write code also?
Explain what a plan is?