Re: sql union to control test results?

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