IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Bit Selection in File Aid


IBM Mainframe Forums -> Compuware & Other Tools
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
jagankallis
Warnings : 1

New User


Joined: 28 Jun 2006
Posts: 29
Location: DUISBURG

PostPosted: Wed Dec 13, 2006 3:17 am
Reply with quote

Hallo All,

I need to select the records from my file using the formatted criteria in File Aid.

For example,

My input file contains the following structure

DCL 1 FILEAID,
5 Name char (1),
5 Street char (2),
5 Owning_A_CAR bit(1);

From this file i need to select the records where the Owning_A_CAR bit is ON.
Back to top
View user's profile Send private message
Satyakumari

New User


Joined: 06 Dec 2006
Posts: 1

PostPosted: Wed Dec 13, 2006 3:03 pm
Reply with quote

jagankallis wrote:
Hallo All,

I need to select the records from my file using the formatted criteria in File Aid.

For example,

My input file contains the following structure

DCL 1 FILEAID,
5 Name char (1),
5 Street char (2),
5 Owning_A_CAR bit(1);

From this file i need to select the records where the Owning_A_CAR bit is ON.


I know it through File manager and I guess that it will be similar in File aid.

If you know the starting position of Owning_A_CAR then you can get the records having Owning_A_CAR bit 1.

Select the Processing options as Create Dynamic.
Give the start as starting position of Owning_A_CAR. length as 1.Op as EQ and value as 1.It will display all the records having Owning_A_CAR bit 1.
Back to top
View user's profile Send private message
View previous topic : : View next topic  
Post new topic   Reply to topic All times are GMT + 6 Hours
Forum Index -> Compuware & Other Tools

 


Similar Topics
Topic Forum Replies
No new posts FileAid move data from two files to o... Compuware & Other Tools 5
No new posts DB2 Query to get the count of Unique ... DB2 2
No new posts Sorting date into YYYYMMDD, and creat... DFSORT/ICETOOL 13
No new posts To Sort detail records in a file with... SYNCSORT 5
No new posts To Populate Trailer cnt in the file w... SYNCSORT 1
Search our Forums:


Back to Top