DSXchange

Hi, We are geeting this warning Conversion error calling conversion routine decimal_from_string data may have been lost. We want to remove this wariing, need your help for the same. The code we are using is StringtoDecimal( SourceCoumn) < 1800 Please help me to remove this warnings Thanks in advance...

You are not getting that error only. It never appears in isolation. What other warnings or errors have been logged? Please post the exact messages (copy/paste - do not transcribe and especially do ... Hi Ray, Thanks for replying. I can not attach the screen shot but i am writing the line. By seeing...

Hi,

I am loading data by using oracle stage. While running the job i am getting this error only-

Could not check all operators because of previous error(s).

Can anyone help me out to resolve this.

Thanks in advance.

Thanks Ray and Maveric, But i have tried both the options, means put values in Length and scale, but not able to resolve the problem.

Is there any way to set the max length of a string postive.

then please let me know. i am using datastage parallel edition.

Thanks,
Raghu

Yes now its working

mc_harsha wrote:Hey,

Is it working using dataset as a look up?

If yes, please let us know.

Regards,
Harsha

Hi,

I am using a dataset file as a lookup file in datastage parallel edition. it reads the data but lookup is not successful. Lookup should be successful for 4 records as per the data values.
Kindly suggest me what could be the reasons.

Thanks in advance.

Project not found? :? I don't see the connection as you don't "path" the project when using dsjob. Post your syntax, please. ... Hi , We have tested the command for dsjob . the command is correct. Main problem is with the variable whose values are assing by some expression. If we use vari...

Hi,
we are calling datastage by using dsjob command from grid unix server. But we are getting this error.
Error- Failed to open project -
Status code 81016.

Thanks in advance

Raghuraj

Hi,

What is difference between Routines and Transforms.

Thanks,

Raghuraj

Hi All, We have a tab delimited file having more than 200 columns. some of the records are broken into 2 or 3 rows. we want to capture those bad rows or records. Either in Data stage or in Unix. We can not use any other delimiter in the file. Can any one suggest how we can implement this. Thanks in ...

Hi All, I am getting this warning message while running the datastage job. "DataStage Job 2611 Phantom 16948 Program "JOB.46533426.DT.1435533317.TRANS2": Line 906, Nonnumeric data when numeric required. Zero used. Program "JOB.46533426.DT.1435533317.TRANS2": Line 906, Nonnum...