Re: RUNSQL Command: Help & Escape Messages

Vern,

I put it in a CL program, which I called from both QCMD and with SBMJOB.
Both resulted in only a SQL0104 diagnostic message.

I ran this, which succeeded, as expected:
RUNSQL SQL('create table qtemp/mytable as (select * +
from QIWS/QCUSTCDT) with no data') +
COMMIT(*NONE)

Then I ran this, which failed with SQL0204, which is the right message,
but still only a diagnostic:
RUNSQL SQL('create table qtemp/mytable as (select * +
from ZZZZ/QCUSTCDT) with no data') +
COMMIT(*NONE)
And just for completeness, I did a SBMJOB, with the same result.

I posted a comment on the developerWork site.

Sam

On 11/13/2012 7:07 PM, Vernon Hamberg wrote:

Sam

Are you running the command only from a command line? It might not throw
an escape message there - some commands are like that. Try it in a program.

Vern

On 11/13/2012 4:38 PM, Sam_L wrote:

Luis,

SQL0104 is the correct message, but it a diagnostic. I think that if
your statement fails, then you should get an escape message, and the
developerWorks documentation seems to agree.

I'll do a little more experimentation, but so far I have failed to get
it to throw an escape message.

I did not notice the comment link--thanks. Seems a reasonable
explanation of the missing help.

Sam

On 11/13/2012 7:40 AM, Luis Rodriguez wrote:

Sam,

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 :-)

Best Regards,


Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries