Re: QMQRY QQRYSRC issues group by and order by -- MIDRANGE-L

Fran

Since the commands are there from previous releases, seems to me that you might have the license - see who has the proof-of-entitlement stuff, check with a business partner. I know - there isn't time right now, but eventually.

Someone suggested installing 5722-ST1 - the SQL Development Kit and Query Manager product - you'd have 70 days to try it out, and, as another post said, the objects you create will work after the license goes out.

This'd give you a much better chance at proof of concept, I think, as Tommy is speaking of.

Good luck
Vern

-------------- Original message --------------
From: Tommy.Holden@xxxxxxxxxxxxxxxxxxxxx

if you stress the importance of the SQL tool for
researching/troubleshooting and reporting even with only a web/PC
background they should appreciate the abilities and power of SQL. just
"soft sell" the idea. even with the stingiest customers i've dealt with
if they understand that you can't fully utilize SQL they know enough about
the power and usefulness of the tool and i've never failed to have the
product purchased. and i couldn't sell ice water in hell...

Thanks,
Tommy Holden

From:
"Frances Denoncourt"
To:
"Midrange Systems Technical Discussion"
Date:
08/28/2008 10:05 AM
Subject:
Re: QMQRY QQRYSRC issues group by and order by

Rob,
5722ST1 is not there.
Object STRSQL in QSYS type *CMD not found.
We are short on pgmr utilities here. Current [and previous] CIO is Web/PC
- no IBM experience that I know of. We have a good sized IT staff, but
only 6 of us who program on the 400. One of us has been pretty vocal
lately with the new CIO hoping to get us current with releases, utilities,
etc. I don't know how much luck he's had.

I'll just plod along so I can get some tools 'my users' desperately need -
quickly - that is presentable to them and acceptable from my supv's
standpoint.
I've got half a day to get a form ready and write documentation - then
onto 'more important' stuff.
Thanks for your help.

Fran Denoncourt
Sr. Programmer/Analyst
Pinal County Treasurer's Office
Florence, AZ 85232
(520) 866-6404

Receipt of this message does not grant you permission to send me
Unsolicited Commercial Email

08/28/2008 7:21 AM >>>

No STRSQL command for this release?
Could be a security thing.
Start with: DSPSFWRSC. Do you have 5722ST1? If so then either the sicko

secured the command STRSQL in QSYS, or renamed it. Common rename
technique would be STRSQLx. Do NOT try WRKOBJ STRSQL*. Because if they
secured it, and you do not have *ALLOBJ it won't show. Instead, try
DSPOBJD QSYS/STRSQL *CMD. That command will tell you that you are not
authorized if you are secured out.
If they are trying security, then they mucked it up, as you can tell by
the presence of the command in the two previous version libraries.

Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com