MVSFORUMS.com

[vikramdr]

1. SQL Syntax errors are checked in which stage
a) Precompile
b) Bind
c) Both stages
d) Depends on the DB2 installation

My guess is it is done only in Precompile. But I am not sure if it is done in Bind step also. Please clarify.

2. When the table is dropped, does all the views which were defined on that tables also gets dropped automatically ?
_________________
Vikram

[kolusu]

vikramdr,

1.When you precompile your program, the precompiler does not validate the names of tables and columns that are used in SQL statements. However, the precompiler checks table and column references against SQL DECLARE TABLE statements in the program. Therefore, you should use DCLGEN to obtain accurate SQL DECLARE TABLE statements.

You might need to precompile and compile program source statements several times before they are error-free and ready to link-edit. During that time, you can get complete diagnostic output from the DB2 precompiler by specifying the SOURCE and XREF precompiler options.

A bind uses the Database Request module(s) from the DB2 precompile step as input and produces an application plan. It also checks the user's authority and validates the SQL Statements in the DBRM.

2. Whenever a table is dropped, all privileges on the table, all referential constraints in which the table is a parent or dependent, and all synonyms, views, and indexes defined on the table are also dropped. If the table space for the table was implicitly created, it is also dropped.

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu