tecnokrat Warnings : 1 Active User
Joined: 22 May 2009 Posts: 160 Location: Bangalore
|
|
|
|
Hi,
I'm trying to insert multi-rows using the below query
Code: |
INSERT INTO TABLEA
(COL1,COL2,COL3,COL4....COL9)
VALUES
(VAL11,VAL12,VAL13,VAL14,.....VAL19),
(VAL21,VAL22,VAL23,VAL24,.....VAL29),
(VAL31,VAL32,VAL33,VAL34,.....VAL39),
(VAL41,VAL42,VAL43,VAL44,.....VAL49);
|
But i'm receiving error
Code: |
DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL ",". SOME SYMBOLS THAT MIGH
BE LEGAL ARE: FOR <END-OF-STATEMENT> NOT ATOMIC
DSNT418I SQLSTATE = 42601 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNHPARS SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 3 0 0 -1 380 502 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'00000003' X'00000000' X'00000000' X'FFFFFFFF'
X'0000017C' X'000001F6' SQL DIAGNOSTIC INFORMATION
|
I tried by using the FOR n ROWS option also still the same error.[/code] |
|