467,198 Members | 1,111 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,198 developers. It's quick & easy.

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

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
  • viewed: 4292
Share:
3 Replies
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
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
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.

Similar topics

2 posts views Thread by newbie_mw | last post: by
1 post views Thread by mcmreddy@gmail.com | last post: by
5 posts views Thread by Janick Bernet | last post: by
3 posts views Thread by shifty shaker | last post: by
3 posts views Thread by =?Utf-8?B?QWxleCBNYWdoZW4=?= | last post: by
6 posts views Thread by ewpatton@gmail.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.