TimPierce
Reputable Poster
Hi List,
I have an update statement in a NER that is giving a different SQL Statement (obtained from jdedebug.log) in two different environments.
The ER Update is exactly the same but one environment is adding an extra SQL line checking the IOLOTS field (as below). There are table triggers on the F4108 but it doesn't look like these are adding the extra line. Where else could the IOLOTS line have come from?
Development Environment
UPDATE TESTDTA.F4108
SET IOMMEJ=0,
IOUSER='TPIERCE',
IOPID='N550003',
IOUPMJ=107061,
IOTDAY=104138.000000,
IOJOBN='ARROWCLT10',
IOLRP1='FIN',
IOBBDJ=0,
IOSBDJ=0,
IOU1DJ=0
WHERE ( IOLOTN = 'TEST7 '
AND IOITM = 103805.000000
AND IOMCU = ' MAL1' )
AND ( IOLOTS NOT BETWEEN ' ' AND ' ' )
Production Environment
UPDATE TESTDTA.F4108
SET IOMMEJ=0,
IOUSER='TPIERCE',
IOPID='N550003',
IOUPMJ=107061,
IOTDAY=104138.000000,
IOJOBN='ARROWCLT10',
IOLRP1='FIN',
IOBBDJ=0,
IOSBDJ=0,
IOU1DJ=0
WHERE ( IOLOTN = 'TEST7 '
AND IOITM = 103805.000000
AND IOMCU = ' MAL1' )
I have an update statement in a NER that is giving a different SQL Statement (obtained from jdedebug.log) in two different environments.
The ER Update is exactly the same but one environment is adding an extra SQL line checking the IOLOTS field (as below). There are table triggers on the F4108 but it doesn't look like these are adding the extra line. Where else could the IOLOTS line have come from?
Development Environment
UPDATE TESTDTA.F4108
SET IOMMEJ=0,
IOUSER='TPIERCE',
IOPID='N550003',
IOUPMJ=107061,
IOTDAY=104138.000000,
IOJOBN='ARROWCLT10',
IOLRP1='FIN',
IOBBDJ=0,
IOSBDJ=0,
IOU1DJ=0
WHERE ( IOLOTN = 'TEST7 '
AND IOITM = 103805.000000
AND IOMCU = ' MAL1' )
AND ( IOLOTS NOT BETWEEN ' ' AND ' ' )
Production Environment
UPDATE TESTDTA.F4108
SET IOMMEJ=0,
IOUSER='TPIERCE',
IOPID='N550003',
IOUPMJ=107061,
IOTDAY=104138.000000,
IOJOBN='ARROWCLT10',
IOLRP1='FIN',
IOBBDJ=0,
IOSBDJ=0,
IOU1DJ=0
WHERE ( IOLOTN = 'TEST7 '
AND IOITM = 103805.000000
AND IOMCU = ' MAL1' )