RE: Disabled User Profiles

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