Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

FileAid copy with record skip

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Compuware & Other Tools
View previous topic :: :: View next topic  
Author Message
rksuresh

New User


Joined: 09 Jan 2006
Posts: 11

PostPosted: Wed Sep 12, 2007 12:54 pm    Post subject: FileAid copy with record skip
Reply with quote

Hi All,

I need to copy from 2 input files to one output file.
1st input file having only one header record.
2nd input file having one header and detail record also.
here i want to copy header record from the 1st input file and dont want to copy header record from the 2nd input file but need to copy all details records.

Example

File 1
------------------------Header-1---------------------------

File 2
------------------------Header 2---------------------------
--------------------details records------------------------
--
--
--

Output file looks like
------------------------Header-1---------------------------
--------------------details records------------------------
--
--
--

Please give me File aid copy option for this
Looking your response
Thanks
Suresh
Back to top
View user's profile Send private message

murmohk1

Senior Member


Joined: 29 Jun 2006
Posts: 1439
Location: Bangalore,India

PostPosted: Wed Sep 12, 2007 1:08 pm    Post subject:
Reply with quote

rksuresh,

How do you identify the header records? Do you have any standard formats for these?
Back to top
View user's profile Send private message
rksuresh

New User


Joined: 09 Jan 2006
Posts: 11

PostPosted: Wed Sep 12, 2007 2:11 pm    Post subject: Reply to: FileAid copy with record skip
Reply with quote

Hi Murali,

Thanks for your response.

In 1st File column position 370 to 380 we have "ABCDEFGHIJ".
In 2ND FILE column position 370 to 380 we have "KLMNOPQRST".

So i want my output file as

1--------------------------------------370----------380------------
----------------------------------------ABCDEFGHIJ---------------<-Header Rec
--------------------------dETAILS RECORDS---------------------<-Details Rec
---
---
---
Thanks
Suresh
Back to top
View user's profile Send private message
murmohk1

Senior Member


Joined: 29 Jun 2006
Posts: 1439
Location: Bangalore,India

PostPosted: Wed Sep 12, 2007 2:20 pm    Post subject:
Reply with quote

Suresh,

In the FA batch mode, concatenate the two files and skip the HEADER2 record. Please note this is applicable only if the header2 has constant value across runs.. You could do this using other utils also.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Wed Sep 12, 2007 2:35 pm    Post subject:
Reply with quote

Hi,

SORT can serve better for your problem.
Back to top
View user's profile Send private message
rksuresh

New User


Joined: 09 Jan 2006
Posts: 11

PostPosted: Wed Sep 12, 2007 2:35 pm    Post subject: Reply to: FileAid copy with record skip
Reply with quote

Hi Murali,

Can you give me the syntax for skipping the second record in file aid batch mode.I have tried initial skip is 0 and copy 1st record then skip 1 record,
the output is copied alternatively records.
Please give syntax for this.it will help full to me

thanks
Suresh
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Compuware & Other Tools All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Fileaid 2 commands instream work. In ... descann Compuware & Other Tools 2 Tue May 16, 2017 3:31 pm
No new posts Fileaid Update Replace with null string descann Compuware & Other Tools 4 Mon May 15, 2017 3:00 pm
No new posts Adding big TEXT lines to each record ... bshkris SYNCSORT 4 Sat May 06, 2017 1:40 am
This topic is locked: you cannot edit posts or make replies. Merge two files and update Trailer re... Yashashri JCL & VSAM 1 Thu May 04, 2017 12:54 pm
No new posts copy SEQ to PDS and create stats steve-myers JCL & VSAM 5 Thu Apr 27, 2017 1:15 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us