DSXchange

Hi All,
Im getting a field which contains count of records from Aggregator stage and I need to change that field datatype from Double to Decimal. Can any one help me out in this.

Thanks in advance.

Hi Ray,
I have tried tht also. If I change the table definition then Im getting the below warning when I try to view the table data -''Implicit conversion; from source type "int64" to result type "decimal[10,0]": Possible range limitation''.

Thanks for your responce Ray. I have tried importing in tht way, but still Im getting it as BigInt. For field of datatype
NUMBER(10) in oracle table, datastage is importing as BigInt. But if the field is of NUMBER(11) the datastage is importing as Decimal(11).

Hi all, I have a problem in importing oracle table definiton. In oracle table one field is of datatype NUMBER(10), but when I import that into Datastage it is taking as BigInt. Beacuse of this data stage is taking wrong data. For example Im having value '-2525814614' in oracle table for this field b...

Thank you Chulett...

Hi,

In one of the job in my project, External Source stage has been used with following properties
Source Method=Specific Program(s)
Source Program = paste lib/file1.txt lib/file2.txt.
The output of this stage has been used in further processing.

Can any one tell me what PASTE does here.

Number of Nodes interms Number of CPUS in the current system so if you increasing the Number of nodes means increasing the Number of CPUs on the serevr. Isn't It?

You can also remove '-' by using the TRIM Function as below.

MyStr = Trim("Telephone_Number", "-", "A")

I killed the job by using DS.TOOLS options.

Thank you for the responses. :D

The Following Post could solve my problem.
Thanks dspxlearn.

I am new to Unix so can you explain me what 'uv' means (Login to uv.???????)

Hi DSguru, I am not able to Compile the job. It is giving the message that Job is in Running state. I am not using any DB Connections in the job. My job just reading the data from Datasets and doing some calculations in transformer and writing into a sequential file. Pavanns,Can you tell me how to c...

I ran a sequnce from Director. It got aborted due to the Errors in one of the job in Sequence. But the other jobs in sequnce are still running. I sent STOP request for those jobs from Director so many times. Even i sent stop requests i am not able to stop those jobs. These jobs are runing from last ...

I have been solved this problem by using the Excel logic and datastage job. I used the datastage job to bring the data into Uni format and written it into XLS file. In excel i written a formula to compare the strings and sorted out the problem. Thank you for all your valuable suggessions and support...

I have been solved this problem by using the Excel logic and datastage job. I used the datastage job to bring the data into Uni format and written it into XLS file. In excel i written a formula to compare the strings and sorted out the problem. Thank you for all your valuable suggessions and support...

I want to extract the STATE name from this column.but i dont know the lenght of the state data. It may variey from record to record. I want to extract the data before POST CODE...(State will be followed by POST CODE) We can identify POSTCODE by numbers in it. So my logic is, i want to extract the da...