|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
 |
|
ESQL INTERVAL CONSTANT |
« View previous topic :: View next topic » |
Author |
Message
|
smdavies99 |
Posted: Tue Jul 30, 2013 5:24 am Post subject: ESQL INTERVAL CONSTANT |
|
|
 Jedi Council
Joined: 10 Feb 2003 Posts: 6076 Location: Somewhere over the Rainbow this side of Never-never land.
|
Environment Tooklit 7.0.0.4,
runtime 7.0.0.4 Windows,
effective runtime 7.0.0.4
IF I put the following in the ESQL I can build the bar file but when I deploy it, it fails with the following error.
Code: |
--
-- Constants for Range Limit Checks
DECLARE intBegin CONSTANT INTERVAL '30' MINUTE;
DECLARE intEnd CONSTANT INTERVAL '6' HOUR;
|
Code: |
BIP2401E: (.ZOMBIE_CHK, 11.34) : Syntax error : expected '' but found ''.
The expected token was not found.
Correct the syntax of your ESQL expression in node '.ZOMBIE_CHK', around line and column '11.34', then redeploy the message flow.
|
I can't seem to find anything about interval constants not being allowed so are they? _________________ 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 |
|
 |
lancelotlinc |
Posted: Tue Jul 30, 2013 5:26 am Post subject: |
|
|
 Jedi Knight
Joined: 22 Mar 2010 Posts: 4941 Location: Bloomington, IL USA
|
There is an APAR for 7.0.0.4 toolkit that improves schema scope error support. It was the result of a similar PMR that I opened about a year ago to better catch errors at schema import time rather than deploy time. You might like to update to 7.0.0.5 as I believe that APAR made it into 7.0.0.5. _________________ http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
Back to top |
|
 |
mqjeff |
Posted: Tue Jul 30, 2013 7:20 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008 Posts: 17447
|
Toolkit also has a bad habit of adding blank lines to the top of an ESQL file, which can invalidate the ESQL file as far as the Toolkit compiler is concerned.
Which would cause the file to not get added to the bar file. |
|
Back to top |
|
 |
smdavies99 |
Posted: Tue Jul 30, 2013 8:03 am Post subject: |
|
|
 Jedi Council
Joined: 10 Feb 2003 Posts: 6076 Location: Somewhere over the Rainbow this side of Never-never land.
|
If I comment out those lines and only those lines, it deploys correctly. _________________ 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 |
|
 |
|
|
 |
|
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
|
|
|
|