Dynamic SQL - "MERGE INTO......"

anurag

Hi,
Is "MERGE INTO..." statement allowed to be executed in a dynamic SQL
statement, inside an SQL Stored Procedure?

I am using DB2 UDB 8.1.2 on Windows.

If it is not allowed (as I suspect), how do I go about converting an
Oracle Procedure that dynamically executes "MERGE INTO..."?
ONE RESTRICTION: My converted code has to execute faster than the
Oracle SP (everything else being the same).

TIA..................anurag

Nov 12 '05 #1

Knut Stolze

anurag wrote:

Hi,
Is "MERGE INTO..." statement allowed to be executed in a dynamic SQL
statement, inside an SQL Stored Procedure?

I am using DB2 UDB 8.1.2 on Windows.

If it is not allowed (as I suspect), how do I go about converting an
Oracle Procedure that dynamically executes "MERGE INTO..."?
ONE RESTRICTION: My converted code has to execute faster than the
Oracle SP (everything else being the same).

MERGE is allowed, at least I am using it in a procedure that runs on 8.1.6
without any problems.

--
Knut Stolze
Information Integration
IBM Germany / University of Jena

Nov 12 '05 #2

anurag

Thanks Knut,
I was able to execute the SP (on 8.1.2) just after I made this post :>)

............anurag

Knut Stolze <st****@de.ibm.com> wrote in message

MERGE is allowed, at least I am using it in a procedure that runs on 8.1.6
without any problems.

Nov 12 '05 #3

anurag

Thanks Knut,
I was able to execute the SP (on 8.1.2) just after I made this post :>)

............anurag

Knut Stolze <st****@de.ibm.com> wrote in message

MERGE is allowed, at least I am using it in a procedure that runs on 8.1.6
without any problems.

Nov 12 '05 #4