rajatbagga
Active User
Joined: 11 Mar 2007 Posts: 199 Location: india
|
|
|
|
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 |
|