Hi
I have focus file like a
eeid stype client
01 A aa
01 B bb
02 B bb
03 A aa
03 B bb
03 C cc

I want retrive the data from the file based on stype condition
First i check the stype 'A' if it is true it will display the 'A' related records only no need to other stype but it doesn't have 'A' it goes to second one 'B' if it is true it will display the 'B' related records only no need to other stype and same as 'C' type also
How to retrive the records

Please tell me how to solve this problem

Hi Raghuraman,

you can write Table File Statements to Display records like
TABLE FILE FILE1
PRINT EEID
STYPE
CLIENT
IF STYPE EQ A
END

-IF &LINES NE 0 GOTO EXIT;

TABLE FILE FILE1
PRINT EEID
STYPE
CLIENT
IF STYPE EQ B
END

-IF &LINES NE 0 GOTO EXIT;


TABLE FILE FILE1
PRINT EEID
STYPE
CLIENT
IF STYPE EQ C
END

-EXIT

FINISH

Hope this will help

Regards,
Parag.

This will give you the first value of STYPE for each record by eeid.

TABLE FILE yourfile
SUM
client
BY eeid
BY LOWEST 1 stype
END

It's hard to focus when the topic title is "FOCUS". It might be a good idea to use a more descriptive title.

It looks to me like there's a new set of recruits and we're giving the training again!!