pls explain the precompilation process of cobol-db2 pgm
- 3 Answers
- 22443 Views
- HCL, IBM, I also Faced
- E-Mail Answers
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 are the 2 sqlcodes that are returned?
Is schema the same as database?
wht happens if we close cursor with cursor with hold option?
What are the four lockable units for DB2?
in a table consist of 1000 records among that i was updated 145 record how could i know that ..list of recently updated record's and where could i see those updated record's....pls help me out....
What is a page in db2?
wht displays the number of times a query modified ?
What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?
What is data manager?
what is the soft code for deadlock ?
Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?
What does the CHECK Utility do ?
COBOL 
