Results 1 to 2 of 2
  1. #1
    Join Date
    May 2012
    Posts
    155

    Unanswered: Perhaps syntax error?

    Hallo everyone,

    I would like to have all the MQT-Tables in pending state if LOAD is run in the "parent" table. To do so:

    LOAD FROM myCursor OF CURSOR INSERT INTO ${SCHEMA}.${TAB} NONRECOVERABLE CHECK PENDING CASCADE IMMEDIATE

    db2 gave me an error:
    DB21031E The SQL statement using the cursor "MYCURSOR" ("SQLCUR1") returned:
    SQL0104N An unexpected token "LOAD" was found following "ratna_temp". Expected tokens may include: "UNION". SQLSTATE=42601

    Could someone please help? Thank you.

    Regards,
    Ratna

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    You need to supply ALL of the script you are trying to run. I suspect a statement termination problem.

    Andy

Posting Permissions

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