× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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" <Frances.Denoncourt@xxxxxxxxxxxxxxxxx>
To:
"Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
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


<rob@xxxxxxxxx> 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

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.