Re: SQL results with RUNSQLSTM

["Rick Klopfer" <RIXONE@xxxxxxxxxx>]

Thanks -  will try and work with that!

----- Original Message -----
From: "Jim Essinger" <dilbernator@xxxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Date: Tue, 1 Apr 2008 08:06:49 -0600
Subject: Re: SQL results with RUNSQLSTM

> There is a spool file created by the job. That spool file has the info
> you are looking for. I'm not sure how you would access it in your
> program.
>
> Jim
>
>
>
> On 4/1/08, Rick Klopfer <rixone@xxxxxxxxxx> wrote:
> > Is there a way to log the SQL results of RUNSQLSTM?
> >
> > Have a RUNSQLSTM doing an UPDATE in a CL and need to know how many records
> > are being updated.  DSPJOBLOG simply shows that the SQL activity ran.  Is
> > there a particular setting I can use to get the results in the joblog -- 
or
> > is there a way to output the results directly into a message/log/file from
> > SQL?
> >
> > Thanks!
> >
> > --Rick
> >
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/midrange-l.
>
> -- 
> Sent from Gmail for mobile | mobile.google.com
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.