Re: SQL error causes all batch jobs to fail

I'd bet Simon's on the money...

However, just wanted to note that if it were me, I'd be concerned
about other jobs being affected by the apparent differences in CCSID
handling between the schedulers.

You should double check, but it sounds like SYSAUTO was working in the
system's regular CCSID, whereas AUTOMATOR is running under some other
CCSID (37 perhaps?).

Charles

On Thu, Jun 18, 2009 at 7:30 AM, Simon Coulter<shc@xxxxxxxxxxxxxxxxx> wrote:

On 18/06/2009, at 7:36 PM, David FOXWELL wrote:

Automator saves the system, stops and restarts the subsytems then
passes control to SYSAUTO which continues with the jobs that ended
in error. Any use of SQL using !! instead of concat submitted by
SYSAUTO will fail. If submitted manually, no problem.

What sytem value could be changed by AUTOMATOR so that !! is no
longer recognised?

Most likely cause is a change in CCSID of the job.

You should never use the short form operator if you need it to work in
all CCSID environments. Similar with CL concatenation operators--
always use *CAT, *BCAT, *TCAT. Change your SQL to use concat() instead.

Regards,
Simon Coulter.
--------------------------------------------------------------------
   FlyByNight Software         OS/400, i5/OS Technical Specialists

   http://www.flybynight.com.au/
   Phone: +61 2 6657 8251   Mobile: +61 0411 091 400        /"\
   Fax:   +61 2 6657 8251                                   \ /
                                                             X
                 ASCII Ribbon campaign against HTML E-Mail  / \
--------------------------------------------------------------------



--
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.