Re: SQL error causes all batch jobs to fail

[Simon Coulter <shc@xxxxxxxxxxxxxxxxx>]

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  / \
--------------------------------------------------------------------