SQL9010 is: RUNSQLSTM command failed.

5 pts.
Tags:
RUNSQLSTM
SQL error messages
SQL Server
SQL9010 is: RUNSQLSTM command failed.

Answer Wiki

Thanks. We'll let you know when a new response is added.

The RUNSQLSTM produces a print file output.
Look at the bottom of the report to get the reason for the failure.
You have not given us enough information.
If you still hav a problem, Post the source for the RUNSQLSTM and then we can maybe help you

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • deepu9321
    There could be a problem in formation of your SQL statement. Will you post your SQL statement. So that it would be easy to figure out where the problem was occured.
    4,805 pointsBadges:
    report
  • carlosir
    Hi, I am getting the same error, can you help me please.        1         SELECT * FROM TABLE(QGPL.IFSDIR('/pdfprstub/rdy4notes'))                   
          2                  as t order by filename;                                           
                                     * * * * *  E N D  O F  S O U R C E  * * * * *             
    5770SS1 V7R1M0 100423               Run SQL Statements             S__00001SQ              
    Record  *...+... 1 ...+... 2 ...+... 3 ...+... 4 ...+... 5 ...+... 6 ...+... 7 ...+... 8   
    MSG ID  SEV  RECORD  TEXT                                                                  
    SQL0084  30       1  Position 9 SQL statement not allowed.                                 
    75 pointsBadges:
    report
  • ToddN2000
    According to IBM:

    Resolving the problem

    The command RUNSQLSTM ended with message SQL0084.

    Not all SQL statements can be processed using the RUNSQLSTM command. The 'SELECT' statement is one of those statements. STRQMQRY can be used to run a 'SELECT' statement. For a complete list of statement that can be processed using RUNSQLSTM, you should refer to the System i Database SQL Programming manual available in the InfoCenter.

    Full info on the SQL 0084 error is found here

    82,620 pointsBadges:
    report
  • TheRealRaven
    A SELECT statement generally makes no sense to run by itself. Selecting rows accomplishes nothing unless you have additional programming to actually do something with those rows. The RUNSQLSTM command provides no such additional programming. Any selected rows would do nothing but simply sit in their table.

    RUNSQLSTM is best used for SQL statements such as INSERT, UPDATE and DELETE that perform actual tasks.

    If you want to print or display selected rows, then you need a function that includes a report writer (or display). The commonly used command for that is STRQMQRY. Additional advantages are that STRQMQRY accepts parameters that can be used to alter all parts of any included statements and that reporting formats can be customized and saved for later use, possibly with different queries.
    21,845 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: