× 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.


  1.  Home
  2. MIDRANGE-L
  3. January 2017

RE: Interactive SQL vs RUNSQL REQUEST submitted via AJS - syntax checking different

I checked an lpar that is least likely for someone to have ran the CHGCMD
against RUNSQL.
Where allowed to run . . . . . . . . . :
*IMOD *BMOD *IREXX
*BREXX *BPGM *IPGM
*EXEC *INTERACT *BATCH
whereas SIGNOFF is set to
*IREXX *IPGM *EXEC
*INTERACT
So, yes, it should be allowed to be ran from the command line.

True, a simple 'SELECT' is not allowed. I think IBM's was not really
designed for ad hoc queries from the command line, with the results
intended for screen or printer. I think it's more intended for CL updates
and stuff. I disagree with this limitation but haven't pursued it too
much.

I've gotten pretty used to Run SQL Scripts for ad hoc.
For burying into a program for display or printer I would be more likely
to use my renamed EXESQL, or STMQMQRY or some other thing, if not a full
blown program.

Rob Berendt

As an Amazon Associate we earn from qualifying purchases.

This thread ...
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.