1. it is a good practice to always list the columns....then the associated 1
to 1 for the values.

2. your values are listed twice separated by a comma.......

Cheers,

-----Original Message-----
From: Hines Mel L
[mailto:db2udbdba-ezmlmshield-x56638759.[Email address protected]
Sent: Thursday, February 21, 2008 4:30 PM
To: LazyDBA Discussion
Subject: simple insert failing

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





---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a dba
job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com To
unsubscribe: http://www.lazydba.com/unsubscribe.html



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