Saturday, 11 May 2013

PRE-COMPILATION includes the following process......

The precompiler "prepares" the source program for compilation by replacing EXEC SQL by a CALL and by putting the SQL in comment. The precompiler performs the following:


* includes DCLGEN member

* includes SQLCA

* looks for SQL statements and for host variable definitions

* verifies the SQL syntax

* matches each column and table name in the SQL to the DECLARE TABLE statements.

* prepares the SQL for compilation or assembly in the host language

* produces a DBRM and stores it in PDS

* can be invoked in DB2l or in batch.

No comments:

Post a Comment

Expense Handler Application with advance technologies

Budget Planner  One of the application developed with Ionic 4 and Python-Flask.  Ionic 4 code:  https://github.com/logeshbuiltin/Expense...