DB2-Bind time and Precompile errors

This might be good interview question and real time question. In the SQL query many times we get errors, of course, if you have good command on it, you can avoid those errors.

How checking syntax errors? this due to Validate(Bind)/Validate(Run) options.

Precompile validation:

All the SQL errors except those mentioned in the WHERE clause and INTO , validated during precompilation time.

Bind time validation:

The syntax errors in WHERE clause and INTO will be validated in BIND time. This is also called BIND time errors.

See the sample query:

Select col_1

     INTO :Column-b

From Table_1 a

          Table_2 b

where a.account_id=b.account_id

           a.prod_code=’B’.

Advertisements

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.