I have a table called 'employee' with one column called 'name', a varchar.
If I execute the following insert statements:
insert into employee(name) values ('jones')
insert into employee(name) values ('smith')
insert into employee(name) values ('billy-bob')
.. . . they work, no problem. If I execute the following:
insert into employee(name) values ('jones'),('smith'),('billy-bob')
.. . . I get an error which says the comma after ('jones') is an unexpected
token. However, this works on db2 for other platforms. I am using db2 v8.1
on zOS from an xp client connected through cli. Any reason why the above
statement would not work on db2 for zOS?
Thanks.
-g