Pro*cobol Spurious nulls being updated into database

From: Steve Rainbird <steve.nospam.rainbird_at_mssint.nospam.com>
Date: Fri, 8 Jan 2010 21:04:04 -0000
Message-ID: <7qpku6F5d8U1_at_mid.individual.net>

I have a strange issue which I will probably report as a bug but thought i would pass by you guys 1st.

I have an update statement

EXEC SQL UPDATE HARDVER SET
HAR_IMEPRT=NVL(RTRIM(:HAR-IMEPRT),' ')
,HAR_IMETER=NVL(RTRIM(:HAR-IMETER),' ')
,HAR_WINDOW=NVL(RTRIM(:HAR-WINDOW),' ')
,HAR_TIPTER=NVL(RTRIM(:HAR-TIPTER),' ')
,HAR_TIPPRT=NVL(RTRIM(:HAR-TIPPRT),' ')
,HAR_CEKPRT=NVL(RTRIM(:HAR-CEKPRT),' ')
,HAR_MJESTO=NVL(RTRIM(:HAR-MJESTO),' ')
,HAR_TELBRO=NVL(RTRIM(:HAR-TELBRO),' ')
,HAR_PORUKA=NVL(RTRIM(:HAR-PORUKA),' ')
,HAR_POSJED=:HAR-POSJED
,HAR_KESBOY=:HAR-KESBOY
,HAR_AMBROJ=:HAR-AMBROJ
,HAR_PMBROJ=:HAR-PMBROJ
,HAR_STATUS=:HAR-STATUS
,HAR_REDBRO=:HAR-REDBRO
,HAR_UPDATE=:HAR-UPDATE
,HAR_SATMIN=:HAR-SATMIN
,HAR_TELLER=:HAR-TELLER
,HAR_CEKOVI=:HAR-CEKOVI
,HAR_PRTOFF=:HAR-PRTOFF

WHERE ROWID=:HARDVER-ROWID
END-EXEC All of the host variables have values in them.

For some reason HAR_PMBROJ is being updated with a null even thougth HAR-PMBROJ contains 84.

If I comment out one of the assignments above HAR_PMBROJ then HAR_PMBROJ is ok but the next column in the update statement HAR_STATUS gets a null. If I comment out 2 of the assignments above HAR_PMBROJ then HAR_REDBRO gets a null.

This is very strange and I have no idea why it is happening.

TIA

-- 
Steve 

Received on Fri Jan 08 2010 - 15:04:04 CST