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



Ah yes - misunderstood your question - mea culpa!

Vern

On 3/14/2011 9:18 AM, McGovern, Sean wrote:
Vern,

I wasn't asking whether you could run a SELECT statement through
QCMDEXC, I was asking whether QCMDEXC could be run with a SELECT
statement as per the example from Rob. I don't believe it can (you can
run CL commands in SQL however, just not with a SELECT statement).

Sean


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Vern Hamberg
Sent: 14 March 2011 13:41
To: Midrange Systems Technical Discussion
Subject: Re: Disabled User Profiles

Sean

You can't directly run a SELECT statement with QCMDEXC - the latter is
for running CL commands.

You CAN write a CL command that lets you enter an SQL statement to be
executed, not just SELECTs. Google for RUNSQLSTM for an example that
works quite nicely.

HTH
Vern

On 3/14/2011 8:28 AM, McGovern, Sean wrote:
Can you run QCMDEXC through a SELECT statement ?



-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: 14 March 2011 13:04
To: Midrange Systems Technical Discussion
Subject: RE: Disabled User Profiles

No, it's just a file we routinely run DSPUSRPRF's output to.


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.