DSXchange

I transcode a complex file to a sequential file without any change in column type.But I fail to load data from sequential file to SQL server by bcp tool because there is a point "." at the end of decimal column(with decimalplace 0) such as decimal(8,0). If I change the column type from dec...

Can I use DB2 function to transform a column in Transformer stage?

I need to read one complex file and load the data into DB2. THE COPYBOOK is like as follow: 1:RCZSCB3A:-REC. 05 :RCZSCB3A:-NAME X(10). And The Table: A( NAME CHAR(10) ) Some Chinese characters may be in the column , so I set the property "extended" : "unicode" "nls map"...

add a column before with value "1" , then sum

1st,I use PxCFF stage to read an EBCDIC file "F" and load data to table "T", then i read the same file again and use difference stage to compare the data from "T" and "F". ( only compare on column with Chinese characters.) I find that result is "all diffe...

When I use "load" mode to insert some data (DB2 ENTERPRISE STAGE), the value NULL (column type is smallint )is inserted as 0.
WHEN USING "write", null is inserted.
Why are they different?Or is there any option to set?

but can anyone explain why the envrionment variable "apt_decimal_interm_round_mode" does't work.
I just select one record 0.7499 (decimal(13,4)) and put it in an decimal(13,2) column,the results are both 0.75 whether set the variable as "to nearest" or "discard rounding"

but no matter set the property ， it also does round off

In the administration environment properties, I set "APT_DECIMAL_INTERM_ROUND_MOD" as discard and unpresentable fractional digits.
but seems nothing changed

When the type of input column (or the source column )is decimal(13,4) but the output is decimal(13,2) ,the value will be rounded off . In DB2 enterprse stage,I can use 'cast' function to prevent rounding off,but how can i do in such as aggregate stage. Is there any setting option to avoid rounding o...

but why null value or default value can be '01/01/1900'

I'm so sorry ,i think i described a wrong stuation .the fact is the two parts of result data has shared data.
and the upsert only do one action for one record and i aslo donnot know how to divide them in DE stage

thanks, I thought the input data can be used totally twice in insert and update.

I user upsert mode user_defined update & insert the insert statement is INSERT INTO CC_CDW.M_CLT_REL (CLT_NBR, ALT_CLT_NBR, STR_DTE, END_DTE) VALUES (ORCHESTRATE.CLT_NBR, ORCHESTRATE.ALT_CLT_NBR, ORCHESTRATE.STR_DTE, ORCHESTRATE.END_DTE) the update statement is UPDATE CC_CDW.M_CLT_REL SET END_DT...

when I do update and insert in one DB2 enterprise stage ,the error message is field `I_DTE' is not an Orchestrate insert field. my update and insert statement is as follow: UPDATE CC_CDW.F_CLT_ADR SET END_DTE = DATE('#I_DATE#')-1 DAY WHERE (CLT_ID = ORCHESTRATE.CLT_ID AND CTT_TYP_COD = ORCHESTRATE.C...