RE: Notifying C/S users to change their passwords

Rob,

Could you use EIM for that user?

-Eric

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Thursday, September 24, 2009 9:46 AM
To: Midrange Systems Technical Discussion
Subject: Notifying C/S users to change their passwords

Think this, the only access a user uses on the i is a shared drive via
NetServer. QPWDEXPITV is set to 90 days. He's set to *SYSVAL. I don't

believe that connecting to the share will activate the window "Dude, you

password will expire in x days, would you like to change it now?". How
do
you notify them?


create table rob/userexp as (
With T1 as(
SELECT UPUPRF as UserId, UPTEXT as Text,
Date('20' concat substr(UPPWCD,1,2) concat '-' concat
substr(uppwcd,3,2) concat '-' concat substr(uppwcd,5,2))
as PassWordChanged,
Date('20' concat substr(UPPSOD,1,2) concat '-' concat
substr(UPPSOD,3,2) concat '-' concat substr(UPPSOD,5,2))
as SignOnDate,
days(current date) - days(
Date('20' concat substr(UPPWCD,1,2) concat '-' concat
substr(uppwcd,3,2) concat '-' concat substr(uppwcd,5,2)))
as ChangedDaysAgo,
days(current date) - days(
Date('20' concat substr(UPPSOD,1,2) concat '-' concat
substr(UPPSOD,3,2) concat '-' concat substr(UPPSOD,5,2)))
as SignedonDaysAgo
FROM userlist
where upstat<>'*DISABLED' and UPPWEI<>-1 and uppsod<>' ')
select * from t1
where ChangedDaysAgo>70
and SignedonDaysAgo<45
) with data

Rob Berendt