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
 

 

Syncsort Splitting file on certain basis

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
narasimha.g

New User


Joined: 10 Sep 2009
Posts: 68
Location: Liverpool

PostPosted: Fri Sep 02, 2011 8:57 pm    Post subject: Syncsort Splitting file on certain basis
Reply with quote

Hi All,

I have a IMS database unload with over 2 million records... i now have a requirement to split the file into 3 files with around 700000 records in each file....

I can do this using the STOPAFT parameter....But there is a catch in this... I do not want the parent and child segment to get separated and go into different files....

Example....

INPUT FILE

SSP42MPR - is the parent record and SSP42SPR is the child record.

All the SSP42SPR associated records below a SSP42MPR record until the next SSP42MPR record are the child Segments.....

The number of child segments are not fixed and can be variable

Code:
SSP42MPR...123456789QWERTY
SSP42SPR...898
SSP42SPR...899
SSP42SPR...891
SSP42SPR...892
SSP42MPR...123456789PORTYI
SSP42SPR...898
SSP42SPR...899
SSP42SPR...891
SSP42MPR...123456789PORTYI
SSP42SPR...898
SSP42SPR...899
SSP42SPR...891
SSP42SPR...892
SSP42SPR...898
SSP42SPR...899
SSP42SPR...891
SSP42SPR...892


Now what i want in o/p when i split is

Output 1
Code:
SSP42MPR...123456789QWERTY
SSP42SPR...898
SSP42SPR...899
SSP42SPR...891
SSP42SPR...892
SSP42MPR...123456789PORTYI
SSP42SPR...898
SSP42SPR...899
SSP42SPR...891


Output 2

Code:
SSP42MPR...123456789PORTYI
SSP42SPR...898
SSP42SPR...899
SSP42SPR...891
SSP42SPR...892
SSP42SPR...898
SSP42SPR...899
SSP42SPR...891
SSP42SPR...892


and not

Output 1

Code:
SSP42MPR...123456789QWERTY
SSP42SPR...898
SSP42SPR...899
SSP42SPR...891
SSP42SPR...892
SSP42MPR...123456789PORTYI
SSP42SPR...898
SSP42SPR...899
SSP42SPR...891
SSP42MPR...123456789PORTYI
SSP42SPR...898
SSP42SPR...899


Output 2

Code:
SSP42SPR...891
SSP42SPR...892
SSP42SPR...898
SSP42SPR...899
SSP42SPR...891
SSP42SPR...892


I want the split record count to be somewhere around 700000 not very specific abt the count.....

Could you please help me in doing this....
Back to top
View user's profile Send private message

Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7223

PostPosted: Fri Sep 02, 2011 9:06 pm    Post subject: Reply to: JCL Requirement
Reply with quote

If you have your whole file, browse it. Go to about 700000th record. Visually identify next logical position to break file. Go down another 700000. Repeat. Hope that you remembered, or wrote down, the exact numbers.

Then you have some start/stop numbers for whatever method you choose to simply split the file.
Back to top
View user's profile Send private message
Escapa

Senior Member


Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA

PostPosted: Fri Sep 02, 2011 9:06 pm    Post subject:
Reply with quote

Can you please confirm if you have DFSORT or SYNCSORT?

Also what is LRECL and RECFM of the file?
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10201
Location: italy

PostPosted: Fri Sep 02, 2011 9:13 pm    Post subject: Reply to: Splitting file on certain basis
Reply with quote

given the frequency of Your posts ...
isn ' t it time for Your organization to use the servics of a paid consultant
instead of relying on free consultancy from public forum ?

looks like You and You company do not have a bit of ethics !
or maybe that' s Your way of doing business ???
Back to top
View user's profile Send private message
narasimha.g

New User


Joined: 10 Sep 2009
Posts: 68
Location: Liverpool

PostPosted: Fri Sep 02, 2011 9:13 pm    Post subject:
Reply with quote

Escapa wrote:
Can you please confirm if you have DFSORT or SYNCSORT?

