Are you not able to use a reference to another table when executing an update procedure.
I am trying to update a column but I am getting errors in my SQL statement.
I am using a DB2 database.
My example:
UPDATE W17G.INVOICE
SET REV_ROLE = 'CS'
FROM W17G.V_SCI001 INNER JOIN W17G.INVOICE ON
W17G.V_SCI001.USER_ID = W17G.INVOICE.ROUTE_LST AND
W17G.V_SCI001.VCKVAL = W17G.INVOICE.VEND_ID AND
W17G.V_SCI001.POKVAL = W17G.INVOICE.PO_NUMBER;
[sig][/sig]
I am trying to update a column but I am getting errors in my SQL statement.
I am using a DB2 database.
My example:
UPDATE W17G.INVOICE
SET REV_ROLE = 'CS'
FROM W17G.V_SCI001 INNER JOIN W17G.INVOICE ON
W17G.V_SCI001.USER_ID = W17G.INVOICE.ROUTE_LST AND
W17G.V_SCI001.VCKVAL = W17G.INVOICE.VEND_ID AND
W17G.V_SCI001.POKVAL = W17G.INVOICE.PO_NUMBER;
[sig][/sig]