Syncsort getting values from tapes

raj12vel · Posted: Mon Sep 28, 2009 4:09 am

Hi All,

I have a requirement to get unique value from Tapes (Variable block) and the corresponding tape name.

For Example,

Input file

XXX.YYY.*.MTD ==> All the qualifiers are same for all the tapes except the 3rd qualifier ( gave as *) . Have more than 100 tapes with the same qualifiers.

Value starts at position 9 ends at 14 (lenth = 6 bytes)

Required Output:-

gcicchet · Posted: Mon Sep 28, 2009 10:56 am

Hi,

it's probably just me, I haven't the foggiest idea what you are after, what constitutes a unique value from each tape and how do you test for it ?

I'm sure there are more questions but I don't even know where to start.

Gerry

raj12vel · Posted: Mon Sep 28, 2009 1:53 pm

Hi,

Fot testing purpose, I have already converted some of the TAPE files into Sequential files. So thats not a problem.

is there any better way to get the value and its corresponding tape name in the output file?

Just let me know if any other information is required.

dick scherrer · Posted: Mon Sep 28, 2009 7:53 pm

Hello,

expat · Posted: Mon Sep 28, 2009 8:08 pm

What exactly are you after, a list of tapes within a certain dataset name mask ?

raj12vel · Posted: Mon Sep 28, 2009 10:18 pm

Hello

Input file is a Tape file with the LRECL of 2128 bytes Variable Block.

I need to get one field value, lets say user-id ( From Position 9 to 14).

There are duplicates in the input file so i need only unique user-id's.

Thats why i have mentioned before as need to get Unique values from the TAPE files.

Hence output file should contain the unique Account no's as well as its corresponding TAPE file name on which it belongs to.

superk · Posted: Mon Sep 28, 2009 11:09 pm

AR:

The forum has already gone over the process for selecting only the unique records from a file here in this previous topic from you and well as using the SYMNAMES DD to pass the dataset name into your sort process. What more details do you need?

I'm locking this topic. I'd suggest, if you still don't know how to proceed from this point, that you contact the Syncsort Technical Support directly and post your questions and concerns to them.