MVSFORUMS.com

taurian · Beginner Joined: 20 May 2004 Posts: 12 Topics: 6

I have SYNCSORT in my shop and I am trying to use SPLICE and it is not able to recognize, it says 'STATEMENT DOES NOT BEGIN WITH A VALID OPERATOR'. Is it a problem with the version..please let me know.

I am trying to use splice to get the following done

FILEA: (VB) LRECL: 224 it can have duplicates,key start at positon 3 and ends in 14
FILEB: (FB) LRECL: 12, no duplciates, key starts at 1 and ends in 12

I need to read each of FILE2 records and get all the matching records in FILE1.

Can I acheive this without using SPLICE, but using SYNCSORT

kolusu · Posted: Thu May 20, 2004 2:41 pm Post subject:

taurian,

It is not the problem with your version .Syncsort does not support SPLICE operator of DFSORT. None of the syncsort versios support SPLICE.

What is the total no: of records in fileb? If it is less than 500 , you can generate Dynamic include conditions and get the desired results.

Do you have easytrieve at your shop? If so then it is very easy to get the desired results.

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

taurian · Beginner Joined: 20 May 2004 Posts: 12 Topics: 6

Total number of records in FileB can be upto 60,000.

Easytreive hmm..I dont have it in my shop Sad

So there is no way doing this without COBOL/SAS/EASYTREIVE/DFSORT and using just the basic IBM utilities

Thanks alott for your time

vkrishna2001 · Posted: Thu May 20, 2004 4:48 pm Post subject:

Taurian,

It is easy to do it in Cobol or Easytrieve if the records in both the files are sorted in either ascending or descending order of the key. If you have Focus at your shop the same can be achieved with a stored procedure.

Vijay