DSXchange

Like this post for instance.

Keep in mind that this is true only for Date columns. For timestamps, the output should be in external format(if thats a word).

I have never used that stage so I dont know how reliable it is. But if it keeps popping up with error, Id kill it

What are you trying to do. You can do match col3 as well using stage variables. But that would be a sub-condition to the hashed file lookup. In other words, if Col1 matches only then you can check for Col3.

I told you Andy had an excellent find

You need to specify the reject link from the same transformer which feeds the DB2 stage.
The constraint of the reject link will be

where DBLINK is the link name going to your DB2 stage.

Does Hashed file lookup works only for key with which it was created? Yes. It will only work with the same keys and in the same position as it was created with. In other words, the meta data of the reading hashed file stage should be identical to the meta data of hashed file stage which created the...

Giving the fully qualified path should help

It seems like the open connection was denied for some odd reason or it was unable to open the connection. Its hard to trim the problem down if its not reproducable. Ditch the stage, do it from command line, get the file and read it with a sequential file stage.

jshurak wrote:Program "JOB.1747346384.DT.1427749107": Line 47, Unable to open the operating system file "RT_BP683.O/DSU.IntMTHYR2LastDayofMonth".

Craig read it between the lines with his lazer sharp vision

You need to clear out the segments of memory by using the REMOVE.SHM command. Refer here for more details.

You can look into ETLStats and see how Kim did it. You can probably tailor your own by using it as a guide line.

Let me rephrase myself, "......with little room for tuneups"

Try sending to varchar(). Set the scale appropriately.

Ray has explained it all.