Re: OPNQRYF question

I understand what you are trying to do, I think, but why don't you just use
the QPWDEXPITV system value?

Al

Al Barsa, Jr.
Barsa Consulting Group, LLC

400>390

914-251-1234
914-251-9406 fax

http://www.barsaconsulting.com
http://www.taatool.com


midrange-l-bounces@xxxxxxxxxxxx wrote on 05/30/2003 11:39:21 AM:

> I created a file called PWDEXPFILE using DSPUSRPRF and sent to an
> outfile in my library
>
> now using a CL I am trying to get info on anyone who hasn't reset their
> password in 30 days
>
>
>
> But I am getting an CPD3120 error (that is the detailed description when
> I hit F1)
>
> it's actually CPF9899 that shows up in the joblog.
>
>
>
>
>
> OPNQRYF    FILE((JNORBUT/PWDEXPFILE)) OPTION(*ALL) +
>
>                     QRYSLT('SELECT * FROM JNORBUT/PWDEXPFILE +
>
>                     WHERE DATE(SUBSTR(UPPWCD,3,2)|| +
>
>                                       "/"||SUBSTR(UPPWCD,5,2)|| +
>
>
>                                       "/"||SUBSTR(UPPWCD,1,2)) >= +
>
>
>                     CURRENT_DATE - 30 DAYS')
>
>
>
>
>
>
>
> am I not able to do this using OPNQRYF ??
>
>
>
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>