| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| How to add the DSN in the DB2 stored procedure in ESQL |
« View previous topic :: View next topic » |
| Author |
Message
|
| wmb_wps_soa |
 Posted: Thu Mar 03, 2011 10:56 am Post subject: How to add the DSN in the DB2 stored procedure in ESQL |
 |
|
Acolyte
Joined: 19 Feb 2010
Posts: 65
Location: Detroit,Michigan,USA.
|
Hi Guys,
Is there any way to include the DSN/Database name in the DB2 stored procedure in ESQL? IF yes, could you please provide the details.
From the infocenter, we can have only the schema name and the storedprocedure name. It looks like below:
CREATE PROCEDURE db2storeprocedurecall(IN empNO CHARACTER,IN empType CHARACTER,IN OUT db2sqlcode INTEGER) LANGUAGE DATABASE EXTERNAL NAME "db2schema.db2storedprocedurename";
Could you anybody tell how can we include the DSN/Database in the db2 storeprocedure in ESQL?
Thank you
Jeba |
|
| Back to top |
|
 |
| mgk |
| Posted: Thu Mar 03, 2011 12:42 pm Post subject: |
|
|
Padawan
Joined: 31 Jul 2003
Posts: 1642
|
| Quote: |
| Is there any way to include the DSN/Database name in the DB2 stored procedure in ESQL? |
Yes, you specify it on the CALL not the CREATE PROCEDURE....
Regards
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
