Re: RUNSQL Command: Help & Escape Messages

[Sam_L <lennon_s_j@xxxxxxxxxxx>]

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