Question
CF SQL update using ODBC/DB2 no update
The following will not update any of the ISSSxx fields but
will update ISTXYR. I am at a loss. The field names are correct.
The values can be retrieved from the DB2. I just can't update
them.;
<cfquery name="updtQry" datasource="AS400" dbtype="ODBC">
UPDATE istatic1
SET
ISTXYR = '1953',
ISSS02 = 'A',
ISSS04 = 'A',
ISSS05 = 'A',
ISSS06 = 'A',
ISSS07 = 'A',
ISSS08 = 'A',
ISSS09 = 'B',
ISSS10 = 'B',
ISSS11 = 'B',
ISSS12 = 'B',
ISSS13 = 'B',
ISSS14 = 'B',
ISSS15 = 'B',
ISSS16 = 'C',
ISSS17 = 'c',
ISSS18 = 'c'
WHERE isrec## =99505
</cfquery>
There are no errors and no log entries.
<cfquery name="updtQry" datasource="AS400" dbtype="ODBC">
UPDATE istatic1
SET
ISTXYR = '1953',
ISSS02 = 'A',
ISSS04 = 'A',
ISSS05 = 'A',
ISSS06 = 'A',
ISSS07 = 'A',
ISSS08 = 'A',
ISSS09 = 'B',
ISSS10 = 'B',
ISSS11 = 'B',
ISSS12 = 'B',
ISSS13 = 'B',
ISSS14 = 'B',
ISSS15 = 'B',
ISSS16 = 'C',
ISSS17 = 'c',
ISSS18 = 'c'
WHERE isrec## =99505
</cfquery>
There are no errors and no log entries.