|
|
| Author |
Message |
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 |
|
| Back to top |
|
 |
References
|
Posted: Tue Apr 26, 2005 2:07 pm Post subject: Re: Binding Cobol Db2 Program |
 |
|
|
 |
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 " |
|
| Back to top |
|
 |
|
|