Search found 67 matches

by goldyroshan
Sun Jan 17, 2016 9:30 am
Forum: DFSORT , ICETOOL & Utilities
Topic: SORT card needed - overwriting within same file
Replies: 3
Views: 3961

Thanks. It worked.
by goldyroshan
Sat Jan 16, 2016 7:05 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: SORT card needed - overwriting within same file
Replies: 3
Views: 3961

SORT card needed - overwriting within same file

I have a requirement where -

if there are spaces in 279th byte

Code: Select all

(279,8)
of my input file, then I would want to overwrite 279th byte with data from some other byte position from the same input file.

Please suggest SORT card for the same.
by goldyroshan
Mon Dec 07, 2015 8:16 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: SORT card needed to exclude record set
Replies: 18
Views: 19534

Any suggestions from anyone one the above?
by goldyroshan
Fri Dec 04, 2015 10:44 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: SORT card needed to exclude record set
Replies: 18
Views: 19534

I did already...
but the output file has
all details records first, then header & then trailers - which is not what I want.
Please advise.
by goldyroshan
Thu Dec 03, 2015 8:51 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: SORT card needed to exclude record set
Replies: 18
Views: 19534

I tried to incorporate your suggestion, I think I am still not quite there. Here is the JCL I tried - //S008A EXEC SORT //SORTJNF1 DD DSN=input file, // DISP=SHR //SORTJNF2 DD DSN=input file (same as above), // DISP=SHR //SORTOUT DD DSN=output file, // DISP=(NEW,CATLG,DELETE), // SPA...
by goldyroshan
Fri Nov 20, 2015 9:22 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: SORT card needed to exclude record set
Replies: 18
Views: 19534

Okay.
I'll try this one out & get back with the results.
Thanks a lot
by goldyroshan
Wed Nov 18, 2015 7:59 am
Forum: DFSORT , ICETOOL & Utilities
Topic: SORT card needed to exclude record set
Replies: 18
Views: 19534

I appreciate your effort/help Bill.
But would be lot better if you could also give the actual sort card (even if its not the final polished sort card that's ok).
by goldyroshan
Tue Nov 17, 2015 11:40 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: SORT card needed to exclude record set
Replies: 18
Views: 19534

Bill,

I tried to check sort manuals.
I felt that we can achieve this by any of this -

DATASORT operator of ICETOOL,
SUBSET operator of ICETOOL
IFTHEN WHEN=GROUP

However, I don't know what/how to do it precisely. :(
by goldyroshan
Mon Nov 16, 2015 10:02 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: SORT card needed to exclude record set
Replies: 18
Views: 19534

I only know of how to extract detail records (which even every Mainframe newcomer can do).
But I have no clue of how to extract corresponding header & trailer record for those detail records all together.
Tried checking in SORT manuals but could not get anything.
Hence seeking experts' guidance here!
by goldyroshan
Mon Nov 16, 2015 7:04 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: SORT card needed to exclude record set
Replies: 18
Views: 19534

So does this mean we can't do this thru a SORT? :(
by goldyroshan
Thu Nov 12, 2015 8:10 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: SORT card needed to exclude record set
Replies: 18
Views: 19534

So anything that you can suggest?
by goldyroshan
Thu Nov 12, 2015 12:59 am
Forum: DFSORT , ICETOOL & Utilities
Topic: SORT card needed to exclude record set
Replies: 18
Views: 19534

Bill, I tried the one suggested by you, it didn't work. Here is my requirement - input file - B2 00 GGG MISC_ORDER B2 10 001 C B2 20 001 C B2 99 GLO 20151027 163020 0000002 B2 00 HHH MISC_ORDER B2 10 200 200 B2 20 200 200 B2 10 200 200 B2 20 200 200 B2 99 GLO 20151027 163020 0000008 output file shou...
by goldyroshan
Mon Nov 09, 2015 8:09 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: SORT card needed to exclude record set
Replies: 18
Views: 19534

SORT card needed to exclude record set

Here is how my input records look like - A1 00 ABC XYZ -> header A2 10 XXX PQR -> detail record 1 A3 20 GHI STU -> detail record 2 A4 99 KKK RRR -> trailer I want to check whenever we have XXX at this position, then I would want to exclude the entire record set (i.e. all rows from 00 (header) to 99 ...
by goldyroshan
Thu Apr 30, 2015 8:11 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: WER488A JOIN CAPACITY EXCEEDED
Replies: 10
Views: 12234

Here is the output, when it works normally - Code: SYSIN : JOINKEYS FILES=F1,FIELDS=(01,64,A) JOINKEYS FILES=F2,FIELDS=(01,64,A) JOIN UNPAIRED,F1 ONLY REFORMAT FIELDS=(F1:01,100,F2:01,100) SORT FIELDS=COPY OUTREC IFTHEN=(WHEN=(01,07,CH,NE,C' ',AND, 101,07,CH,NE,C' '), OVERLAY=(01:01,67,68:168,10,78:...
by goldyroshan
Wed Apr 29, 2015 8:42 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: WER488A JOIN CAPACITY EXCEEDED
Replies: 10
Views: 12234

Are you sure that is the entire output? There isn't more on the next page? Can you post the sysout from one which works, as well? Does the data need to be sorted, or is it already in sequence? Bill - if you think REGION=5000K is enough (I think so), then I think swapping JNF1 and JNF2 could be the ...