Binding Cobol Db2 Program

K_SUBBARAO · New User Joined: 26 Apr 2005 Posts: 1 Location: Bangalore

:|
When i try to bind a Cobol Db2 program I'am getting Authorisation error
when check with system admin he says authorisation is given but syntax error gives authorisation erroris it true.
Compile is ok with maxcc=0

vaduri · New User Joined: 19 Apr 2005 Posts: 2 Location: Hyderabad

Is it saying
-DB2T BIND SQL ERROR
USING ****** AUTHORITY ???

It is not actually the problem with the access.
You can find out the exact problem with the help of SQLCODE, SQLSTATEMENT and Last but not least the TOKENS.
For example, if the column in the table EMP_NO and you have coded your program as SELECT EMP-NO ...., then the bind step will return the error with relevant SQLCODE and STATEMENT number and the TOKEN as EMP-NO.

Vamsi.......
"Life is a do-yourself project "