DSXchange

in query by cast function ,convert it as varchar like this cast(Trim(ABBESTDOWNTIME) as varchar

and while inserting it into sql server again convert it as target table column data type

what is the data type used for this column in oracle source stage field "ABBESTDOWNTIME".

yes the logic you have mentioned will work.

bcoz you first finding the number of zeros to append and then concatenate the value

how to remove all spaces in a string

example: jhon is good

i need out put as jhonisgood

Hi,

I ahve a sql query with IN statement.when i use the hard coded values like('X','Y','Z') .it works.when i use parameter ,the job doesnot return result.Please help me

Hi,

Is the number of the input links to join stage is limited.What is the maximum we can have?

Where condition is not possible in Join stage.

Hi,

the problem is with path...

cd /opt/IBM/IIS/InfoSrv81/Server/DSEngine

from above path,go to bin directory and then execute the command

check whether job is in compiled state or not

Hi,

If a value in a column is not a numeric ,i need to convert it to Sting 'NULL' .How can we implement this is effective way.mysource is csv file.

Please advice

Thanks,After specify the scale the error has gone :D

Hi , Iam getting below compilation error. ##I TUTL 000031 05:34:20(001) <main_program> The open files limit is 4506; raising to 65536. ##I TOSH 000002 05:34:20(002) <main_program> orchgeneral: loaded ##I TOSH 000002 05:34:20(003) <main_program> orchsort: loaded ##I TOSH 000002 05:34:20(004) <main_pr...

hey,

how can we acheive the second one?

Thanks in Advance.............

Hi ,

Can i perform the Convert function in modify stage like transformer.For example--incoming source value of N/R to converted as ''

Hi,

In server we have Change function.Could any one let me know the same funcionality in parallel jobs

thanks in advance