ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » How to mess up the ESQL Editor

Post new topic  Reply to topic
 How to mess up the ESQL Editor « View previous topic :: View next topic » 
Author Message
smdavies99
PostPosted: Tue Jun 07, 2011 12:15 am    Post subject: How to mess up the ESQL Editor Reply with quote

Jedi Council

Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.

Toolkit 7.0.0.2 on Windows.

Open an ESQL file

Open a text editor and create some text like
Code:

CREATE PROCEDURE InsertEventPayload (
         IN P_MSG_ID          CHAR,      -- 01
         IN P_SERVICE_NAME       CHAR,      -- 02
         IN P_EVENT_TIME                CHAR,              -- 03
         IN P_BROKER_NAME       CHAR,      -- 04
         IN P_EXECGROUP_NAME        CHAR,                -- 05
         IN P_PAYLOAD_SIZE             DECIMAL,            -06
         NUL     -- 07
         )
LANGUAGE DATABASE
EXTERNAL NAME "PKG_PERFORMANCE.InsertEventPayload";

If you look closely, you can see that I have misstyped NULL as NUL AND missed off a '-' in a comment.
Now paste the text from the text editor into the ESQL Editor and hit ctrl/s.

Enjoy.

_________________
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
View user's profile Send private message
WMBDEV1
PostPosted: Tue Jun 07, 2011 1:37 am    Post subject: Reply with quote

Sentinel

Joined: 05 Mar 2009
Posts: 888
Location: UK

FWIW, nothing untoward happens on 7.0.0. Just a couple of red crosses.
Back to top
View user's profile Send private message
smdavies99
PostPosted: Tue Jun 07, 2011 1:44 am    Post subject: Reply with quote

Jedi Council

Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.

Thanks.
I'm on
Code:

Build id: 7.0.0.2-IFix-20110310_1127

I tried it three times. The editor barfs with a null pointer exception.
_________________
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
View user's profile Send private message
mqjeff
PostPosted: Tue Jun 07, 2011 2:13 am    Post subject: Reply with quote

Grand Master

Joined: 25 Jun 2008
Posts: 17447

Well.

Check for newer iFixes of Toolkit and then open a pmr?
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » How to mess up the ESQL Editor
Jump to:  



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
Protected by Anti-Spam ACP
 
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.