DSXchange

Do you find any reason for the "UPSERT" option, not to work in your case? Note: Post your questions in appropriate forum. ooh,that may be a good solution ,i never use upsert. you mean that I can divide result data by checking the input data in "where" statement of "user_def...

How to avoid locking table when update and insert into one table at the same time . The result data should be divided into two parts(two parts have no shared data) : insert one part into table,and update the other into the same table. i used transformer stage to get the result data and divide them i...

How to avoid locking talbe when update and insert into one table at the same time . The result data should be divided into two parts(two parts have no shared data) : insert one part into table,and update the other into the same table. i used transformer stage to get the result data and divide them i...

I find the same warning with DB2/UDB enterprise stage in some jobs. warning information is "Invalid character(s) ([xF7]) found converting string (code point(s): ) from codepage GB2312 to Unicode, substituting." AND "ExecuteImmediate issued Warning for:?" even when no result data ...

failed in using CFF stage to read a EBCDIC file .
the reason is that the file is with the column name is the data file,how the handle this situation?

using CFF stage to read an EBCDIC file , I want to set default value for one column. But The message box show up (usage for decimal must be comp-3) i wanna know why? if I set usage to comp-3 the result data would be incorrect(reading less bytes for the column) ps. another problem: If usage has been ...

the copy book is as follow: 01 :RAAKYCUP:-REC. 05 :RAAKYCUP:-KEY. 10 :RAAKYCUP:-ID. 15 :RAAKYCUP:-ID-FORMAT PIC X(02). 15 :RAAKYCUP:-ID-NO PIC X(04). 05 :RAAKYCUP:-CUSTOMER-ACCT PIC S9(16) COMP-3. 05 :RAAKYCUP:-CUSTOMER-NAME PIC X(1). .................................................... part of data...

the first column is decimal. I must set the 'usage' property to 'comp-3',or I can't set nullable or default value to the column.why? set in 3 places for this column: usage :comp-3 nullable: yes default value:0 then I found the first column occupied wrong length ,so ....result data as i described bef...

using "complex flat file" STAGE to read an EBCD file I'm forced to change the usage to 'comp-3' when I set default value for a 'decimal' column.After that I find the data still not right . the data should be as follow: DECIMAL CHAR(8) CHAR(10) 0000 20100812 OK 0000 20100707 OK 0000 2010070...

when I use system variable @date in expression Oconv( @DATE ,"DDZ")=13 THE condition can be satisfied. today is 2010-07-13 but when I use sequence job parameter I_DATE Oconv( I_DATE ,"DDZ")=13 here the value of I_DATE is 2010-07-13 but the condition can not be satisfied. Is there...

can we use basic function（such as oconv or ivonv）to get the first day of next month，and use it as a job parameter。

I got it
(Oconv(@DATE,"DD")) ='4'
thanks all

how to check the whether the day is #4 . which param in (Oconv(@DATE,"????")) can return the day of month.
as (Oconv(@DATE,"DWA")) return the day of week

use a nested condition stage?

when transforming stored procedure to datastage,I'm confused with codes like: "IF day(I_Date) <> 4 THEN return 0;END IF;" so I wannar check whether it's a right day to run the job. IF NOT ,the job should be returned immediately. Although the scheduler in director can point the exact day,I ...