Search found 34 matches
- Fri May 04, 2007 3:05 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Columnvalue in unix file truncated and rejected
- Replies: 5
- Views: 1793
adjusting the columnproperties because of Varchar2 100 char
i have discovered the problem the length of the columns in the oracle stage have to be set to 400 length if they are marked varchar2 (100 char) in the database itself. this is because it can have special characters which indeed take more space. I guess the new columns were added by hand and been giv...
- Fri May 04, 2007 2:40 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Columnvalue in unix file truncated and rejected
- Replies: 5
- Views: 1793
Rejected row when the third euro signs comes in
thanks for the responses but the locale property doesn't solve the problem and both stages can't have the same NLS setting because oracle needs UTF8 for certain caracters and the sourcefile has to be ISO8859-1. when debugging i got the following result: the string is 99 characters long when it has 2...
- Fri May 04, 2007 1:23 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Columnvalue in unix file truncated and rejected
- Replies: 5
- Views: 1793
Columnvalue in unix file truncated and rejected
Hello, Can someone help me with the following problem: I have a unix sequential file (NLS ISO8859-1). The euro sign in the file is shown as a question mark when i view data in datastage (because of the NLS setting). The length of the column is 100 positions and is written to an oracle table (NLS UTF...
- Mon Apr 16, 2007 10:44 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unable to run parallel jobs
- Replies: 8
- Views: 6017