Multi-Row Inserts on DB2 for zOS

[geoff]

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'),('smi th'),('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

[Serge Rielau]

geoff wrote:

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'),('smi th'),('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?

Not supported on DB2 for zOS. If you're goin in through CLI, take a look
at array/buffered inserts.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
DB2 UDB for Linux, Unix, Windows
IBM Toronto Lab

[geoff]

> Not supported on DB2 for zOS. If you're goin in through CLI, take a look

at array/buffered inserts.

.. . . but with an array insert, say, 10 values, it executes 10 insert
statements, right?

-g

[Serge Rielau]

geoff wrote:

Not supported on DB2 for zOS. If you're goin in through CLI, take a look
at array/buffered inserts.

. . . but with an array insert, say, 10 values, it executes 10 insert
statements, right?

That is correct from the SQL point of view
But there is only one flow from the client to the server.
It's as if the INSERTs executed within a procedure.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
DB2 UDB for Linux, Unix, Windows
IBM Toronto Lab