Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2012
    Posts
    1

    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


    NAME
    ------------------------------
    ABC
    DEF

    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?

  2. #2
    Join Date
    Apr 2012
    Posts
    1,035
    Provided Answers: 18
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •