Parameter marker in Select

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Karun - 26 Jun 2006 11:57 GMT

Hello,
How do we convert the following Oracle query to DB2

INSERT INTO Table2 VALUES( (SELECT ?, Col1, Col2 FROM TABLE2))

The SELECT query could return multiple rows.

Thanks,
Anoop

Reply to this Message

Serge Rielau - 26 Jun 2006 16:20 GMT

> Hello,
> How do we convert the following Oracle query to DB2
>
> INSERT INTO Table2 VALUES( (SELECT ?, Col1, Col2 FROM TABLE2))

First of all remove the VALUES, it's just wrong.
INSERT INTO Table2 SELECT ?, Col1, Col2 FROM TABLE2;
This may be sufficient. If it isn't this will work for sure:
INSERT INTO Table2 SELECT CAST(? AS <type>), Col1, Col2 FROM TABLE2;

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ondemandbusiness/conf2006/

Reply to this Message