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
 
Splice more than 50 occurances

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
rajatbagga

Active User


Joined: 11 Mar 2007
Posts: 195
Location: india

PostPosted: Wed Oct 11, 2017 9:36 am    Post subject: Splice more than 50 occurances
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: 195
Location: india

PostPosted: Wed Oct 11, 2017 9:53 am    Post subject: Reply to: Splice more than 50 occurances
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    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Matching records using splice for COM... hiravibk DFSORT/ICETOOL 4 Sun Sep 27, 2015 12:05 pm
No new posts JOINKEYS or SPLICE? while retaining h... hsinaz50 DFSORT/ICETOOL 4 Thu Apr 17, 2014 12:13 am
No new posts Match 2 files using SPLICE sudib19 DFSORT/ICETOOL 6 Wed Dec 04, 2013 3:06 am
No new posts Syncsort - SPLICE only certain info. ramsri SYNCSORT 11 Wed Jul 24, 2013 4:48 pm
No new posts compare 2 file based on key+retain du... Hariharan BK DFSORT/ICETOOL 6 Thu May 02, 2013 12:04 am

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