IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Splice more than 50 occurances


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
rajatbagga

Active User


Joined: 11 Mar 2007
Posts: 199
Location: india

PostPosted: Wed Oct 11, 2017 9:36 am
Reply with quote

Hello Guys,

I have got the data in which the key on which I want to SPLICE can occur more than 50 times [but less than 100], based on the input data I am building a WITH(XXX,XX) syntax via sort itself. I am able to build the syntax cards but unfortunately while i execute the generated syntax i see that there is a limit of 50 with the WITH i can use in my SPLICE syntax. Hence i am getting "ICE623A 0 MAXIMUM NUMBER OF WITH KEYWORDS EXCEEDED"

My Data looks like

Code:
ABCD1234 DU123456
ABCD1234 DU123451
ABCD1234 DU123452
ABCD1234 DU123453
ABCD1234 DU123454
.
.
.
ABCD1234 DU999999
ABCD1235 DU123456
ABCD1235 DU123451
ABCD1235 DU123452
ABCD1235 DU123453
ABCD1235 DU123454
.
.
.
ABCD1235 DU999999
.
.
.


Is there a way i can SPLICE this data into one record each on Key ABCD1234 ABCD1235 .. ??

Regards,
Rajat
Back to top
View user's profile Send private message
rajatbagga

Active User


Joined: 11 Mar 2007
Posts: 199
Location: india

PostPosted: Wed Oct 11, 2017 9:53 am
Reply with quote

In continuation to above the expected output should look like..

Code:
ABCD1234 DU123456 DU123451 DU123452 DU123453 ...... DU999999
ABCD1235 DU123456 DU123451 DU123452 DU123453 ...... DU999999


Thanks, Rajat
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts Join multiple records using splice DFSORT/ICETOOL 5
This topic is locked: you cannot edit posts or make replies. Splice JCL into one record for DD sta... SYNCSORT 2
This topic is locked: you cannot edit posts or make replies. Splice multiple records into single r... DFSORT/ICETOOL 9
No new posts Matching records using splice for COM... DFSORT/ICETOOL 4
No new posts JOINKEYS or SPLICE? while retaining h... DFSORT/ICETOOL 4
Search our Forums:

Back to Top