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
Register Hereor login if you are already a member
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