Re: sql union to control test results?

[Simon Coulter <shc@xxxxxxxxxxxxxxxxx>]

On 07/07/2010, at 6:11 PM, David FOXWELL wrote:

> Job shows :
> Modifications en instance de validation pour fichier T1 de QT047551.
> Objet T1 de QTEMP type *FILE non créé car opération en instance.
>
> Which means the file isn't created because an operation is being  
> validated.
>
> What can this mean?

You might get better answers if you bothered to show the message ID so  
people could look up the actual message on their system instead of  
guessing from a translation.

Still SQLCODE -679 converts to message ID SQL0679 and the second level  
text of that message tells you that:
	a) you're running under commitment control
and
	b) a preceding operation has not been committed

So does that help? The second-level text is very clear (at least in  
English) about the likely causes and when applied to your example code  
the cause seems obvious.

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