DSXchange

1. DataStage will automatically create the hashed file, or you can specify that it does so by checking the "Create file" check box in the hashed file stage that populates it. 2. The Hashed File stage is on the upstream end of a reference link that is input to a Transformer stage. The Transformer sta...

Search the forum for vertical pivot - there are at least three ways to solve this in server jobs, depending on whether the number of rows per key is small or large, fixed or arbitrary. You example suggests small and arbitrary, but who knows if you've supplied the correct data?

But that wasn't the question.

To be absolutely sure that the hashed file is cleared use a before-stage or before-job subroutine ExecTCL to clear the hashed file. The command is CLEAR.FILE hashedfilename (which requires a VOC entry for hashedfilename).

You DON'T NEED a stored procedure!!! Just use a DELETE command as the user-defined SQL.

Not really, what was unclear? I note that you don't have premium membership so can't read the entire post. So even if I posted a more complete answer, you'd still only be able to see the first 200 or so characters of it. Read the help or the manuals about each of the stages I've referred to, and sta...

Why not just create a job to delete the rows? Use user-defined SQL, supply the date (as a job parameter) and refer to this in the WHERE clause of your DELETE statement.

Can't you just change your rule to "Replace existing rows"?

But maybe shrey3a's didn't.

Do you happen to have a URL for session registration?

In your case

May I suggest that regedt32 has better key-search capability? It also has the same dangers.

All data is VarChar if need be.
You can use IsValid()

... or that the file system where the project directory is installed is full.

Search the forum for a function called OpenSequentialFile - this takes care of all the possibilities.

Either push back on the requirement (joins without common keys are impossible), or do cascaded pairwise joins if you have such join keys available.