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

Condition read and write -- using fileaid


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

New User


Joined: 03 Nov 2008
Posts: 42
Location: Pune

PostPosted: Mon Mar 15, 2010 4:38 pm
Reply with quote

Hi,

I have a file whose structure is :-

Code:
xxxxx20090305agagagag -- header
     31231231237[b]09/20/09[/b]381723901230 -- rec
     31231231237[b]09/20/09[/b]381723901230 -- rec
     31231231237[b]09/20/09[/b]381723901230 -- rec
     31231231237[b]09/20/09[/b]381723901230 -- rec
xxxxx20090306agagagag -- new header
     31231231237[b]09/20/09[/b]381723901230 -- rec
     31231231237[b]09/20/09[/b]381723901230 -- rec
     31231231237[b]09/20/09[/b]381723901230 -- rec
     31231231237[b]09/20/09[/b]381723901230 -- rec



Using this file i have to perform following operations using fileaid:-

1) If header date is smaller than the sample date, we need to drop the records till the new header is encountered.

2)If header date is greater than or equal to the sample date, we need to write the records in a file and also check the dates in record and if the record date is less than sample date then we have to drop those record and don't have to be written in the o/p file.

And the criteria is we can only use Fileaid utility in our JCL.

I have coded this in COBOL but need to do it using Fileaid as i am new to fileaid, it would be appreciative if any one of you can help me

Thanks in advance.
Back to top
View user's profile Send private message
Ranjithkumar

New User


Joined: 10 Sep 2008
Posts: 93
Location: India

PostPosted: Thu Apr 01, 2010 1:34 pm
Reply with quote

Do you have any layouts for the header and data records?
Back to top
View user's profile Send private message
mpawan
Warnings : 2

New User


Joined: 03 Nov 2008
Posts: 42
Location: Pune

PostPosted: Thu Apr 01, 2010 1:38 pm
Reply with quote

Header will start with a number like xxxxx which will be unique and different from record.
Back to top
View user's profile Send private message
Ranjithkumar

New User


Joined: 10 Sep 2008
Posts: 93
Location: India

PostPosted: Thu Apr 01, 2010 1:42 pm
Reply with quote

I think its not possible with FILEAID. I would suggest you go for SORT.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> Compuware & Other Tools

 


Similar Topics
Topic Forum Replies
No new posts DB2, write report based on query outp... DB2 1
No new posts How to give complex condition in JCL . CLIST & REXX 30
This topic is locked: you cannot edit posts or make replies. Write from flat file to db2 table Mainframe Interview Questions 5
No new posts JCL to read ps and convert it to read... DFSORT/ICETOOL 1
No new posts Rexx program reading a DSN then write... CLIST & REXX 4
Search our Forums:

Back to Top