Reformat fields from two files.



Support for NetApp SyncSort for z/OS, Visual SyncSort, SYNCINIT, SYNCLIST and SYNCTOOL

Reformat fields from two files.

Postby TECH99 » Mon Mar 23, 2015 6:47 pm

I have two data sets that are FB,80 bytes. I'm trying to copy F1 data from 1-18 and the names from F2. The = sign in front of the names starts in cols 35, but I;m not sure how to reformat the OP dataset to have the names in col 22. Any thoughts on how to accomplish this task?

F1 data starts in col 1-18

PLREP130 HQ11111 A
PLREP130 HQ22222 I
PLREP130 HQ33333 I
PLREP130 HG44444 A
PLREP130 HQ55555 I
PLREP130 HQ66666 A
*******************************************************
F2 data starts in col 1-80

ACCESSORID = HQ11111 NAME = PETER HOUSE
ACCESSORID = HQ22222 NAME = STEVE JOHNSON
ACCESSORID = HQ33333 NAME = MARK TWAIN
ACCESSORID = HQ44444 NAME = TIM ALLEN
ACCESSORID = HQ55555 NAME = MARK SMITH
ACCESSORID = HQ66666 NAME = TOM APPLE
************************************************************************************
OPDS

PLREP130 HQ11111 A PETER HOUSE
PLREP130 HQ22222 I STEVE JOHNSON
PLREP130 HQ33333 I MARK TWAIN
PLREP130 HG44444 A TIM ALLEN
PLREP130 HQ55555 I MARK SMITH
PLREP130 HQ66666 A TOM APPLE
TECH99
 
Posts: 1
Joined: Sun Mar 22, 2015 9:15 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Reformat fields from two files.

 

Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post