Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2002
    Posts
    165

    Unanswered: Mystic-db2cmd on AIX

    When I try to write SQL command on AIX from db2cmd,for example,
    db2 select * from sysibm.systables

    I always get similar error;
    SQL0104N An unexpected token "dead" was found following "ct backup
    db2profile". Expected tokens may include: "FROM". SQLSTATE=42601

    db2profile is file and backup is directory in my home on AIX.

    But,same command running into db2clp ( by entering db2)
    works fine.

    Is anybody has any experiance about that?
    Is "*" maybe reserved sign on AIX?

    Thanks for advice,Zvonimir

  2. #2
    Join Date
    Jan 2003
    Posts
    1,605

    Re: Mystic-db2cmd on AIX

    Have u tried to write commands in quoting marks:
    db2 "select * from sysibm.systables"


    Originally posted by zkajfez
    When I try to write SQL command on AIX from db2cmd,for example,
    db2 select * from sysibm.systables

    I always get similar error;
    SQL0104N An unexpected token "dead" was found following "ct backup
    db2profile". Expected tokens may include: "FROM". SQLSTATE=42601

    db2profile is file and backup is directory in my home on AIX.

    But,same command running into db2clp ( by entering db2)
    works fine.

    Is anybody has any experiance about that?
    Is "*" maybe reserved sign on AIX?

    Thanks for advice,Zvonimir

  3. #3
    Join Date
    Jan 2002
    Posts
    165
    I am obviously ignorrant.
    I remembered when I saw Your mail,thanks!

Posting Permissions

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