var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: SQL5001N "*N" does not have the authority to change the database manager
I get this error when my application tries to execute a particular query:
The query is (using a sample query)
Select AT.Name from MYTABLE AT
SQL5001N "*N" does not have the authority to change the database manager
configuration file. SQLSTATE=42703
If I change Query to
Select BT.Name from MYTABLE BT
2 record(s) selected.
So the difference between 2 queries is the use of word AT .
I understand that this is a reserved word but if does work for some reserved words and not for others.
Any way to resolve this issue without having to change the query?
Always post your DB2 version and fixpack and operating-system.
See delimited-identifier info at
Identifiers - IBM DB2 9.7 for Linux, UNIX, and Windows
Tags for this Thread