IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

DFSORT how to SORT VB format records.


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
kaj_mei

New User


Joined: 14 Oct 2008
Posts: 4
Location: bangalore

PostPosted: Tue Oct 14, 2008 11:10 am
Reply with quote

HI my requiremnt is to sort the VB format record

Code:

  SORT  FIELDS=(52,9,CH,A,   
              80,13,CH,A,   
              1640,20,CH,A,
              1660,20,CH,A,
              1680,20,CH,A)


this is vB records so i added 4 bytes too. if we see in the file the sort starts at 48 position.when i submit the job it throw
error

Code:

ICE218A 0 694 BYTE VARIABLE RECORD IS SHORTER THAN 1699 BYTE MINIMUM FOR         FIELDS


How to resolve this?

Note: 1640,20 &1660,20&1680,20 are address field.and those are japanes charater.
52,9 policy number
80,13 doc registration number


can we give CH for Japanese character?
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales

PostPosted: Tue Oct 14, 2008 12:36 pm
Reply with quote

Take a look at the following options in the DFSORT manuals.

VLSHRT VLSCMP
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Tue Oct 14, 2008 12:51 pm
Reply with quote

Quote:
can we give CH for Japanese character?


the issue is not with japanese characters
it is that You are trying to process data outside the current record length

somewhere in Your logic ( application design ) there is a flaw,
You are expecting records with a 1xxx something length,
but You get also some record which are shorter, but most important they do not seem to contain the info You expect
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Developer


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

PostPosted: Tue Oct 14, 2008 8:36 pm
Reply with quote

kaj_mei,

If you use DFSORT's VLSHRT option, the "short" records will be sorted as if the missing characters are binary zeros. If that's what you want to do, then you can add the following to your job:

Code:

//DFSPARM DD *
   OPTION VLSHRT
/*


If you want to handle the "short" records in some other way, you need to explain how you want to handle them.

expat,

VLSHRT applies to SORT/MERGE, SUM, and INCLUDE/OMIT.

VLSCMP only applies to INCLUDE/OMIT, not SORT/MERGE, so it's not relevant in the situation described here.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts Need to set RC4 through JCL SORT DFSORT/ICETOOL 5
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Populate last day of the Month in MMD... SYNCSORT 2
No new posts Modifying Date Format Using DFSORT DFSORT/ICETOOL 9
No new posts Compare only first records of the fil... SYNCSORT 7
Search our Forums:

Back to Top