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 |
What happens to the PLAN if index used by it is dropped?
What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.
What does reorg do in db2?
How to resolve -818 sql code in DB2?
wht displays the number of times a query modified ?
what types of copies can be made with the COPY Utility ?
Define predicate?
What is the use of db2 optimizer?
Which transaction use a command thread ?
Mention some fields that are a part of sqlca.
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What is syscat in db2?