inserts into in scripts db2
Publicado por moy (1 intervención) el 14/06/2006 02:32:12
I need run an script for insert rows in db2.
Example:
insert into CD (id, cdtitle, artist, country, price)
values (3, 'Kaira','Tounami Diabate', 'Mali',13.95)
insert into CD (id, cdtitle, artist, country, price)
values (4, 'The Lion is Loose','Eliades Ochoa', 'Cuba',12.95)
...
If i use ; at end of values, only I obtain 1 row inserted but if I not use ; db2 send me one error. The error is "SQL error at or before INSERT"
Example:
insert into CD (id, cdtitle, artist, country, price)
values (3, 'Kaira','Tounami Diabate', 'Mali',13.95)
insert into CD (id, cdtitle, artist, country, price)
values (4, 'The Lion is Loose','Eliades Ochoa', 'Cuba',12.95)
...
If i use ; at end of values, only I obtain 1 row inserted but if I not use ; db2 send me one error. The error is "SQL error at or before INSERT"
Valora esta pregunta


0