DSXchange

I want to use in the tranformer with the same logic.
How can i use that option in the parallel. i am trying with pad string and trim... still i am unable to find the solution....

Please give some solutions ... If any one know the idea please share with me.

Thank,
Suresh

hI
I WANT TO USE THE SAME FUNCTION IN THE PARALLEL,,,
fmt(trim(LINK1.TEST),"9'0'R")
That is not possible PARALLRL JOBS beacuse of fmt function is not thier.
Can you please tell me how can we use the same login in the parallel jobs.

Thanks and Regards,
Suresh

Please see the below.
I also have same requirement.
How can i use the fmt function in the parallel jobs.
Please give me some suggestions.

Hi ray Here is the list of values. I created environment variable in the administrator: Parameter name: TEST_PATH Type: String Value:"\\10.111.111.23\RAJ\Source TGT -230907_FILE.txt" i used the environment varable in the job. PARAMETER NAME: $TEST_PATH PROMPT:ENTER THE PARAMETER TYPE:STRIN...

i tried all the possibilites
not working still getting the same error.

Can any one help me please

1. i tried with out environment variable. i gave a local parameter with in the job and also parameter value. but when we run from the commend prompt i changed the parameter value. that is working fine. i tried same systax in the using enviroment variables. i have permsision to the directory and also...

i gave $TEST_PATH
Sorry i did not mension that one.

FYI.... I AM USING THE COMMEND DSJOB.EXE i am using in my job --environment variables. i am passing parameters from the commend prompt. please see below. environment variaable:$PATH. some times i need to change the parameter value. C:\Program Files\Ascential\DataStage7.5>dsjob.exe -server SERVERNAME...

I AM USING THE COMMEND DSJOB.EXE i am using in my job --environment variables. i am passing parameters from the commend prompt. please see below. environment variaable:$PATH. some times i need to change the parameter value. C:\Program Files\Ascential\DataStage7.5>dsjob.exe -server SERVERNAME -user R...

HI all, we have 100 jobs in my project. source/ Target --> oracle. only 30 jobs are we are using source view (DS Quary) in the source oracle stage. We created one view in the oracle. we splitted in to two views for simplicity. we are using the second view in the DS Quary. with in the quary we are jo...

What is the difference between the HAWK (DS Version and IBM Information server.

can you please help me on this
Thanks

we already created 300+ jobs in the server. Our data base is oracle, we need to migrate all the server jobs into parallel. i need to these things. 1. we need to install any things in the parallel. 2.any thing i need to configure the parallel. 3. i know thier is a lot of design change in the parallel...

hi
Is thier any possible with DSX. can i change any version number.. 50.0.0 to 50.0.1

Please give some sueestions.
Thanks

john bbb colian
sam donald


only thing is we need to read the data. we already validating the data.

sam is first name
donald is last name


where ever we have the middle name...we need to dispay the name