Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
SPLICE ON data greater than 1500

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
anshul_gugnani

New User


Joined: 02 Nov 2009
Posts: 73
Location: Mumbai

PostPosted: Tue Jul 06, 2010 7:07 pm    Post subject: SPLICE ON data greater than 1500
Reply with quote

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
View user's profile Send private message

sqlcode1

Active Member


Joined: 08 Apr 2010
Posts: 578
Location: USA

PostPosted: Tue Jul 06, 2010 10:12 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Tue Jul 06, 2010 11:05 pm    Post subject:
Reply with quote

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
View user's profile Send private message
anshul_gugnani

New User


Joined: 02 Nov 2009
Posts: 73
Location: Mumbai

PostPosted: Wed Jul 07, 2010 12:34 pm    Post subject:
Reply with quote

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
View user's profile Send private message
CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2150
Location: At my coffee table

PostPosted: Wed Jul 07, 2010 3:29 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Skolusu

Senior Member


Joined: 07 Dec 2007
Posts: 2205
Location: San Jose

PostPosted: Wed Jul 07, 2010 9:33 pm    Post subject:
Reply with quote

anshul_gugnani,

Try the method listed here

http://www.ibmmainframes.com/viewtopic.php?p=125375#125375
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Wed Jul 07, 2010 10:10 pm    Post subject:
Reply with quote

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
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Jul 07, 2010 10:46 pm    Post subject: Reply to: SPLICE ON data greater than 1500
Reply with quote

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. . . icon_neutral.gif

d
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Moving a COMP-3 Variable to a Numeric... ajayachander COBOL Programming 2 Thu Dec 14, 2017 5:46 pm
No new posts Extract record for change in combinat... Trinadh DFSORT/ICETOOL 6 Thu Nov 23, 2017 3:32 pm
No new posts Fetching data from JHS as per the cur... arunsoods All Other Mainframe Topics 4 Wed Nov 22, 2017 1:54 pm
No new posts Extract Record using range of Data scorp_rahul23 DFSORT/ICETOOL 3 Wed Nov 15, 2017 11:54 pm
No new posts Updating data from one file to other!!! Vignesh Sid SYNCSORT 1 Mon Nov 06, 2017 2:42 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us