MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » November 2012

Re: RUNSQL Command: Help & Escape Messages



fixed

Sam

Thanks for running these - the lack of the promised exception makes this less useful. But IBM do listen, so I hope this can change.

Regards
Vern

On 11/13/2012 7:21 PM, Sam_L wrote:
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







Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact