View previous topic :: View next topic
|
Author |
Message |
madhugoodboy
New User
Joined: 24 Jan 2006 Posts: 12
|
|
|
|
Hi All,
Can antbody tell me where exactly the syntax checking will be done
for a cobol-db2 program (i mean whether in the precompilation or in the Bind process.
Great thanks if you give the solution in Advance.
Thanks & Regards
Madhu |
|
Back to top |
|
|
psreddy Currently Banned New User
Joined: 18 May 2006 Posts: 4
|
|
|
|
hi madhu,
syntax check will be done in both situations..... |
|
Back to top |
|
|
madhugoodboy
New User
Joined: 24 Jan 2006 Posts: 12
|
|
|
|
Hi PSR,
Can you please explain what exactly will happened on each stage in detail.
Thanks & Regards
Maadhu |
|
Back to top |
|
|
twissi
Active User
Joined: 01 Aug 2005 Posts: 105 Location: Somerset, NJ
|
|
|
|
Hi Madhu,
At the precompile stage the syntax of the SQL statements will not be checked, but if you include the table declarations (DCLGENs) in the program the fields used in the SQL statements are validated, however this's not a syntax checking.
At the bind stage the SQL statements are checked for syntactical correctness and the errors (if any) will be placed in SYSTSPRT. The following things hold a key to resolving the error:
Code: |
STATEMENT=1270
SQLCODE=-138
SQLSTATE=22011 |
Cheers, Twissi. |
|
Back to top |
|
|
|