DSXchange

even i didnt' use quotes ...it still doesn't work.....i wonder how can i set it in sequential file which make output data are "fixed length" thx for ur help Typically fixed width data files do not include quote characters; if you want these you will need to transform your data so that they have quot...

hi all i have a question following i am using Datastage 7.5.1A i want all the output data are to be set as fixed length for each field eg row 1 "ab" "123" "dddd" row 2 "abc" "12345" "aaaaaa" i want output like this row 1 "ab " "123 " "dddd " row 2 "abc" "12345" "aaaaaa" how can i set in sequential f...

it doesn't work same as my previous problmes (it only can be updated "NULL VALUE" when i put "COALESCE" but still not update "not null value" when i used "NullToEmpty".


It did work in Datastage XE verison but not wokring in Datastage EE verison (7.5.1.A)

thx Ray

i did try it but it still doesn't work.

i have the other solution, i put one more link from TRANSFORMER to db2
( one due with not null value and other do null value) but i feel so strange N my group dont' accept this solution.
i hope u can give more advise

thx in advance

i have one problem when i try to update null value in "SERVER JOB" in "Datastage 7.5.1.A" UPDATE SOR_DATA_SVC SET JOB_INST_ID=?,LAST_UDT_TMS=?,DSC=? WHERE DATA_SVC_TP=? AND DATA_SVC_CODE=? AND COALESCE(DATA_SVC_SUB_CODE,'')=COALESCE(?,''); Null value can be updated after i put that update command bu...