Checking status & then to be updated

[manojmkr]

Hi to all
I Have a flat file as a source ,the folling r the field items are userid, Ipadd,Time,st_flag and sample data looks like as follows.
Userid~IP Address~Time~status flag
e039373~137.019.214.065~Jul 23, 2003 10:25:18~D
e039373~137.019.214.065~Jul 23, 2003 10:30:18~D
e039373~137.019.214.065~Jul 23, 2003 10:35:18~D
e039373~137.019.214.065~Jul 23, 2003 10:40:18~D
e039373~137.019.214.065~Jul 23, 2003 10:45:18~Q
e039373~137.019.214.065~Jul 23, 2003 10:50:18~D
e039373~137.019.214.065~Jul 23, 2003 10:55:18~D
e039373~137.019.214.065~Jul 23, 2003 11:00:18~D
e039373~137.019.214.066~Jul 23, 2003 11:10:18~D

Using flat file data i need to do as follows.
I have to check the data item 'st_flag' whenevere user tries to logon in the time frame of '10min'(Criteria),i need to check 'st_flag' if otherthan 'D'(Denied) than i need to put as '1' in 'fl_denied', otherwise '1' in 'tr_denied' ,if one of the 'st_flag' is '1' in the time frame of same user then i need put '1' as 'fl_denied' and '0' in 'tr_denied' otherwise put them '0'in 'fl_denied' & '1' in 'tr_denied'. Target will be oracle table. can any help in this matter ASAP.

Thanks in Advance
Mano

 

[blom0344]

Maybe, but what do you mean with time frame of 10 min/ Is this a comparison between the system time and the field 'time' or are you validating time passed between 2 records? In the former case you could use some nested IIF statements I guess.

Please clarify ....

T. Blom
Information analyst
tbl@shimano-eu.com