DSXchange

How can we do?


thanks
sr

actually i am dividing numeric column/10

source numeric column(length 7)/10 and target numeric column of length 6,2

When i am writing a numeric field the data is preceded with blank and the actual value

eg:actual value1000.00 and data showing in the file as ' 1000.00'. there is a blank infront of 1 and im not able to trim this.

how to handle this?

Thanks
sri

Comparing a wild character in the source data with the lookup. All the time the lookup is failing and when i am trying to insert into the oracle db it is rejecting the record.

How to handle the wild characters in the datastage lookup stage .



Thanks
sri

Hi,

I am loading from db2 db to oracle db and i am getting this warning and
from input dataset '0' is NULL. Record dropped.

Y it is doing?

how to read the job log and to capture the statistics

like datastage job name,start time,end time ,project, duration,sucess etc

How to call stored procedure from oracle stage before sql.
Syntax will be helpful

Thanks

Hi I had source as Col1 start_dt end_dt X 01-01-05 05-02-09 Lookup Col1 start_dt end_dt X 01-02-06 03-03-06 X 05-10-06 10-30-06 I want output as X 01-01-05 01-02-06 X 03-04-06 05-09-06 X 10-31-06 05-02-09 Basically the source had to fill the dates comparing the lookup Thanks srinivas.parsi

[quote="DSguru2B"]TNS entries are only for Oracle and not for [b]all[/b] databases. Do you mean the odbc connection info?[/quote]

Yes to connect datastage server to any database it needs odbc entry right. where is the location of that file on the datastage server

Hi everybody,

I want to know the location where the TNS entry for the all databases are stored in the Datastage server.

[quote="ray.wurlod"]Why involve DataStage if it's Oracle to Oracle? It would be faster to do it within Oracle.[/quote] I am developing a datastage job where i had source table 1 column is defined as Long and i had to populate that column in another oracle database env. This job should run ...

How should i insert Long datatype into oracle long datatype field .

I am getting error. there is no Long datatype in Datastage env

thanks

What is that error mean?

I got this error when i ran this job

Phantom 11204
Program "DSD.StageRun": Line 544, Attempted WRITE with NULL record ID

[quote="ray.wurlod"]Since you have not asked a question I will assume that you have a solution to the situation you describe. Can I therefore ask you to post that solution? If you don't have a solution, can you post a question?[/quote] I dont have the solution can anybody help me to implem...

Hi , I had peculiar problem i had a date source Source COl1 COl2 Jan 22 2006 Jan 23 2007 Lookup Start Dt End_dt Jan 20 2005 1 Feb 2006 2 Feb 2006 1 March 2006 Source start_dt should increment 1 day till it falls outside of stat_dt and End_dt of lookup Start dt End_dt 1 March 2006 to Jan 23 2007 Clea...