View previous topic :: View next topic
|
Author |
Message |
Skolusu
Senior Member
Joined: 07 Dec 2007 Posts: 2205 Location: San Jose
|
|
|
|
Thank you very much for the DFSORT links. But my question is still unanswered, I want to see the specific link where EQUALS is used even for COPY operations as you seem to highlight here
Dale Robertson wrote: |
from the DFSORT programming guide:
EQUALS The sequence of records that collate identically [even if COPY] is preserved from input to output - with either the MERGE or SORT instruction. |
So can you please show me where the EQUALS is being used for COPY operation.
Dale Robertson wrote: |
It would be wise if you actually did some tests as well as to read in all of the places where that option exists as reading will only get you so far because often times the documentation is incomplete or misleading sadly. |
In your prior posts you were implying that documentation had it described and now you are saying that it is incomplete or misleading ?
As for testing how about you do just 1 test for me.
1. Create a file with LRECL=5042
2. Write 50 or as many as you feel like records into that file with the following data
Code: |
Position 1 - 5000 = spaces
Position 5001 = 'DALE ROBERTSON DUPLICATE RECORD # '
Position 5034 = 8 byte sequence number to number the records
|
Now use a COPY operation to copy with NOEQUALS and show me that DFSORT did NOT COPY the records as is.
The maximum length of the collected control fields (sort fields) is 4088 bytes with Equals ON.
The above created dataset has spaces in first 5000 bytes and all the records are duplicates. So without EQUALS option I am not guaranteed to get the records as it is. ? Is that what you are inferring? Never Knew SORT products supported keys greater than 4k. The largest LRECL you can have on z/OS is 32767. Which utility would you use to COPY such files?
Dale Robertson wrote: |
Realize also that there is more documentation with SyncSort and even SAS Programming Tips: Guide to Efficient SAS Programming [1st Edition 1991] - which surprisingly gave the best advice on EQUALS!!!
Good luck.
r |
Please do NOT QUOTE Syncsort documentation as a source for how DFSORT works. |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
Dale, perhaps you can post the piece from the SAS documentation? Exactly as it is, with no editorial from yourself. |
|
Back to top |
|
|
|