DSXchange

It DOES work.

Show me exactly what you did, and explain what you mean by "din't worked".

What is the data type of the "date" column? What is the source of data (for example text file, database table)? Set up the year to be selected as a job parameter. for example jpYear. Extract the year from the date (use substring technique if the "date" column is a string, or the ...

I don't recall that IN is supported in the Filter stage.

Rather you need multiple WHERE conditions each directing to the same output link number. Output links are numbered from 0.

If they can they will. Don't push.

If it's urgent, involve your official support provider and sign up for premium level support; learn just how expensive "urgent" can be. DSXchange is an all-volunteer site whose members spend most of their time earning a living.

Do you need to be able to reverse the mapping to a masked value?

In either case, creating a routine is probably the easiest way to go. The routine needs to generate the same (?) unique replacement for each SSN.

There should already be an "F" pointer in the VOC for each log hashed file.

You're getting into Routine territory now. You need to scan the existing list to determine whether the value already exists (use the Locate statement) and insert it if not. Maintain the list as a field mark (@FM) delimited dynamic array sorted. Implement the following logic in your routine. Locate N...

Good to know - should someone initiate a documentation enhancement request?

The only possible answers are (a) "it depends" on the characteristics of the data and (b) if you have this knowledge a priori then you probably should be using a many-to-one match rather than one-to-one.

Your original requirement was not totally clear on this. Use stage variables to remember the value from the previous row and to detect group change (Dno = 0 and Cno = 0). This of course requires sorted data.

The Tunables tab of project properties in the Administrator client sets defaults for the project.

Within the job use Inter-Process Communication stage, where the buffer sizes are set as stage properties.

I've always used a tool such as XMLSpy.

You should be able to right click on CopyOfUSPREP and rename it.

Make sure you are not trying to rename USPREP.

You should be able to right click on CopyOfUSPREP and rename it.

Make sure you are not trying to rename USPREP.

If you can't rename the folder, try renaming the SET file.