Join this group to access featured content and participate in discussions related to all Syncsort Mainframe Products.

96 Members
Join Us!

All Discussions (78)

Sort by

Parse and dedupe

I receive a delimited file from a client that I parse the first field which is an email address and then I dedupe the file.  My problem is that some of the data they are sending me is quote surrounded.  I am not sure how I can parse the file on…

Read more…
1 Reply · Reply by Josh Verne Feb 16

JOINKEYS Query

Hi Team,

I have a question, I have two files, like to compare and print if matches not found on file2. So I have coded below logic.

//STEP001 EXEC PGM=SORT

//SORTWK01 DD DSN=&&SORT1,UNIT=3390,

//…

Read more…
1 Reply · Reply by Anthony Jan 30

VSCORE x VSCORET

Hi all,

My name is Fábio. I work in a big Bank here in Brazil and we are a big customer of Syncsort (PHDBrasil).

I have some doubts about these parameters. Sorry if my questions sounds "dummy" but they will be very important to…

Read more…
0 Replies

JOINKEYS Question

My question is two-fold: First, are there "do's and don'ts" when deciding to use JOINKEYS?.... I have a developer that tried to do a simple JOINKEYS between a file of 3500 records and a file of 12,000,000 records. The JOINKEYS job took about 10…

Read more…
1 Reply · Reply by Ken Jenkins Aug 11, 2015

To access Syncsort Knowledge Base, visit:

My Support