Terry Draper on IBM Mainframe Discussion List wrote
on 09/30/2010 04:18:38 AM:
> Frank,
> I did not plan for SORT to read the records. SORTIN is dummy. The
> exit reads the records directly and inserts the records into sort. I
> have written many such E15 exits to process SMF data. The E15 does
Yaeger
Subject: Re: SORT question
To: IBM-MAIN@bama.ua.edu
Date: Wednesday, 29 September, 2010, 20:30
Terry Draper wrote on IBM Mainframe Discussion List
wrote on 09/29/2010 02:43:19 AM:
> Maybe try using an E15 exit to read the input file. Stop passing the
> records when you reach the date
On Wed, 29 Sep 2010 15:17:33 -0400, Farley, Peter x23353 wrote:
>
>IIRC, the restriction against legacy datasets is only for programs that do not
>use "fopen" for their files. As of the last time I tested it awk apparently
>does use "fopen".
>
Would you commit to supporting code which relies on
On Wed, 29 Sep 2010 12:01:22 -0500, McKown, John wrote:
>
>Hum, can awk read legacy datasets? If so, then sure, go for it. Or use "cp".
>
"z/OS V1R12.0 UNIX System Services Command Reference"
Appendix K. ... Utilities supporting MVS data set names
The following utilities currently support t
Terry Draper wrote on IBM Mainframe Discussion List
wrote on 09/29/2010 02:43:19 AM:
> Maybe try using an E15 exit to read the input file. Stop passing the
> records when you reach the date higher than required..
> I am not sure how I would pass the date to the E15. Could it be a
> parm. Or it cou
> -Original Message-
> From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On
> Behalf Of McKown, John
> Sent: Wednesday, September 29, 2010 1:01 PM
> To: IBM-MAIN@bama.ua.edu
> Subject: Re: SORT question
>
> __
New York, NY 10004
Telephone: 212-276-5641
Cell: 917-597-5692
-Original Message-
From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of
Terry Draper
Sent: Wednesday, September 29, 2010 11:41 AM
To: IBM-MAIN@bama.ua.edu
Subject: Re: SORT question
Th
From: IBM Mainframe Discussion List [ibm-m...@bama.ua.edu] On Behalf Of Shane
Ginnane [ibm-m...@tpg.com.au]
Sent: Wednesday, September 29, 2010 9:28 AM
To: IBM-MAIN@bama.ua.edu
Subject: Re: SORT question
On Thu, Sep 30th, 2010 at 12:15 AM, "McKown,
te:
From: Staller, Allan
Subject: Re: SORT question
To: IBM-MAIN@bama.ua.edu
Date: Wednesday, 29 September, 2010, 15:05
At E15 time, the file has not yet been sorted.
Maybe try using an E15 exit to read the input file. Stop passing the records
when you reach the date higher than required..
On Thu, Sep 30th, 2010 at 12:15 AM, "McKown, John" wrote:
> Of course COBOL would be fairly simple and much more efficient.
How about awk ?.
Shane ...
--
For IBM-MAIN subscribe / signoff / archive access instructions,
send emai
> -Original Message-
> From: IBM Mainframe Discussion List
> [mailto:ibm-m...@bama.ua.edu] On Behalf Of Richard Pinion
> Sent: Tuesday, September 28, 2010 9:31 AM
> To: IBM-MAIN@bama.ua.edu
> Subject: SORT question
>
> I have a large file that is sorted in asce
At E15 time, the file has not yet been sorted.
Maybe try using an E15 exit to read the input file. Stop passing the records
when you reach the date higher than required..
I am not sure how I would pass the date to the E15. Could it be a parm. Or it
could be read from a separate single record i
comments on this?
Terry Draper
zSeries Performance Consultant
w...@btopenworld.com
mobile: +66 811431287
--- On Tue, 28/9/10, Frank Yaeger wrote:
From: Frank Yaeger
Subject: Re: SORT question
To: IBM-MAIN@bama.ua.edu
Date: Tuesday, 28 September, 2010, 18:13
David Bettern on IBM Mainframe
Martin Packer at IBM Mainframe Discussion List wrote
on 09/28/2010 12:19:50 PM:
> E15 exit? NOT the nicest of solutions. :-(
The only way an E15 could stop DFSORT from processing all of the records
would be to pass back RC=16 which DFSORT would interpret as terminate
with RC=16. The condition co
/2010 18:14
Subject:
Re: SORT question
Sent by:
IBM Mainframe Discussion List
David Bettern on IBM Mainframe Discussion List
wrote
on 09/28/2010 08:14:26 AM:
> I think the real question was how to tell sort to stop reading anymore
> input records when it reaches the first record that
On 28 Sep 2010 11:17:40 -0700, st...@trainersfriend.com (Steve
Comstock) wrote:
>> One reason for writing my own code is that all of the programmers can
>> read and maintain CoBOL or EasyTrieve.But most only know the
>> simplest basics in the SORT utility.
>
>We can fix that ;-)
>
> http://w
On 9/28/2010 11:44 AM, Howard Brazee wrote:
On 28 Sep 2010 10:29:46 -0700, rpin...@netscape.com (Richard Pinion)
wrote:
That's what we have done. We were hoping SORT would be able to do it.
We would rather use a system utility as opposed to writing our own code.
One reason for writing my own
On 28 Sep 2010 10:29:46 -0700, rpin...@netscape.com (Richard Pinion)
wrote:
>That's what we have done. We were hoping SORT would be able to do it.
>We would rather use a system utility as opposed to writing our own code.
One reason for writing my own code is that all of the programmers can
rea
: Tuesday, September 28, 2010 10:28 AM
To: IBM-MAIN@bama.ua.edu
Subject: Re: SORT question
That's what we have done. We were hoping SORT would be able to do it.
We would rather use a system utility as opposed to writing our own code.
Richard, Vickie, and Randy Pinion
--- ahc5...@bjc.org wrote:
That's what we have done. We were hoping SORT would be able to do it. We
would rather use a system utility as opposed to writing our own code.
Richard, Vickie, and Randy Pinion
--- ahc5...@bjc.org wrote:
From: Al Cole
To: IBM-MAIN@bama.ua.edu
Subject: Re: SORT question
Date: Tu
What you want is a cobol program that uses a sysing parm file containing the
selection criteria variables.
Alfred Cole
BJC HealthCare
mailstop 92-92-117
8374 Eager Road Suite 200
St Louis, MO 63144
(314) 362-7837
ahc5...@bjc.org
>>> "Richard Pinion" 9/28/2010 9:30 AM >>>
I have a large fil
David Bettern on IBM Mainframe Discussion List wrote
on 09/28/2010 08:14:26 AM:
> I think the real question was how to tell sort to stop reading anymore
> input records when it reaches the first record that's greater than the
> selection criteria instead of reading through the rest of the file but
rom: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On
> > Behalf Of Richard Pinion
> > Sent: Tuesday, September 28, 2010 10:31 AM
> > To: IBM-MAIN@bama.ua.edu
> > Subject: SORT question
> >
> > I have a large file that is sorted in ascending order by a d
> -Original Message-
> From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On
> Behalf Of Richard Pinion
> Sent: Tuesday, September 28, 2010 10:31 AM
> To: IBM-MAIN@bama.ua.edu
> Subject: SORT question
>
> I have a large file that is sorted in ascendi
I have a large file that is sorted in ascending order by a date field,
MMDD. I want to run a sort fields=copy with selection criteria against
this file. One of the selection criteria is the date field. I would like the
sort to terminate once the date field in the file is greater than my s
Makes you wonder whether some people should be trusted with the CLC
instruction!
--
Regards, Gord Tomlin
Action Software International
(a division of Mazda Computer Corporation)
Tel: (905) 470-7113, Fax: (905) 470-6507
Frank Yaeger wrote:
Huh. DFSORT is doing exactly what it's supposed to do
Huh. DFSORT is doing exactly what it's supposed to do.
INCLUDE COND=(1,6,CH,GE,C'SMITH ',AND,1,6,CH,LE,C'SMYTHE')
'SMITH' is equal to 'SMITH' and less than 'SMYTHE' (II) and less than 'SMYTHE' (OI) and less than 'SMYTHE' (OI) and eqaul to 'SMYTHE', so the record
is included.
'SMILEY' is less
On Wed, 26 May 2010 07:41:49 -0500, Chase, John
wrote:
>> -Original Message-
>> From: IBM Mainframe Discussion List On Behalf Of Zaromil Tisler
>>
>> On Tue, 25 May 2010 14:05:08 -0500, Chase, John wrote:
>>
>>
>> >
>> >As specified, the second ("upper") bound is (1,6,CH,LE,C'SMYTHE'), s
On 26 May 2010 05:43:06 -0700, jch...@ussco.com (Chase, John) wrote:
>> SORTOUT contains following records, the same as SORTIN:
>>
>> SMITH
>> SMO99Y
>> SMO#$!
>> SMYTHE
>
>Amazing, baffling and befuddling. I get the same counter-intuitive
>result.
>
>I won't even try to guess why; I'll just try
> -Original Message-
> From: IBM Mainframe Discussion List On Behalf Of Zaromil Tisler
>
> On Tue, 25 May 2010 14:05:08 -0500, Chase, John wrote:
>
>
> >
> >As specified, the second ("upper") bound is (1,6,CH,LE,C'SMYTHE'), so
> >"do the comparisons":
> >
> >First character 'S' is less o
On Tue, 25 May 2010 14:05:08 -0500, Chase, John wrote:
>> -Original Message-
>> From: IBM Mainframe Discussion List On Behalf Of John H Kington
>> >Visualize it with these parameters:
>>
>> >INCLUDE COND=(1,6,CH,GE,C'SMITH ',AND,1,6,CH,LE,C'SMYTHE')
>> >
>> >Show how, e.g., c'SMILEY' in
> -Original Message-
> From: IBM Mainframe Discussion List On Behalf Of John H Kington
>
> John,
> >
> > >Visualize it with these parameters:
> >
> > >INCLUDE COND=(1,6,CH,GE,C'SMITH ',AND,1,6,CH,LE,C'SMYTHE')
> > >
> > >Show how, e.g., c'SMILEY' in positions 1 through 6 would qualify
for
John,
>
> >Visualize it with these parameters:
>
> >INCLUDE COND=(1,6,CH,GE,C'SMITH ',AND,1,6,CH,LE,C'SMYTHE')
> >
> >Show how, e.g., c'SMILEY' in positions 1 through 6 would qualify for
> >Inclusion in the output.
>
> SMILEY would fail because every character is the same until you hit
the L but wh
> -Original Message-
> From: IBM Mainframe Discussion List
> [mailto:ibm-m...@bama.ua.edu] On Behalf Of Frank Yaeger
> Sent: Tuesday, May 25, 2010 2:10 PM
> To: IBM-MAIN@bama.ua.edu
> Subject: Re: Quick Sort question
>
> John McKown on IBM Mainframe Discussion L
John McKown on IBM Mainframe Discussion List wrote
on 05/25/2010 11:30:13 AM:
> Still easier to use:
>
> INCLUDE COND=(1,9,FS,EQ,NUM)
>
> It is rather new, to me.
>
> ref: http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/
> ICE1CA30/3.7.14.1
Hardly new.
DFSORT has had the NUM function
> -Original Message-
> From: IBM Mainframe Discussion List On Behalf Of John H Kington
>
> John,
>
> > John,
> > >>
> > >> >INCLUDE COND=(1,9,CH,GE,C'0',AND,1,9,CH,LE,C'9')
> > >>
> > >> That would allow '00x01'.
> > >
> > >How so? Any position in the field less than
John,
> John,
> >>
> >> >INCLUDE COND=(1,9,CH,GE,C'0',AND,1,9,CH,LE,C'9')
> >>
> >> That would allow '00x01'.
> >
> >How so? Any position in the field less than c'0' (x'F0') would cause
> >the entire field to evaluate less than c'0', thus failing the
GE
> >requirement;
> -Original Message-
> From: IBM Mainframe Discussion List On Behalf Of John H Kington
>
> John,
> >>
> >> >INCLUDE COND=(1,9,CH,GE,C'0',AND,1,9,CH,LE,C'9')
> >>
> >> That would allow '00x01'.
> >
> >How so? Any position in the field less than c'0' (x'F0') would cause
Company.SM
> -Original Message-
> From: IBM Mainframe Discussion List
> [mailto:ibm-m...@bama.ua.edu] On Behalf Of Kirk Talman
> Sent: Tuesday, May 25, 2010 1:27 PM
> To: IBM-MAIN@bama.ua.edu
> Subject: Re: Quick Sort question
>
> INCLUDE COND=(1,1,CH,GE,C'0
#x27;,AND,
6,1,CH,GE,C'0',AND,6,1,CH,LE,C'9',AND,
7,1,CH,GE,C'0',AND,7,1,CH,LE,C'9',AND,
8,1,CH,GE,C'0',AND,8,1,CH,LE,C'9',AND,
9,1,CH,GE,C'0',AND,9,1,CH,LE,C'9',AND,)
IBM Mainframe Discussion List wrote on 05/25/2010
> -Original Message-
> From: IBM Mainframe Discussion List On Behalf Of Howard Brazee
>
> On 25 May 2010 10:08:09 -0700, jch...@ussco.com (Chase, John) wrote:
>
> >> >INCLUDE COND=(1,9,CH,GE,C'0',AND,1,9,CH,LE,C'9')
> >>
> >> That would allow '00x01'.
> >
> >How so? A
, if you uncomment the first testvalue above and comment out the second,
you'll find that x'f0faf0f0f0f0f0f0f0' lies between x'f0f0f0f0f0f0f0f0f0' and
x'f9f9f9f9f9f9f9f9f9'.
And x'f0faf0f0f0f0f0f0f0' is not numeric to boot!
Chuck
Charles Hardee
CA technolo
John,
>>
>> >INCLUDE COND=(1,9,CH,GE,C'0',AND,1,9,CH,LE,C'9')
>>
>> That would allow '00x01'.
>
>How so? Any position in the field less than c'0' (x'F0') would cause
>the entire field to evaluate less than c'0', thus failing the GE
>requirement; and any position in the
On 25 May 2010 10:08:09 -0700, jch...@ussco.com (Chase, John) wrote:
>> >INCLUDE COND=(1,9,CH,GE,C'0',AND,1,9,CH,LE,C'9')
>>
>> That would allow '00x01'.
>
>How so? Any position in the field less than c'0' (x'F0') would cause
>the entire field to evaluate less than c'
> -Original Message-
> From: IBM Mainframe Discussion List On Behalf Of Howard Brazee
>
> On 25 May 2010 09:18:33 -0700, alan_st...@calpers.ca.gov (Starr, Alan)
> wrote:
>
> >INCLUDE COND=(1,9,CH,GE,C'0',AND,1,9,CH,LE,C'9')
>
> That would allow '00x01'.
How so? Any
On 25 May 2010 09:48:27 -0700, yae...@us.ibm.com (Frank Yaeger) wrote:
>It's not clear to me exactly what you want to do. Do you want to
>omit records with blanks in 1-9 from the output file? Or do you
>want to make sure records with blanks in 1-9 are kept but NOT
>"summarized", or what?
It loo
On 25 May 2010 09:18:33 -0700, alan_st...@calpers.ca.gov (Starr, Alan)
wrote:
>INCLUDE COND=(1,9,CH,GE,C'0',AND,1,9,CH,LE,C'9')
That would allow '00x01'.
--
For IBM-MAIN subscribe / signoff / archive acces
Howard Brazee on IBM Mainframe Discussion List wrote
on 05/25/2010 08:59:17 AM:
> We have a lot of jobs that use the following SORTIN
>
> SORT FIELDS=(01,009,A),
>FORMAT=CH
> SUM FIELDS=NONE
>
> What is the simplest ways to change this to ensure that either we
> exclude blank data or only
On 25 May 2010 09:16:46 -0700, john.mck...@healthmarkets.com (McKown,
John) wrote:
>Excluding blanks is easiest:
>
>EXCLUDE COND=(1,9,CH,EQ,C' ')
I've used that with SORT FIELDS=COPY. Actually, it appears that
EXCLUDE won't work, it needs to be OMIT.
>Including only numeric I'm not as
ay 25, 2010 08:59
To: IBM-MAIN@bama.ua.edu
Subject: Quick Sort question
We have a lot of jobs that use the following SORTIN
SORT FIELDS=(01,009,A),
FORMAT=CH
SUM FIELDS=NONE
What is the simplest ways to change this to ensure that either we exclude blank
data or only
ealth Insurance Company.SM
> -Original Message-
> From: IBM Mainframe Discussion List
> [mailto:ibm-m...@bama.ua.edu] On Behalf Of Howard Brazee
> Sent: Tuesday, May 25, 2010 10:59 AM
> To: IBM-MAIN@bama.ua.edu
> Subject: Quick Sort question
>
> We have a lot of jobs
On Tue, 25 May 2010 09:59:16 -0600, Howard Brazee
wrote:
>
>We have a lot of jobs that use the following SORTIN
I mean SYSIN
--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@bama.ua.edu
We have a lot of jobs that use the following SORTIN
SORT FIELDS=(01,009,A),
FORMAT=CH
SUM FIELDS=NONE
What is the simplest ways to change this to ensure that either we
exclude blank data or only include numeric IDs here?
---
M11 is exactly what I needed, thank you very much!
Peter
> -Original Message-
> From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On
> Behalf Of Frank Yaeger
> Sent: Monday, March 08, 2010 2:05 PM
> To: IBM-MAIN@bama.ua.edu
> Subject: Re: SORT ques
Peter Farley wrote on 03/08/2010 10:53:05 AM:
> I just got around to trying your solution, and it works well EXCEPT...
>
> I need the output trailer count to be UNsigned zoned decimal.
>
> Is there any way I can make the trailer count unsigned ZD? I tried
>specifying TO=UFF, but it did not like tha
y way I can make the trailer count unsigned ZD?
Peter
> -Original Message-
> From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On
> Behalf Of Frank Yaeger
> Sent: Wednesday, March 03, 2010 12:45 PM
> To: IBM-MAIN@bama.ua.edu
> Subject: Re: SORT question: How to
ussion List [mailto:ibm-m...@bama.ua.edu] On
> Behalf Of Frank Yaeger
> Sent: Wednesday, March 03, 2010 12:45 PM
> To: IBM-MAIN@bama.ua.edu
> Subject: Re: SORT question: How to store record count in existing
trailer?
> Peter,
>
> That's no problem. Here's a DFSORT job
Peter Farley wrote on 03/03/2010 07:16:55 AM:
> Thanks for the suggested solutions. In my case, the header and trailer
> are identifiable (HDR=X'00', TRLR=X'FF', pos 1 for let's say at least 10
> bytes).
>
> The file is VB, LRECL=8004, and the data records vary widely in length.
> Header and trail
Hi Frank,
Thanks for the suggested solutions. In my case, the header and trailer
are identifiable (HDR=X'00', TRLR=X'FF', pos 1 for let's say at least 10
bytes).
The file is VB, LRECL=8004, and the data records vary widely in length.
Header and trailer are length 700 always, but both header and
Peter,
I suspect you've gone home for the day and I'll be in a few hours after you
in the morning
(I'm on the West Coast).
So I'll show you some examples of how to do what you want to do with
DFSORT/ICETOOL.
I'm assuming that your input file has RECFM=FB and LRECL=80. If it has
RECFM=VB and/or
a
Peter Farley wrote on 03/02/2010 02:30:27 PM:
> SORT question: How to store record count in existing trailer?
>
> I suspect this is a question for Frank Yaeger, but if anyone else has
> done this I'd appreciate the help.
>
> Looking at the "Smart DFSORT Tricks&q
I suspect this is a question for Frank Yeager, but if anyone else has
done this I'd appreciate the help.
Looking at the "Smart DFSORT Tricks" PDF I see how to sort detail
records between a header and a trailer. So far, so good.
Now, though, I need to reset the record count in the existing traile
Rajeev wrote on 09/21/2007 11:48:32 AM:
> You may try this out
> Use ICETOOL
> TOOLIN
> COPY from Rawin to INVDATA using CTL1
> COPY FROM RAWIN to FINAL using CTL2
> COPY FROM INVDATA TO FINAL USING CTL3
> COPY FROM RAWIN TO FINAL USING CTL4
>
You may try this out
Use ICETOOL
TOOLIN
COPY from Rawin to INVDATA using CTL1
COPY FROM RAWIN to FINAL using CTL2
COPY FROM INVDATA TO FINAL USING CTL3
COPY FROM RAWIN TO FINAL USING CTL4
CTL1CNTL
OUTFIL FNAMES=INVDATA
On 20 Sep 2007 08:19:01 -0700, [EMAIL PROTECTED] (Frank Yaeger)
wrote:
>Yes, and I believe it does what you want based on your examples.
>If not, then please show an example of input records where it
>doesn't do what you want and the expected output for those
>input records.
Thanks.
Howard Brazee wrote on 09/20/2007 07:39:37 AM:
> I see you gave code elsewhere.
> ...
Yes, and I believe it does what you want based on your examples.
If not, then please show an example of input records where it
doesn't do what you want and the expected output for those
input records.
Frank Yaeg
Maybe add a sequence number to all input records and then sort by record
type /sequence number.
On 9/20/07, Howard Brazee <[EMAIL PROTECTED]> wrote:
>
> On 19 Sep 2007 13:15:46 -0700, in bit.listserv.ibm-main you wrote:
>
> >> I forgot to say - the sort can't change the order of transactions of a
On 19 Sep 2007 13:15:46 -0700, in bit.listserv.ibm-main you wrote:
>> I forgot to say - the sort can't change the order of transactions of a
>> particular type.
>
>I'm not sure what you mean by that. Can you please show and explain an
>example of your input records and expected output records tha
On Wed, 19 Sep 2007 13:48:37 -0600, Howard Brazee <[EMAIL PROTECTED]>
wrote:
>I forgot to say - the sort can't change the order of transactions of a
>particular type.
>
After Frank provides a sample (which I'm sure he will), make sure the
sort control statements include "EQUALS".
Mark
--
Mark Z
Howard Brazee wrote on 09/19/2007 12:48:37 PM:
> I forgot to say - the sort can't change the order of transactions of a
> particular type.
I'm not sure what you mean by that. Can you please show and explain an
example of your input records and expected output records that clarifies
what you need.
Howard Brazee wrote on 09/19/2007 11:07:40 AM:
> I have a file that a vendor wants sorted.
>
> H 09/10/20071250COLOR
> M top_right_message
> M top_right_message
> M top_right_message
> M top_right_message
> M top_right_message
> M top_right_message
> M top_right_message
> M top_right_message
> D 11
I forgot to say - the sort can't change the order of transactions of a
particular type.
--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO
Search
lude it in the output records.
-Original Message-
From: Howard Brazee [mailto:snip]
Sent: Wednesday, September 19, 2007 11:08 AM
To: IBM-MAIN@BAMA.UA.EDU
Subject: Sort question
I have a file that a vendor wants sorted.
H 09/10/20071250COLOR
M top_right_message
M top_right_me
I have a file that a vendor wants sorted.
H 09/10/20071250COLOR
M top_right_message
M top_right_message
M top_right_message
M top_right_message
M top_right_message
M top_right_message
M top_right_message
M top_right_message
D 1detailsR07
I 108/15/2007
>Aren't they the ones whose subsystem includes the program IGDZILLA?
IGD is the prefix for SMS.
When it came out, somebody on the storage team had a sense of humour because of
the size of the main SMS programme called by the STC.
-
Too busy driving to stop for gas!
---
> -Original Message-
> From: IBM Mainframe Discussion List On Behalf Of Charles Mills
>
> So many MVS utilities have vernacular names that consist of a
> 3-letter prefix followed by a functional name, they just seem
> to roll off the tongue that way: I-E-B-copy, I-E-H-program,
> I-E-B-g
So many MVS utilities have vernacular names that consist of a 3-letter
prefix followed by a functional name, they just seem to roll off the tongue
that way: I-E-B-copy, I-E-H-program, I-E-B-gener, I-E-B-print/punch,
I-E-H-init, I-E-H-list, I-E-B-update, D-F-H-sort.
I-D-C-access-method-services see
On Tue, 30 Jan 2007 15:34:52 -0800, Frank Yaeger wrote:
>I have a question for you (or anyone else on the list if they can shed some
>light on it) about something I'm curious about. I noticed you said
>"DFHSORT" instead of "DFSORT" (Data Facility Sort). You're not the first
>person to call it th
On Jan 31, 6:33 am, Tim Burkart wrote:
> Even though "DFSORT will NOT stop as soon as it gets two records for
> each value, but it will give you up to two records for each value"
> could it be done via an exit? In general can DFSORT be directed to
> stop processing after creating a predefined numb
On 30 Jan 2007 13:50:10 -0800, [EMAIL PROTECTED] (George, William ,
DHS-ITSD) wrote:
>Note: I can write a simple REXX to do this but need to do it in SORT.
>Double sigh.
Most any language would do this - why do you need to do it in SORT?
--
Well, I was sorta thinking maybe an HSM Sort functionality, or an SMS
something or other.
On Wed, 31 Jan 2007 07:52:24 -0600, Chase, John <[EMAIL PROTECTED]> wrote:
>> -Original Message-
>> From: IBM Mainframe Discussion List On Behalf Of Frank Yaeger
>>
>> [ snip ]
>>
>> I have a questi
> -Original Message-
> From: IBM Mainframe Discussion List On Behalf Of Frank Yaeger
>
> [ snip ]
>
> I have a question for you (or anyone else on the list if they
> can shed some light on it) about something I'm curious about.
> I noticed you said "DFHSORT" instead of "DFSORT" (Data
: SORT question
Wiiliam George wrote on 01/30/2007 03:09:41 PM:
> Thanks Frank, I'll check this out to see if I can fit it to my needs!
>
> Bill
You're welcome. If you need help modifying the job, feel free to
contact
me offline with more details.
I have a question for you (or
Wiiliam George wrote on 01/30/2007 03:09:41 PM:
> Thanks Frank, I'll check this out to see if I can fit it to my needs!
>
> Bill
You're welcome. If you need help modifying the job, feel free to contact
me offline with more details.
I have a question for you (or anyone else on the list if they ca
Thanks Frank, I'll check this out to see if I can fit it to my needs!
Bill
--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO
Search the archives
George William wrote on 01/30/2007 01:49:58 PM:
> It's been awhile since I've had to use DFHSORT (PGM=SORT) and am
> returning to a project where I'll need it.
>
> There is an immediate situation I'd like to deal with but the saved
> SORTs I have do not seem to deal with it and my looking through d
It's been awhile since I've had to use DFHSORT (PGM=SORT) and am
returning to a project where I'll need it.
There is an immediate situation I'd like to deal with but the saved
SORTs I have do not seem to deal with it and my looking through doco has
not yielded any help.
I'd like to take an input
Howard Brazee wrote:
>That will get rid of the dashes, but it won't sort the two columns of
>key data and two columns of non-key data into a table.
Howard,
The INCLUDE keeps only the records with the dashes. You can use a SORT
statement to sort on the fields in their original places.
Alternati
"Howard Brazee" <[EMAIL PROTECTED]> wrote on 04/28/2006 10:22:34 AM:
> Attached is an extract of the input file.
>
> Output file will start with:
> 101800195176
> 201801201036
>
Howard,
Based on the information you sent me offline, I believe this DFSORT job
will do what you asked
Howard Brazee wrote:
>I am reading in a text document and want to create a sorted table.
>
>The document has a key in two places, based on SSN (with a suffix)
>looking like 123-45-6789-01 (columns 59-72 & 92-105).The other
>number for the table is in 123-45-6789 format in columns 34-44 & in
>
90 matches
Mail list logo