FOR THIS PORTION OF CODE:
If ( db2Result.IsResultSetAvailable = True ) Then
sqlupd$ = "UPDATE " & stationMastTb$ & "SET UPD_USERID = " & lastUser$ & " FULL_NAM = " & insStName$ & " WHERE ID_PREFIX = " & idPrefix$ & " And LAST_UPD_TS = " & lastDateTime$ & " And ID_REST = " & insStNum$ & “;”
db2Query.SQL = Ucase( sqlupd$ )
db2Result.Execute
End If
Exit Sub
I GET THIS ERROR:
Error message: INSPECTION STATIOND09013A had DB2 error in BUILD_MVI_STATION_MAST_TB as follows… [IBM][CLI Driver][DB2] SQL0104N An unexpected token “FULL_NAM” was found following “”. Expected tokens may include: “, WITH WHERE QUERYNO”. SQLSTATE=42601
SQL Statement was... UPDATE SYSADMA.MV_MISC_DATA_TB SET UPD_USERID = SHERIKA FULL_NAM = 'DO NOT DELETE ' WHERE ID_PREFIX = 'MV' AND LAST_UPD_TS = '2008-07-15-12.01.00.000000' AND ID_REST = 'D09013A ';
Someone please help me see what I’m not seeing.