View previous topic :: View next topic
|
Author |
Message |
prem_ibm
New User
Joined: 15 Sep 2007 Posts: 31 Location: Chennai
|
|
|
|
Hi All,
Please suggest on below scenario.
1) Whether SORT (JOINKEY) will support for Huge files (input files have
millions of records).
2) Whehter SORT (JOINKEY) will support for TAP Data sets (here input file
on Tapes)
here my intention...is i want to use without copying TAP data set to
DASD data set.
3) Considered both the Input file & O/p file are -- RECFM=FB.
4) i am going to Compare one Field say WS-NAME which is present in
both the files.
5) Considered that WS-NAME position in first file at (10,5) where as in
second file at (70,5).
6) Also let me know what will be the max length...at which SORT
(JOINKEY) support.
Please suggest for Points 1,2 & 6.....all of your response/reply on this is
much aprreciated.Thanks |
|
Back to top |
|
|
smijoss
Active User
Joined: 30 Aug 2007 Posts: 114 Location: pune
|
|
|
|
I generally use ICEGENER for tape, but that means u can use SORT for TAPE as ICEGENER calls SORT.
If your files are huge you need to specify region=0M.
not sure of the MAXIMUM size.
why dont you just execute it and let us know the result / error trace.
it should be a homework for us |
|
Back to top |
|
|
smijoss
Active User
Joined: 30 Aug 2007 Posts: 114 Location: pune
|
|
|
|
from "User Guide for DFSORT PTFs UK51706 and UK51707"
The REFORMAT statement :
The maximum length for TYPE=F joined records is 32760 bytes. The F1 and F2 files can both be fixed-length, both be variable-length, or can be
mixed fixed-length and variable-length.
The maximum length for TYPE=V joined records is 32767 bytes.
The F1 and F2 files can both be variable-length or can be mixed fixed-length and variable-length. |
|
Back to top |
|
|
Skolusu
Senior Member
Joined: 07 Dec 2007 Posts: 2205 Location: San Jose
|
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
Quote: |
I generally use ICEGENER for tape, but that means u can use SORT for TAPE as ICEGENER calls SORT. |
DFSORT supports tape. ICEGENER has nothing to do with JOINKEYS.
Quote: |
If your files are huge you need to specify region=0M.
not sure of the MAXIMUM size. |
You DO NOT necessarily need to specify REGION=0M for large files. Please don't make erroneous general statements like this. |
|
Back to top |
|
|
smijoss
Active User
Joined: 30 Aug 2007 Posts: 114 Location: pune
|
|
|
|
Frank ,
I m sorry about that. will be careful next time |
|
Back to top |
|
|
prem_ibm
New User
Joined: 15 Sep 2007 Posts: 31 Location: Chennai
|
|
|
|
Thanks to Every one for u r reply.
Regards
Prem |
|
Back to top |
|
|
|