DSXchange

Hi all, In my one of job I have 3 stages ODBC stage, transformer stage then sequential_file stage DSLink3 joins ODBC stage to transformer stage and DSLink4 joins transformer to sequential_file stage. Is that possible I can use 4th stage to count records which is going into seqential_file stage from ...

Hi, I am trying to rename the ppff1206.txt to ppff1206.txt.bak and I wrote following code. Call DSExecute ("NT", mv "/ss/ppff":FileNameSuffix:".txt" to "/dd/ppff":FileNameSuffix:".txt.bak" ) when I compile it it gives following error Compiling: Sourc...

but how I can pass the parameters when I have "source" in syntax tab in
procedure type

Hi

I am trying to create a job to run the oracle procedure from datastage.

Oracle procedure have two parameters ymd, p_return_code.
ymd is date like 20061115 and p_return_code is null.
I have datastage version 7.5

Please help me to accomplish this. I am new in store call procedure.

Hi,

I have one character column name xyz in which I have some characters with quotes. I need to get rid or the quotes.
Please help me out.
example
xyz
UBIT "O"

3144 N "G"

XUDM "XU"

I want the result like that
UBIT O

3144 N G

XUDM XU