I am using Sycsort Z/OS 1.3.1 version. I have IMS DB unloads which is VB length(4000).The file have one level1 segment(01) and six level2 segments(02).I want the file to be sorted on the basis of expiry date which is present in the level1 segment(starts-26,4).The file structure is as follows:
Pos 1-2 - Level number (01,02,02…,01,02,02,….)
Pos 3-10 -Segment Name
Pos 11-12 -Length of each segment(variable length)
After Pos 12 - Data
For example: (expiry date format is year month—YYMM)
Input file:
01segment1..xxxxxxxxxxxxx9912xxxxxxxxxxxxxxxxxxx
02segment2..xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
02segment3..xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
02segment4..xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
02segment5..xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
02segment6..xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
01segment1..xxxxxxxxxxxxx0912xxxxxxxxxxxxxxxxxxx
02segment2..xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
02segment3..xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
02segment4..xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
02segment5..xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
02segment6..xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
01segment1..xxxxxxxxxxxxx1009xxxxxxxxxxxxxxxxxxx
02segment2..xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
02segment3..xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
02segment4..xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
02segment5..xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
02segment6..xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
Rajasekhar K,
Welcome to the forums.
Can you explain how 9912 is coming last in your expected output. When handling 2-digit YY year fields, you need to be sure about how the century part CC has to be expanded before sorting. Are you considering this as 2099?.
The last year century Never come in the Input file.Input file contains the expiry date as "0010" means 2000-october and "9912" means
2099-december only.