| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Message Flow ESQL can't find Functions in a Library |
« View previous topic :: View next topic » |
| Author |
Message
|
| EricCox |
 Posted: Thu Jul 02, 2015 7:37 am Post subject: Message Flow ESQL can't find Functions in a Library |
 |
|
Master
Joined: 08 Apr 2011
Posts: 292
|
To all,
I had a Message Broker project with ESQL files that have FUNCTIONS in them. When the regular Message Flow project needed them, with a Project Reference, it found them no problem.
Now I moved them into a Library to be deployed in an Application. When I moved the, for instance, dateFunctions.esql into the CommonLibrary the Message Flow esql can't find them. It says Incorrect Function or Procedure name.
Does anyone have a hint on how to fix the reference to these ESQL functions?
These are not BROKER SCHEMA qualified. So I think they fall in the default, no schema/namespace category.
Any hints on what to look for will be greatly appreciated.
Thanks,
Eric |
|
| Back to top |
|
 |
| Vitor |
| Posted: Thu Jul 02, 2015 7:48 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
Is the Library referenced by the Application?
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| EricCox |
| Posted: Thu Jul 02, 2015 8:01 am Post subject: Yes |
|
|
Master
Joined: 08 Apr 2011
Posts: 292
|
Vitor,
Yes it is. In Project | References CommonLibrary is checked. |
|
| Back to top |
|
|
| EricCox |
| Posted: Thu Jul 02, 2015 8:10 am Post subject: Before and After |
|
|
Master
Joined: 08 Apr 2011
Posts: 292
|
Before they were prefaced by datefunctions.functionname and it worked in a regular Message Broker Project referenced by a Message Broker Flow Project.
Now I had to remove the datefunctions.functionname preface and it compiles.
It seems to know where to find each function even though they are divided up into different categories in the .esql.
datefunctions.esql
stringfunctions.esql
etc...
Thanks Vitor |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Thu Jul 02, 2015 8:54 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20697
Location: LI,NY
|
V9 does not like stuff in libraries that is not schema qualified.
You'll make your life a lot easier if you put the ESQL in a schema and add the path command to the top of your ESQL calling file(s).
Have fun 
_________________
MQ & Broker admin |
|
| 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
|
|
|
|
