| Author |
Message
|
| ajomillar |
 Posted: Mon Apr 18, 2005 8:24 am Post subject: ESQL editor for MQSI v2.1 |
 |
|
Centurion
Joined: 22 Aug 2003
Posts: 121
Location: Milwaukee, WI
|
Still living in the dark ages  with v2.1 but I'd like to use an editor for writing ESQL that performs validation on the syntax -- similar to the Control Center ESQL editor. Is there a jEdit or Eclipse plug-in available? I know that moving to Message Broker v5 will help but my company is not in a position to migrate any time soon. |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Mon Apr 18, 2005 8:33 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
I was able to create some syntax highlighting rules for VisualSlick, based on the 2.1 documentation.
But I don't have those any more, and they weren't "exportable" anyway.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| mqmatt |
| Posted: Mon Apr 18, 2005 8:49 am Post subject: Re: ESQL editor for MQSI v2.1 |
|
|
Grand Master
Joined: 04 Aug 2004
Posts: 1213
Location: Hursley, UK
|
| AJM wrote: |
| Is there a jEdit or Eclipse plug-in available? I know that moving to Message Broker v5 will help but my company is not in a position to migrate any time soon. |
If you have access to the v5 Message Broker Toolkit you could always use the v5 ESQL editor, then cut and paste back into the compute node?
So long as you remove any references to v5 only constructs (e.g. schema/module references).
Note that you can manage your v2.1 domain from the v5 toolkit/Config Manager, so you could do all your editing in the shiny new toolkit, yet keep your brokers at v2.1 
-Matt |
|
| Back to top |
|
|
| ajomillar |
| Posted: Mon Apr 18, 2005 10:58 am Post subject: |
|
|
Centurion
Joined: 22 Aug 2003
Posts: 121
Location: Milwaukee, WI
|
| I've heard that working in v5.0 is easier. This means I'll have to remove the v2.1 instance on my laptop before installing v5 toolkit. Correct? |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Mon Apr 18, 2005 11:06 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
You can, carefully, coexist the Toolkit with the ControlCenter.
You can not coexist configmgrs or brokers between different versions.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| kirani |
| Posted: Mon Apr 18, 2005 9:51 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
If you search this site, you will find references to configuring your machine to run V5 toolkit and the ControlCenter.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| xprezons |
| Posted: Tue May 17, 2005 11:18 am Post subject: |
|
|
Novice
Joined: 02 Sep 2004
Posts: 16
Location: UK
|
If you are happy with *syntax highlighting* try saving the ESQL code in a text file and give it a .sql extension and then open it using jEdit. You should be happy with what you see.
jEdit has syntax colouring mode enabled by default for .sql. This should work for most of the syntax. You have the option of creating a new mode for ESQL by making a copy of the pl-sql.xml file in the [jEdit-install]/mode directory and edit it to suit your needs.
Let me know if you are unable to get this working. |
|
| Back to top |
|
|
| fschofer |
| Posted: Wed May 18, 2005 6:49 am Post subject: |
|
|
Knight
Joined: 02 Jul 2001
Posts: 524
Location: Mainz, Germany
|
|
| Back to top |
|
|
|
|
