The developerworks page describes the preview - the final information is at
I agree with Luis - SQL0104 is the right message - however, I find this
message to be not as helpful as it could - it tells you what the "token"
is that made it fail, not the position - sometimes there are several
instances of the "token".
There is an SQL statement analyzer that DOES give the position. I use
that in our DOCSQL command's validity checker. It's part of a product,
so I can't say much more than that. It's easy enough to do, of course.
As to being a diagnostic - that may be how it is reported in an
interactive command-line setting. Did you run it in a batch or
Oh, yeah - RUNSQL does NOT run a SELECT - so this is very much like
RUNSQLSTM, with that troublesome (IMHO) restriction.
On 11/13/2012 6:40 AM, Luis Rodriguez wrote:
At the end of the developerWorks page you cited, there is a "Comments"
link. Of of those comments explains that the command has no Help Text due,
mainly, to the need to translate it into several languages (and providing
multiple PTFs for them). It seems that the help text would arrive with the
next release .
Also, did you check the command with a valid SQL statement that, for
instance, tried to use an invalid file name? SQL0104 is, I think, the
proper message for the statement you wrote :-)
IBM Certified Systems Expert — eServer i5 iSeries