pls explain the precompilation process of cobol-db2 pgm
- 3 Answers
- 21562 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 simple, segmented and partitioned table spaces ?
what are the max. & min. no. of partitions allowed in a partition tablespace?
What is -904 sql code? How to resolve it?
What do you mean by commit and rollback?
What is access path in db2?
If I have a view which is a join of two or more tables, can this view be updatable?
How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?
What is a synonym ?
How to define the a field which accepts value till 99999.99 in db2
What are the uses of db2 optimizer?
How can we retrieve the total number of records in RPG & CLLE?
SET is the ANSI standard for variable assignment, SELECT is not. SET can only assign one variable at a time, SELECT can make multiple assignments at once. If assigning from a query, SET can only assign a scalar value. If the query returns multiple values/rows then SET will raise an error. SELECT will assign one of the values to the variable and hide the fact that multiple values were returned (so you'd likely never know why something was going wrong elsewhere - have fun troubleshooting that one) When assigning from a query if there is no value returned then SET will assign NULL, where SELECT will not make the assignment at all (so the variable will not be changed from it's previous value) As far as speed differences - there are no direct differences between SET and SELECT. However SELECT's ability to make multiple assignments in one shot does give it a slight speed advantage over SET.
COBOL 
