| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
| IIB 9.0.0.3 Toolkit Bar file builder |
« View previous topic :: View next topic » |
| Author |
Message
|
| smdavies99 |
 Posted: Tue Aug 18, 2015 10:07 pm Post subject: |
 |
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
It does appear that the reason for this problem is down to the Stored procedure definitions. for example
| Code: |
CREATE PROCEDURE SLU_PROD_SKU(IN inXML CHARACTER, INOUT outXML CHARACTER)LANGUAGE DATABASE EXTERNAL NAME "SLU_PROD_SKU";
CREATE PROCEDURE SLU_PROD_DESCR (IN inXML CHARACTER, INOUT outXML CHARACTER)LANGUAGE DATABASE EXTERNAL NAME "SLU_PROD_DESCR";
|
Moving them to inside a COMPUTE 'Module' and the error reported followed the move.
It seems that the Barfile editor is not detecting that the definitions refer to a DB Stored proc and is looking for an esql definition of the same name.
This is a definite change since V7.
I'll do some more testing and report back here.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
 |
| fjb_saper |
| Posted: Wed Aug 19, 2015 3:00 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20767
Location: LI,NY
|
Depending on the user and DB you may have to add the DBSchema to the EXTERNAL NAME of the procedure... 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Wed Aug 19, 2015 4:10 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
| fjb_saper wrote: |
| Depending on the user and DB you may have to add the DBSchema to the EXTERNAL NAME of the procedure... |
If you mean changing it to look like this
| Code: |
CREATE PROCEDURE SLU_PROD_SKU(IN inXML CHARACTER, INOUT outXML CHARACTER)LANGUAGE DATABASE EXTERNAL NAME "dbo.SLU_PROD_SKU";
|
Then that makes no difference.
The builder seems to be ignoring the DATABASE part of the definition.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Wed Aug 19, 2015 4:38 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20767
Location: LI,NY
|
Does it make any difference if the line breaks are different?
| Code: |
CREATE PROCEDURE SLU_PROD_SKU(IN inXML CHARACTER, INOUT outXML CHARACTER)
LANGUAGE DATABASE
EXTERNAL NAME "dbo.SLU_PROD_SKU";
|
Just a thought... don't expect it to make any difference...
_________________
MQ & Broker admin |
|
| Back to top |
|
|
|
|
|
|
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
|
|
|
|
