Re: Disabled User Profiles

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

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