View previous topic :: View next topic
|
Author |
Message |
anshul_gugnani
New User
Joined: 02 Nov 2009 Posts: 73 Location: Mumbai
|
|
|
|
Need Help. We can do the above using SPLICE operator. But when I tried doing, the ON keyword allows only 1500 length data to be compared.
However, in the above question record length is 4595 and he needs to compare the whole record.
Please suggest. |
|
Back to top |
|
|
sqlcode1
Active Member
Joined: 08 Apr 2010 Posts: 577 Location: USA
|
|
|
|
What exactly are you trying to do with SPLICE? Compare files or something else?
Here is what I found from some other forum a while ago.
Quote: |
The limitation of 1500 is for a single ON parm. You can have multiple ON parms, but the total key length for comparison should not exceed 4088 bytes. Try this DFSORT/ICETOOL job |
But since you are dealing with 4595 bytes, it may still not work for you.
Thanks, |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
Quote: |
But since you are dealing with 4595 bytes, it may still not work for you. |
It won't. That's beyond the allowable limit. |
|
Back to top |
|
|
anshul_gugnani
New User
Joined: 02 Nov 2009 Posts: 73 Location: Mumbai
|
|
|
|
Hi Frank,
How can we compare two files where the record length is say - 4595 and I need to compare the whole record.
Please suggest how can we accomplish this. If this can be done using multiple ON parameter - can you please suggest how??
Thanks,
Anshul. |
|
Back to top |
|
|
CICS Guy
Senior Member
Joined: 18 Jul 2007 Posts: 2146 Location: At my coffee table
|
|
|
|
As Frank already wrote: |
That's beyond the allowable limit. |
Have you considered a solution based on a programming language?
Have you thought of some multiple pass solution?
As a Programmar Analyst, you should be thinking about alternative methods. |
|
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: |
How can we compare two files where the record length is say - 4595 and I need to compare the whole record. |
Why not use an actual COMPARE utility like IEBCOMPR, SUPERC, Beyond Compare, etc.
(Although DFSORT can do some comparisons, it is NOT a COMPARE utility.) |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hi Frank,
Quote: |
Why not use an actual COMPARE utility like IEBCOMPR, SUPERC, Beyond Compare, etc. |
In many cases (though not this one) - Because you won't code those solutions. . .
d |
|
Back to top |
|
|
|