Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2010
    Posts
    40

    Unanswered: DB2SET on Command Prompt giving error

    On command prompt I typed

    DB2 DB2SET -all

    this is the error I got
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL0104N An unexpected token "END-OF-STATEMENT" was found following "DB2SET".
    Expected tokens may include: "JOIN <joined_table>". SQLSTATE=42601

    Any Idea what's going on?

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Quote Originally Posted by Rajesh1203 View Post
    DB2 DB2SET -all

    Did you actually enter "db2" prior to "db2set -all"?

  3. #3
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    In the Command Reference Manual, there are two types of commands:

    • CLP commands
    • System Commands

    System commands do not require (nor allow) you to preface them with "db2".
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  4. #4
    Join Date
    Aug 2010
    Posts
    40
    Quote Originally Posted by Marcus_A View Post
    In the Command Reference Manual, there are two types of commands:

    • CLP commands
    • System Commands

    System commands do not require (nor allow) you to preface them with "db2".
    Thanks Marcus, Tried as a system command without DB2 and it worked.

    BTW where can I find the command Reference Manual?

  5. #5
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by Rajesh1203 View Post
    BTW where can I find the command Reference Manual?
    Links to PDF Manuals are near the bottom of this page:
    IBM - DB2 database product documentation
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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