Results 1 to 7 of 7

Thread: syntax error

  1. #1
    Join Date
    Oct 2008
    Posts
    11

    Unanswered: syntax error

    Hello,

    I am executing the following command but i am getting error


    C:\Documents and Settings\jane>db2 "bind c:/program~/ibm/sqllib/bnd/@ddcs400.lst blocking all sqlerror continue messages mvs.msg grant public"

    but i keep getting this error
    SQL0104N An unexpected token "files/ibm/sqllib" was found following
    "<identifier>". Expected tokens may include: "ACTION". SQLSTATE=42601

    thanks.

    Jane

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    The error message does not seem to correspond to the command you've shown. What is the actual command that you are running and the actual error message?
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Oct 2008
    Posts
    11
    this is the actual syntax that i am executing

    db2 "bind c:/program~/ibm/sqllib/bnd/@ddcs400.lst blocking all sqlerror continue messages mvs.msg grant public"

    this is the exact error:

    SQL0104N An unexpected token "files/ibm/sqllib" was found following
    "<identifier>". Expected tokens may include: "ACTION". SQLSTATE=42601

  4. #4
    Join Date
    May 2007
    Location
    somewhere in dbforums
    Posts
    221
    There seems to be some problem in the lst file (@ddcs400.lst)..... it would be more helpful if you post the contents of the same.

  5. #5
    Join Date
    Oct 2008
    Posts
    11
    hi nick,

    here is the contents of the ddcs400.lst

    db2ajgrt.bnd+
    db2clipk.bnd+
    db2clist.bnd+
    db2clpcs.bnd+
    db2clprr.bnd+
    db2clpur.bnd+
    db2clpnc.bnd+
    db2clprs.bnd+
    db2arxcs.bnd+
    db2arxrr.bnd+
    db2arxrs.bnd+
    db2arxnc.bnd+
    db2arxur.bnd+
    db2uexpm.bnd+
    db2uimpm.bnd+
    db2ueiwi.bnd+
    db2uimtb.bnd


    thanks.

    Jane

  6. #6
    Join Date
    Apr 2008
    Posts
    39
    syntax to bind utilities is as follows.

    bind path/bnd/@ddcsmvs.lst blocking all sqlerror continue
    messages mvs.msg grant public

    where path corresponds to the DB2PATH registry value.

    Check if you have set the DB2PATH registry variable.

    Thanks,
    Madhavi

  7. #7
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    As an alternative, change to the sqllib/bnd/ directory and execute the bind inside that directory without specifying the path.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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