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 to define the a field which accepts value till 99999.99 in db2
When is the access path determined for dynamic SQL?
How we create a tables in db2,what is the process/syntax to create a table with example plz?
Explain correlated sub-queries.
How is deadlock resolved?
How does one remove entries from the SCT02 table?
Hi this is sures. i need to practice the ibm mainframes.could u telme how can i get userid from IBM.how much cost they will collect for one user id.can send me the details please.thanq
where will u check for sqlcode ?
How do I add a column to an existing table in db2?
What is ALTER ?
what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??
What is a data page?