Also what is LRECL and RECFM of the file?


Sorry forgot to mention this...

RECFM is VB

LRECL 2004
Back to top
View user's profile Send private message
Escapa

Senior Member


Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA

PostPosted: Fri Sep 02, 2011 9:22 pm    Post subject:
Reply with quote

narasimha.g wrote:
Escapa wrote:
Can you please confirm if you have DFSORT or SYNCSORT?

Also what is LRECL and RECFM of the file?


Sorry forgot to mention this...

RECFM is VB

LRECL 2004

YOU DID NOT ANSWER MY FIRST QUESTION?
Back to top
View user's profile Send private message
narasimha.g

New User


Joined: 10 Sep 2009
Posts: 68
Location: Liverpool

PostPosted: Fri Sep 02, 2011 9:24 pm    Post subject: Re: Reply to: Splitting file on certain basis
Reply with quote

enrico-sorichetti wrote:
given the frequency of Your posts ...
isn ' t it time for Your organization to use the servics of a paid consultant
instead of relying on free consultancy from public forum ?

looks like You and You company do not have a bit of ethics !
or maybe that' s Your way of doing business ???


I have been member since 2 years never asked so many questions.... its just that I am more in need now and usually rely on this forum for any mainframe help.... Nothing to do with the company ethics.... Anyways Thanks for the Help icon_smile.gif
Back to top
View user's profile Send private message
narasimha.g

New User


Joined: 10 Sep 2009
Posts: 68
Location: Liverpool

PostPosted: Fri Sep 02, 2011 9:27 pm    Post subject: Re: Reply to: JCL Requirement
Reply with quote

Bill Woodger wrote:
If you have your whole file, browse it. Go to about 700000th record. Visually identify next logical position to break file. Go down another 700000. Repeat. Hope that you remembered, or wrote down, the exact numbers.

Then you have some start/stop numbers for whatever method you choose to simply split the file.


Thanks very much Bill.... Very helpful for an one off solution.... ll try that....
Back to top
View user's profile Send private message
narasimha.g

New User


Joined: 10 Sep 2009
Posts: 68
Location: Liverpool

PostPosted: Fri Sep 02, 2011 9:28 pm    Post subject:
Reply with quote

Escapa wrote:
narasimha.g wrote:
Escapa wrote:
Can you please confirm if you have DFSORT or SYNCSORT?

Also what is LRECL and RECFM of the file?


Sorry forgot to mention this...

RECFM is VB

LRECL 2004

YOU DID NOT ANSWER MY FIRST QUESTION?


I have SYNCSORT here....
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Sep 02, 2011 9:36 pm    Post subject:
Reply with quote

Hello

Quote:
I have SYNCSORT here....
Which release? This is at the top of the informational output generated for each run.

The release may influence which solution(s) might be available to meet your requirement.
Back to top
View user's profile Send private message
narasimha.g

New User


Joined: 10 Sep 2009
Posts: 68
Location: Liverpool

PostPosted: Fri Sep 02, 2011 9:38 pm    Post subject:
Reply with quote

dick scherrer wrote:
Hello

Quote:
I have SYNCSORT here....
Which release? This is at the top of the informational output generated for each run.

The release may influence which solution(s) might be available to meet your requirement.


its SYNCSORT FOR Z/OS 1.3.1.1R....
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 -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts syncsort: copy lines after the keyword shreya19 SYNCSORT 1 Fri Dec 02, 2016 9:47 am
No new posts Add PD field from 2nd file to PD in 1st Sushant Garje DFSORT/ICETOOL 6 Thu Dec 01, 2016 4:32 pm
No new posts File Aid to File Manager conversion murali3955 IBM Tools 4 Thu Nov 24, 2016 3:41 pm
No new posts How to convert the VBM file to VB or... Sulabh Agrawal JCL & VSAM 4 Fri Nov 18, 2016 1:04 pm
No new posts CICS Roll back partially - Need to re... dwijadas CICS 4 Wed Nov 16, 2016 4:30 pm


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