| Author |
Message
|
| zpat |
 Posted: Mon Mar 28, 2011 1:18 am Post subject: Excel macro for generating MQSC to define queues? |
 |
|
Jedi Council
Joined: 19 May 2001
Posts: 5866
Location: UK
|
Has anyone written an excel macro to generate the MQSC define queue statements from a spreadsheet list of queue names and their basic attributes?
If you have and are willing to share it, please let me know. |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Mon Mar 28, 2011 1:51 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
The products of our sponsor MQSystems may have some value in this area.
I have otherwise previously done very simple things to create fixed MQSC definitions based on string concatenation with column and row value substitution.... but that was several lifetimes ago and I don't still have extant artifacts. |
|
| Back to top |
|
|
| Mr Butcher |
| Posted: Mon Mar 28, 2011 2:54 am Post subject: |
|
|
Padawan
Joined: 23 May 2005
Posts: 1716
|
no macro here.
i would export to cvs and let some scripts / rexx run to create the proper commands. at least thats the fastest for me.
or add columns with the proper text arount the columns with the values, export to cvs and change/replace to get rid of the delimiter. e.g. if one column in your sheet is the qlocal name, add a "DEFINE QLOCAL(" in the column before and ")" in the column after..... maybe also fast if you only have a few options.
_________________
Regards, Butcher |
|
| Back to top |
|
|
| exerk |
| Posted: Mon Mar 28, 2011 3:09 am Post subject: |
|
|
Jedi Council
Joined: 02 Nov 2006
Posts: 6339
|
I believe MQSystems has something that will do it...
...no warranty or endorsement implied etc. 
_________________
It's puzzling, I don't think I've ever seen anything quite like this before...and it's hard to soar like an eagle when you're surrounded by turkeys. |
|
| Back to top |
|
|
| zpat |
| Posted: Mon Mar 28, 2011 4:26 am Post subject: |
|
|
Jedi Council
Joined: 19 May 2001
Posts: 5866
Location: UK
|
|
| Back to top |
|
|
|
|
