DSXchange

How are you pulling the data? Is it already in timestamp format? Are you pulling directly from ORACLE? Analyze its select sql, does it have TO_CHAR() for the date. If yes then you are getting a string and StringToTimestamp() should work. I just tried to recreate your issue at my end, not successful....

Use NullToEmpty() with Ray's solution. It has less checks and hence, efficient.

I hardly doubt it as you cannot constraint any input inside the lookup stage. You will have to either seperate it in the transformer and then collect it later or go with the other method I advised.

You can have a reject link coming out of the Lookup Stage that will carry records which will fail the lookup. Send both the inputs (lookup successful and lookup failure which is the reject link) to a funnel stage. The output of funnel stage can go to your final dataset.

Because your doing a lookup against the database and that column is defined as key. Input is ':1' bind variable.

Welcome Aboard
The latter functions that you have mentioned are present only in a Basic Transformer. What is the length of your target stage? What is your target stage? If its not a flat file then try writing to a flat file. I have done this in the past with success.

You are right. SetNull() is not working in stage variables. I just re-created the issue at my end. Do this then. Specify the stage variable as If (INDEX(DSLink2.Col1, "L", 1) > 0) THEN Field(DSLink2.Col1," ", Count(DSLink2.Col1[1,INDEX(DSLink2.Col1,&qu...

How about you go through the manuals and come up with a nice document and post it here for us

narasimha, add www in your sited post, otherwise it takes you to the login page.

I did'nt bother seeing who was the owner.
Thats why they say, never hijack a post. Sorry about that

A piece of advice, if all that your doing is renaming files then you dont need to wrap it in a script. The command can be directly pasted in the after-job subroutine 'ExecSH' as you have already experienced. This way there will be one less extra piece to worry about.

Great, you can mark the post as "Resolved" then.

Post them here. The order basically depends upon if you require a stage variable in another stage variable. If yes, then the variable that is required in other stage variables has to be first.

It will.

Version 8.0 has an SFTP Enterprise stage.
As for now, you can wrap your sftp in a script and call that from DataStage.