:
From: Frank Yaeger yae...@us.ibm.com
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 IBM-MAIN@bama.ua.edu
wrote on 09/29/2010 02:43:19 AM:
Maybe try using an E15 exit to read the input file. Stop
Terry Draper on IBM Mainframe Discussion List IBM-MAIN@bama.ua.edu 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
comments on this?
Terry Draper
zSeries Performance Consultant
w...@btopenworld.com
mobile: +66 811431287
--- On Tue, 28/9/10, Frank Yaeger yae...@us.ibm.com wrote:
From: Frank Yaeger yae...@us.ibm.com
Subject: Re: SORT question
To: IBM-MAIN@bama.ua.edu
Date: Tuesday, 28 September, 2010, 18:13
At E15 time, the file has not yet been sorted.
snip
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
-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 ascending order by a
date field
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 email
...@kbm1.com wrote:
From: Staller, Allan allan.stal...@kbm1.com
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.
snip
Maybe try using an E15 exit to read the input file. Stop passing the records
when you
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, John
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
The question
-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
From: IBM Mainframe Discussion
Terry Draper wrote on IBM Mainframe Discussion List IBM-MAIN@bama.ua.edu
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
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 the use
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 a
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
-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 ascending order by a date field
removed]
Re: SORT question
Farley, Peter x23353
to:
IBM-MAIN
09/28/2010 10:42 AM
Sent by:
IBM Mainframe Discussion List IBM-MAIN@bama.ua.edu
Please respond to IBM Mainframe Discussion List
-Original Message-
From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu
David Bettern on IBM Mainframe Discussion List IBM-MAIN@bama.ua.edu 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
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 rpin...@netscape.com 9/28/2010 9:30 AM
I
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 ahc5...@bjc.org
To: IBM-MAIN@bama.ua.edu
Subject: Re: SORT question
Date
: 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:
From
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
read
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
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 ;-)
@bama.ua.edu
Date:
28/09/2010 18:14
Subject:
Re: SORT question
Sent by:
IBM Mainframe Discussion List IBM-MAIN@bama.ua.edu
David Bettern on IBM Mainframe Discussion List IBM-MAIN@bama.ua.edu
wrote
on 09/28/2010 08:14:26 AM:
I think the real question was how to tell sort to stop reading anymore
input
Martin Packer at IBM Mainframe Discussion List IBM-MAIN@bama.ua.edu 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
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
snippage
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 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 or equal to 'S', so
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 to limit my
On Wed, 26 May 2010 07:41:49 -0500, Chase, John jch...@ussco.com
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'), so
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' (IY'), so the record
is included.
'SMO99Y' is greater than 'SMITH' (OI) and less than 'SMYTHE' (OY), so the
record is included.
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
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?
On Tue, 25 May 2010 09:59:16 -0600, Howard Brazee
howard.bra...@cusys.edu 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
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 that use the following SORTIN
SORT FIELDS
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 include numeric IDs
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
Howard Brazee on IBM Mainframe Discussion List IBM-MAIN@bama.ua.edu 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
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
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 looks
-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 position
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'0', thus
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 field
Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of
Howard Brazee
Sent: Tuesday, May 25, 2010 12:51 PM
To: IBM-MAIN@bama.ua.edu
Subject: Re: Quick Sort question
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
-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? Any position in the
'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 IBM-MAIN@bama.ua.edu wrote on 05/25/2010
12:17:02 PM:
From: Starr, Alan alan_st...@calpers.ca.gov
To: IBM-MAIN@bama.ua.edu
Date: 05/25/2010 12:18 PM
Subject: Re: Quick Sort question
Sent by: IBM
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',AND,1,1,CH,LE,C'9',AND,
2,1,CH,GE,C'0
-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
the entire field to
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; and any position in
-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 c'0' (x'F0') would
cause
John McKown on IBM Mainframe Discussion List IBM-MAIN@bama.ua.edu 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
-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 List
IBM-MAIN@bama.ua.edu wrote
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 what about
-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
Inclusion in the
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 store record count in existing
trailer
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 that:
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 question: How to store record
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 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 trailer
[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?
Snipped
Peter,
That's no problem. Here's a DFSORT job that will do what you asked
for:
//S1
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 trailer
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 PDF I see how to sort detail
records
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
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
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
...
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 that
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
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.
-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-gener,
-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
Facility
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 question for you
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?
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 number of
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 that.
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
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
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 doco
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
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 can
: 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 anyone else
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
columns
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 for:
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.
82 matches
Mail list logo
