DSXchange

Thats what your doing wrong. CurrentDate() and CurrentTime() will return date and time and not a string. Try something like

Use DIGITS() to extract all numbers from alpha-numeric data and LETTERS() or ALPHA() one of those I believe (cant remember exactly) for alphabets.

What exactly is not working

As I suspected, it wont accept T in timestamp. Treat it as varchar.

Read about UtilityHashLookup() in DS help. Its a function to read a hashed file.

Now you have two ways. The hashed file read, when I said multiple reads, I was pointing towards reading it in the initial value of a stage variable by using UtlityHashLookup(). This way you will read it once in every transformer stage.

Its not unnecessary. You need the value right? This is one of the most efficient ways. Load it once and read it multiple times.

Ofcourse you can. Load the date with a dummy static key say 'X'. Lookup the value by providing the same key.

Yes, @INROWNUM is the record's number on link2. Its twin, @OUTROWNUM in trans2 would mean the record number on link3.

I just re-read the post. You really are on server edition arent you. I missed that part although it was right in my face.
Go ahead and post some sample data, it might help us come up with a solution.

You will have to treat it as a varchar else it will not accept it as a timestamp, as far as i know.

Well it gets shipped with 7.5.2 for windows, so you should already have it installed. Do a cat of any file on your windows command line, does it work? Well thats the way I can think off in which you can sort by stores, do uniq to remove duplicates and then read it one by one, while grepping for the ...

Do you have MKS Toolkit installed? It should be as your running px on windows. If you can confirm that then you can do this with a shell script.

I dont know whats going on during the first option of creating the table but with the table replace, do you get the warning everytime or only the first time when the table is not present? If yes, then its just a warning message to tell you that the table does not exist and you can use a message hand...

More specifically, Craig's last reply in this post.