Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 XMITIP sends it out. Can it copy on l... Rommel Dayon Rustia IBM Tools 0 Tue Sep 05, 2017 10:16 am
No new posts Updating the Trailer count in variabl... satheshbabur DFSORT/ICETOOL 6 Wed Aug 30, 2017 9:49 pm
No new posts Skip file from delete pema_yozer All Other Mainframe Topics 3 Tue Aug 29, 2017 3:19 pm
No new posts Repeat part of record multiple times Learncoholic DFSORT/ICETOOL 4 Tue Aug 29, 2017 11:33 am
No new posts Unable to copy data from spool in a d... srikant314 JCL & VSAM 8 Fri Jul 28, 2017 9:10 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us