Overlay field to output

paduchuri · New User Joined: 03 Jan 2011 Posts: 32 Location: Hyderabad

Hi,

I want to overlay two fields from input file to output i am using the below code which should overlay the fields but it is copying all fields

Please some one correct the code.Thanks

Frank Yaeger · Posted: Sat Mar 05, 2011 12:40 am

It's not clear from your description what you're trying to do.

OVERLAY overlays just the fields you tell it to, but it copies the rest of the record as is. Your statement keeps the input record as is, but overlays output positions 271-279 with input positions 3-11, and overlays output positions 286-288 with input positions 52-54.

If you just want to include two fields from the input record to the output record, you would use BUILD, not OVERLAY.

I can't help you further unless you explain what you're actually trying to do. Do you want to copy just two fields from input to output or do something else? What is the starting position and length of the input fields? What do you want in the output record and where?

paduchuri · New User Joined: 03 Jan 2011 Posts: 32 Location: Hyderabad

Hello Frank,

what you explained is correct,

I want to overlay the 2 fields 3-11,52-54(new A/c num and code) from input file to fields 271-279,286-288(old A/C num and code) in output and the rest of the fields in output should remain as is.

I am just replacing the old A/C num and code in output file with new A/c num and code in input file.

My concern here is the code below does'nt overlay two fields instead it copies all i/p fields to o/p.

Please advise the solution,Thanks for your help.

Regards,
Pavan.

dick scherrer · Posted: Mon Mar 07, 2011 8:11 pm

Hello,

Is there some reason you have not posted some sample input data and the output you want from the sample data? These do not need to be full-length records - just enough to demonstrate the requirement.

Also mention the recfm and lrecl of the files along with any "processing rules".

Garry Carroll · Posted: Mon Mar 07, 2011 8:29 pm

Frank Yaeger · Posted: Tue Mar 08, 2011 12:28 am

Pavin,

What you're saying makes no sense. If I have an input record like this:

paduchuri · New User Joined: 03 Jan 2011 Posts: 32 Location: Hyderabad

Hello Frank/Garry Carroll,

Sorry for the delay in replying i was bit busy.

Yes,I am processing two files

consider below example

if the sortin dataset has

dick scherrer · Posted: Fri Mar 11, 2011 10:13 pm

Hello,

How/why is there an "output" file before the process begins?

Do you really have 2 input file and want to create a new output with some alterations?

You should not overwrite an input file as you have described.

Frank Yaeger · Posted: Fri Mar 11, 2011 11:28 pm

Pavan,

Assuming you have two input files and want to create an output file by matching the records one-by-one, you would use JOINKEYS, not OVERLAY.
Here's an example of a JOINKEYS job with the input you showed and assuming your input file has RECFM=FB and LRECL=80. You can adapt it as necessary.

paduchuri · New User Joined: 03 Jan 2011 Posts: 32 Location: Hyderabad

Hi Frank,

Thank you very much for the replying,

i am getting following error when i try to run the job i guess because i am using syncsort.

enrico-sorichetti · Posted: Mon Mar 14, 2011 12:10 pm

You should know that Frank is DFSORT developer! and You have no reason to ask Him for advice on SYNCSORT ( a competitor' s product )

topic moved where it belongs

kratos86 · Posted: Tue Mar 15, 2011 7:01 pm

Below code will do the same logic in syncsort

paduchuri · New User Joined: 03 Jan 2011 Posts: 32 Location: Hyderabad

Hi kratos86,

Thank you for the solution.

Regards,
Pavan.