DSXchange

How I ll get the previous values?

Hi, I have a sequential file that has duplicate values on three key fields.I need to update it to a db2 stage.I have to keep non null values of the previous record of the sequential file if the other record has null values in the same fields. I tried to use oracle stage to use sparse lookup but I st...

Yes target column is timestamp(6) and timestamp format in DS is %yyyy-%mm-%dd %hh:%nn:%ss.6 i take data from DB2 both varchar and timestamp,When i use timestamp,it doesnt work but i use varchar it works but milisecond is missing. as i read Parallel Job Developers Guide page 13-7,DS doesnt support mi...

I mean db level and also i solved load problem using OCI bulk loader.Bu i havent solved micrasecond problem.I search forum but i couldnt find any solution.there are many solution recomended but they have no affect. My source is 30.03.2005 23:57:32.150000 but i load this data like 30.03.2005 23:57:32...

I solved this problem using OCI LOAD stage.But souce data is 30.03.2005 23:57:32.962000 but after load in target it seems 30.03.2005 23:57:32.000000.

How can i solve?

when i chose upsert medhod ,it works fine.But i must load medhod because of volume of data

if target column is varchar,it's not a problem.it works fine and when i look data,data format is ok.But i cant change target column from timestamp to varchar because Business objects' reports will be effected.

But how can i use to_date function for load option?
I use load medhod for oracle stage.There is no function like to_date in transformer stage or i havent seen yet.

I have oracle target stage and use load medhod.I want to fill timestamp column with current timestamp.In transformer stage ,i use CurrentTimestamp function but i take warnings like this and no load data. Oracle_Enterprise_50,1: APT_FileExportOperator unable to export record: Record larger than fixed...

I have oracle target and a column which has nullable Timestamp data type named A.Before target,i use transformer stage and set A column like above, If A>currenttimestamp() then SetNull() else A After jop finished,Some records exported rejects file.But export was unsuccessful .No data was written seq...

i use transformer stage before column import stage,and convert the data from stringtoraw using transformer function.Column import stage worked well.problem is solved.
and also second way ,field() function helps to be solved
thanks everbody answered

Hi, My job is like above Oracle source stage-->column import st--->seq. file. I have a column data type varchar2(4000).i store in it like that data "0001","john ","istanbul" and i want to separate this column like that id name city 0001 john istanbul for this,i use colu...

As i understant
You have transformer stage 2 output link.one of them is about reject file.
if you use Transformer Stage,data matched by your constraint goes rejects file and all data goes the other link output.You can use constraint for the other link output(opposite to rejects constraint)

sort data using col1 ,and set true Create Key Change Column property.DS adds one more column Keychange().Use transformer stage variables (IF Keychange()=1 THEN 1 ELSE variable+1 ),concanacate xx

but i cant use load medhod because of primary key loaded by triger