DSXchange

Thanks for your inputs. Let me try if we can do with ODBC connector for Excel and provide my result.

Source is the database. Target is a single excel sheet. Have several queries, in that my first query result should be in excel sheet first tab and my second query result should be in excel sheet second tab and so on. design looks likes as below : database -- 1st query Trans---> seq.file (csv) databa...

Thanks mobashshar for the information.

We have fixed this issue by changing the delimiter to pipe(|) from CDC. We have created a PMR with IBM and they provided a java program to change the delimiter to pipe while generating files from CDC. Now its working fine.

Thanks for all your help. !!

Ray,

The is generated from CDC when there is an update or insert in source DB2 table. By default the CDC will create files with comma(,) & double quotes(") as delimiter. Is there any way to change the delimiter in CDC?

Hi All, We have a scenario as below: Source file: "1","AAA","BBB","CCC" "2", "AA",A"," BBB","CCC" In the above records the 1st record wil be processed succesfully if we set " and , as delimiter in the sequentia...

Hi Jwiles,

Thanks a lot.. Now its working fine.

Hi Eric,

you are right..
Issue is solved..

I have a doubt in partitioning. In my job i'm using a sort -> remove duplicate->join. Here sort and RD is based on 3 keys (say key1, key2 and key 3) and join is based on 2 keys (key1 and key2).. so in this case should i need to re-partition(hash) in join stage based on these 2 keys? Thes two join ke...

Hi Ray,

I can demote it but the value populated in targer is not correct. It is converted to 0000000.00 (total 9 zeros) and also as pandeesh said the lenght is exactly 12 charactes.

My source is a fixed width file. In that i have a field with value as 000012345.00 in source. In the target it is decimal. so when i try to convert it to decimal with stringToDecimal function i'm getting the following warning and also in target the value is convrted as 000000.00, APT_CombinedOperato...

are you writing any records to a sequential file in your job?