RE: Disabled User Profiles

["McGovern, Sean" <Sean.McGovern@xxxxxxxxxxxx>]

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