DSXchange

Hi all,
My target column datatype is changed to varchar 19.
Mysource column data is::: 3.78875632
My output should be ::: 00000000003.78875632

How Can i achieve the solution fo the above one?

Hi,

I have a dataset in Production environment i tried FTP to Dev environment and tried to open Dataset thru Dataset Stage it gives an error as " INPUT FILE DOESN'T EXISTS".
I am able to view the Dataset in the Unix box.

Thanks in Advance.

Thanks Ray and Arnd.

Now i understand the solution.

But my testing team considered that space as a bug. They want to remove that space.

What should i do now?

I used the trim function , But the space was not removed
Mysource column data is:::3.78875632
It is showing as " 00000000003.78875632"

Can anybody solve this one.

Your help is greatly apperciated

it remains in finished status the reamining jobs which i havent run them manually remained in compiled status

Thanks

It's again showing the same space .

Can anyone give some suggestions to this one.?

i have run the sequence from the script again the sequence shows in finished status and individual jobs in compiled status but when i looked at the log it says clearing file RT_STATUS178. Am i missing something?

Thanks

when i ran a single job individually its showing finished status its only when i run through script it showed Compiled status. Is there any reason.

Thankyou for your help

No these are not Mulitple instance jobs and the datastage director is connected to the same project where we executed the jobs. Our sequence finished successfully and it is showing the direcotr status as sucessful its only individual jobs which the sequence is executing that are showing the compiled...

Hi all, Iam having a source as txt file with some columns. And Target is also txt file with transformer in between In that, iam having one column called price with data 2495.07000000 as varchar(15). I have convert it into decimal 19 with scale 8. I used stringtodecimal function .When i ran the job ,...

Hello I have a small clarification to make. I have actually deployed a new catageory of jobs from one environment to another environment and i did run multiple compile of jobs from datastage manager by selecting the jobs under that specific catageory. I did force compile all the jobs. After running ...

Thanks Ray,

Could me please tell me how to write If..Then..Else expression for this problem.

Hi all, I need some help regarding the conversion. Iam having source as .txt file with 15 columns. And my target is also is .txt file with the 15 columns from source.And the transformer in between. For one column SUPPDATE varchar(10) in the source data is not there .But in the target it should be Da...

Hi all, Iam requirement regarding SetNULL function. Actually , my source file is .txt file with 5 columns. And my target consists of 10 columns is also .txt file. And there is a transformer is there in between source and target. All the source columns should map to target . And the remaining 5 colum...

Thanks OddJob If you have a routine called... CallMe(Arg1) You can call this from anther routine by using: CALL DSU.CallMe(Ans,Arg1) Ans is the return from CallMe. You need to add DSU. to the routine name to fully qualify it. It's not possible to use Ans=CALL DSU.CallMe(Arg1). Using CALL to call a f...