I've got no problem when writing to a sequential file.
I've got the same padding when using VARCHAR in Oracle instead of VARCHAR2.
I will open a case at Ascential support, and i will post the solution.
thank you for your help.
Search found 5 matches
- Wed Aug 02, 2006 10:39 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: mysterious null characters added in varchar field
- Replies: 12
- Views: 2566
- Wed Aug 02, 2006 10:00 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: mysterious null characters added in varchar field
- Replies: 12
- Views: 2566
- Wed Aug 02, 2006 9:30 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: mysterious null characters added in varchar field
- Replies: 12
- Views: 2566
- Wed Aug 02, 2006 9:00 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: mysterious null characters added in varchar field
- Replies: 12
- Views: 2566
I did test this. Length of my input value is 5 the value is "92400" I did another test: Input value is "9" and output field is POSTAL_CD in ORACLE declared VARCHAR2(5) Case 1: Mapping POSTAL_CD in the transformer is varchar and length 1 Value of field POSTAL_CD in ORACLE after the update is "9 " I l...
- Wed Aug 02, 2006 7:56 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: mysterious null characters added in varchar field
- Replies: 12
- Views: 2566
mysterious null characters added in varchar field
hi, I've got a problem on an ORACLE ORAOCI9 stage: I'm in a update/insert configuration I want to update a varchar(5) field declared as VARCHAR2(5) in ORACLE my field is mapped in my DS job and my ORAOCI9 stage like a varchar with length 5 What happened? DS changed the length field from 5 to 7 and c...