Interested to Buy Any Domain ? << Click Here >> for more details...
pls explain the precompilation process of cobol-db2 pgm
- 3 Answers
- 23623 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 |
Where do you specify them?
What is page size in db2?
Generally if I want to select the names starting with c I need to use c% But how could I code to select the data which contains % as a part of data.
What information is held in SYSIBM.SYSCOPY?
select distinct(empid),distinct(dept),name from EMP will the above query work?
What is the role of schema in the db2 database?
can i code union in cobol-db2 pgm ?
Could anyone clearly explain the diference between sub query and correlated sub query?
What is reorg in DB2
What is FREEPAGE and PCTFREE in TABLESPACE creation?
Before you give the explain statement, what are the prerogatives?
When do you specify the isolation level?
COBOL 
