By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,851 Members | 1,668 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,851 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Share this Question
Share on Google+
3 Replies


P: n/a
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

P: n/a
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

P: n/a
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

This discussion thread is closed

Replies have been disabled for this discussion.