Search found 34 matches

by rverharen
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...
by rverharen
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...
by rverharen
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...
by rverharen
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

Is it almost finished downloading?
Giving access to the group datastage users on the server is done on the tab ' permissions' when you select the properties of the map ' c:\ascential\datastage'.
Greetings, Roy