Search found 805 matches

by Frank Yaeger
Thu May 24, 2012 8:58 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: possible migration from syncsort to dfsort
Replies: 1
Views: 1991

If you send an e-mail asking about migration to dfsort@us.ibm.com , we will send you some documents that discuss migrating from Syncsort to DFSORT.
by Frank Yaeger
Thu May 24, 2012 8:54 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Sort to copy data from first column from a file and paste it
Replies: 4
Views: 4107

archup20, Well, you can use the same file for input and output if you do a SORT, but it's NOT really recommended since if something goes wrong you could lose your data set. If you really want to do it, a DFSORT job like the following would work. I assumed your input file has RECFM=FB and LRECL=80, b...
by Frank Yaeger
Fri May 18, 2012 11:56 pm
Forum: JCL
Topic: GDG and DFSORT
Replies: 5
Views: 5923

Sudip, You can use a DFSORT job like the following to do what you asked for: //S1 EXEC PGM=SORT //SYSOUT DD SYSOUT=* //SORTIN DD DSN=... input file (FB/133) //SORTOUT DD DSN=... output file (FB/133) //SYSIN DD * OPTION COPY INCLUDE COND=(2,13,CH,EQ,C'CURRENT DATE:',OR, 2,13,CH,EQ...
by Frank Yaeger
Wed May 16, 2012 5:54 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Retiring after 43+ years with IBM
Replies: 3
Views: 3972

Retiring after 43+ years with IBM

Just a note to let everyone know I'll be retiring at the end of this month (5/31/2012). I've been with IBM for 43+ years (plus a couple of summers in college) and I've enjoyed my career immensely. I've especially enjoyed being able to help people use the DFSORT/ICETOOL functions I developed, over ma...
by Frank Yaeger
Fri May 11, 2012 10:42 pm
Forum: JCL
Topic: Sorting using DFSORT
Replies: 3
Views: 3537

San, You haven't given a clear enough explanation of your requirement for anyone to help you. You show values with different numbers of decimal places ranging from 4 to 7. These must be "normalized" to be sorted. But you haven't told us the minimum or maximum number of decimal places your values can...
by Frank Yaeger
Fri May 04, 2012 10:04 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: How to replace a FIXEDBIN number by another number in a file
Replies: 4
Views: 4537

FIXED BIN(15) is a 2-byte BI value. It's still not clear what you want to do exactly, though. If you want to put X'0001' in positions 3-4 of every record, you can use these DFSORT statements: OPTION COPY INREC OVERLAY=(3:X'0001') If you only want to replace X'0000' in positions 3-4 with X'00...
by Frank Yaeger
Thu May 03, 2012 9:58 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: How to replace a FIXEDBIN number by another number in a file
Replies: 4
Views: 4537

Anithavincy, If you want help, you'll need to do a better job of explaining exactly what it is you want to do. Is FIXEDBIN equivalent to ZD, PD, BI or something else? If you don't know, show a few values in hex. Please show an example of the records in your input file (relevant fields only) and what...
by Frank Yaeger
Wed May 02, 2012 10:21 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: How to convert a decimal valuie to hexadecimal using sort
Replies: 5
Views: 5558

Haritha, What you actually want is to convert from zoned decimal (ZD) to binary (BI). Assuming you want to overlay the 4-byte ZD value with an equivalent 4-byte BI value, you can use a DFSORT job like the following: //S1 EXEC PGM=SORT //SYSOUT DD SYSOUT=* //SORTIN DD DSN=... input file (FB) ...
by Frank Yaeger
Mon Apr 30, 2012 10:30 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: DFSort
Replies: 3
Views: 3437

I don't know what you tried with JOINKEYS that "didn't work", but here's a DFSORT JOINKEYS job that does what you asked for: //S1 EXEC PGM=SORT //SYSOUT DD SYSOUT=* //IN1 DD DSN=... input file1 (VB/621) //IN2 DD DSN=... input file2 (VB/621) //SORTOUT DD DSN=... output file (VB/62...
by Frank Yaeger
Fri Apr 27, 2012 1:32 am
Forum: DFSORT , ICETOOL & Utilities
Topic: joinkey with different formats of key
Replies: 3
Views: 3900

Which sort product are you using - DFSORT (ICE messages) or Syncsort (WER messages)?
by Frank Yaeger
Thu Apr 26, 2012 10:10 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: JCL -sort
Replies: 3
Views: 3564

You can use a DFSORT job like the following to do what you asked for. Be sure to use input file2 (one record) for STEP S1 and input file1 (multiple records) for STEP2. //S1 EXEC PGM=SORT //SYSOUT DD SYSOUT=* //SORTIN DD DSN=... input file2 (VB) //SORTOUT DD DSN=&&S1,UNIT=SYSDA,SPACE=(TRK...
by Frank Yaeger
Thu Apr 26, 2012 10:00 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: XML formatting using SORT
Replies: 1
Views: 1882

Are you asking how to use DFSORT to do the sorting? (If not, you can ignore the rest of this note.) If so, you need to show your sample records in hex so we can see what they actually look like. Identify the sort fields you want to use. Identify the null fields (are they X'00' fields or something el...
by Frank Yaeger
Wed Apr 25, 2012 11:05 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: JCL -sort
Replies: 3
Views: 3564

You need to give a clearer description of exactly what it is you want to do before anyone can help you. Please show an example of the records in each input file (relevant fields only) and what you expect for output. Explain the "rules" for getting from input to output. Give the starting position, le...
by Frank Yaeger
Wed Apr 18, 2012 9:32 pm
Forum: JCL
Topic: JCL current date
Replies: 4
Views: 4637

jvinoth,

You need to do a better job of explaining what exactly you want to do. Show an example of your input file and what you expect for output. Explain the rules for getting from input to output. ("Append into file" is too vague a description.)
by Frank Yaeger
Mon Mar 26, 2012 11:35 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: DFSORT - JOINKEYS
Replies: 7
Views: 8100

Please let me know if am clear or you need more explanation.
As previously requested, show an example of the records in your input files and the expected output for all possible cases. Your descriptions of the rules are difficult to follow, so examples would certainly help.