| Author |
Message
|
| akil |
 Posted: Wed Jun 17, 2015 7:02 am Post subject: IIB9: ESQL Fiddle |
 |
|
Partisan
Joined: 27 May 2014
Posts: 338
Location: Mumbai
|
Hi
Is there something like the following for ESQL?
http://sqlfiddle.com/
Is there a runtime available to invoke and interpret ESQL statements?
_________________
Regards |
|
| Back to top |
|
 |
| smdavies99 |
| Posted: Wed Jun 17, 2015 10:29 am Post subject: Re: IIB9: ESQL Fiddle |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
Why?
| Quote: |
Is there a runtime available to invoke and interpret ESQL statements? |
Why would you want to do this? You must have some reasons. Care to share them with us?
_________________
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 |
|
|
| mqjeff |
| Posted: Wed Jun 17, 2015 10:42 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| akil wrote: |
| Is there a runtime available to invoke and interpret ESQL statements? |
Yes.
IIB. |
|
| Back to top |
|
|
| akil |
| Posted: Wed Jun 17, 2015 6:01 pm Post subject: |
|
|
Partisan
Joined: 27 May 2014
Posts: 338
Location: Mumbai
|
Hi
A fiddle can make learning the language fun and faster. The build / deploy / trace cycle is long . I think I would have saved a couple of hours yesterday when I was trying to learn / practice the field patterns in ESQL.
It helps to share snippets of code, when one is asking questions in a forum or giving an answer.
Regards
_________________
Regards |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Wed Jun 17, 2015 10:04 pm Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
| akil wrote: |
Hi
A fiddle can make learning the language fun and faster. The build / deploy / trace cycle is long . I think I would have saved a couple of hours yesterday when I was trying to learn / practice the field patterns in ESQL.
It helps to share snippets of code, when one is asking questions in a forum or giving an answer.
Regards |
The fiddle is IMHO called real learning. Doing for yourself and not just relying upon the word of 'some guy/gal on the internet' makes you understand it all a lot more clearly.
The snippets of code should all go into your toolbox (or in my case a Git repo) to be kept for future reference.
That couple of hours you spent yesterday will stay with you a lot longer than if you had just cut/paste some code from here.
Just my £0.02 of thoughts on the subject.
_________________
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 |
|
|
| akil |
| Posted: Thu Jun 18, 2015 12:01 am Post subject: |
|
|
Partisan
Joined: 27 May 2014
Posts: 338
Location: Mumbai
|
I agree, in-fact the fiddle promotes it .
Yesterday, when I was doing some variations on the field selection, i had to do a change, deploy , run a message flow , see the trace (or debug), & then start over.. this takes 5 mins for 1 round .. and at times the debugger gets stuck (ubuntu 9.0.0.2), for which i've to restart the broker, which is like another 5 mins..
The fiddle would save me those 5 mins per iteration .. with around 15 cases, it's a 45 min wait cycle.!
_________________
Regards |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Thu Jun 18, 2015 1:43 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
| akil wrote: |
I agree, in-fact the fiddle promotes it .
Yesterday, when I was doing some variations on the field selection, i had to do a change, deploy , run a message flow , see the trace (or debug), & then start over.. this takes 5 mins for 1 round .. and at times the debugger gets stuck (ubuntu 9.0.0.2), for which i've to restart the broker, which is like another 5 mins..
The fiddle would save me those 5 mins per iteration .. with around 15 cases, it's a 45 min wait cycle.! |
Ah that apology for Linux called Ubuntu. (sorry personal gipe with it).
5 minutes? Debugger gets stuck? Hmmmm...... Perhaps that is why I never use the debugger. Yes I'm an old school  But with a script to start user trace, another script to stop it and format the log AND send it to EMACS I can cycle things very quickly.
Served me well since the MQSI 2.0.2 days and having only command line access to the Unix Server. no debugger back then either.
I have a VM with a 'fiddle broker' all setup on it. The TK is integrated with my GIT repo of 'useful stuff'. Job Done (IMHO).
But hey, each to their own style and way of working. Whatever suits you is best for you.
_________________
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 |
|
|
| missing_link |
| Posted: Thu Jun 18, 2015 2:00 am Post subject: |
|
|
Acolyte
Joined: 08 Jan 2004
Posts: 60
|
nice to see i'm not the only
usertrace over debugger every time for me. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Thu Jun 18, 2015 5:51 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
A simple message flow with an MQInput and MQOutput node and single compute node is an excellent way to learn ESQL fast and easy.
Drag&drop to build and deploy is not terribly "hard" to my way of thinking.
Yes, something akin to the DFDL Test environment would be useful... but ESQL is much more complicated and has much more dependencies on the runtime environment. It's hard to access fields in the message tree without a message tree. |
|
| Back to top |
|
|
|
|
