DBAs,



I am attempting to perform the following insert with WinSQL - seems
simple, but it is failing:



insert into PRTHD.appl_trap VALUES ('EG', 'F', 'HOSTLOAD', 'HOSTLOAD',
'EGPB03I', '194', 'Y'), ('EG', 'F', 'HOSTLOAD', 'HOSTLOAD', 'EGPB03I',
'100', 'Y');



I get the following when:



Error: SQL0104N An unexpected token "," was found following "".
Expected tokens may include: "<END-OF-STATEMENT>". SQLSTATE=42601

(State:42601, Native Code: FFFFFF98)



I get similar errors in db2 connect. (included field names in another
attempt, but the values above match one-to-one fields as they are
displayed.



Thanks,

Mel




DB2 & UDB email list listserv db2-l LazyDBA home page