| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| UDP property not updating for database stored procedure name |
« View previous topic :: View next topic » |
| Author |
Message
|
| visasimbu |
 Posted: Wed Apr 13, 2022 9:39 am Post subject: UDP property not updating for database stored procedure name |
 |
|
Disciple
Joined: 06 Nov 2009
Posts: 171
|
We have message flow which calls store procedure in the database. The stored procedure name and its schema will get change environment wise. Even some environments will have only stored procedure name without schemas.
We like to handle stored procedure name change, using UDP properties for each environment. Below is the code snippet which has stored procedure name as "ABC_DISABLE". This will get updated to "MASTERS.ABC_DISABLE".
Please help us on how to use UDP prop for this case.
| Code: |
CREATE COMPUTE MODULE switchCustomer_compute_request
CREATE FUNCTION Main() RETURNS BOOLEAN
BEGIN
...
CALL DISABLE(IN_CORP_ID,IN_USER_ID,OUT_MESSAGE,OUT_STATUS);
....
RETURN TRUE;
END;
END MODULE;
CREATE PROCEDURE DISABLE(IN IN_CORP_ID CHARACTER,IN IN_USER_ID CHARACTER,OUT OUT_MESSAGE CHARACTER,OUT OUT_STATUS CHARACTER)
LANGUAGE DATABASE
EXTERNAL NAME "ABC_DISABLE"; |
|
|
| Back to top |
|
 |
| timber |
| Posted: Thu Apr 14, 2022 1:04 am Post subject: |
|
|
Grand Master
Joined: 25 Aug 2015
Posts: 1280
|
| We are happy to help. What have you tried already? What happened? What do you need help with? |
|
| Back to top |
|
|
| visasimbu |
| Posted: Thu Apr 14, 2022 8:02 am Post subject: |
|
|
Disciple
Joined: 06 Nov 2009
Posts: 171
|
| I have tried to create UDP prop and set the prop on procedure where I am using Stored procedure name. This was not worked. |
|
| Back to top |
|
|
| timber |
| Posted: Tue Apr 19, 2022 1:51 am Post subject: |
|
|
Grand Master
Joined: 25 Aug 2015
Posts: 1280
|
You need to describe what you have done, in detail.
How did you create the UDP? (list the steps that you followed)
How did you set the value? (list the steps that you followed)
Have you followed any IBM docs? (if so, please list them) |
|
| 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
|
|
|
|
