Search found 17 matches

by radarada
Sun Nov 02, 2008 4:43 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: decimal import error from text file
Replies: 10
Views: 5820

Using the UNIX newline delimiter i get this error.

Delimiter for field "VALUE" not found; input: {- 6 5 8 9 9 8 . 0 0 0 0 0d}
by radarada
Sun Nov 02, 2008 11:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: decimal import error from text file
Replies: 10
Views: 5820

decimal import error from text file

Field "VALUE" has import error and no default value; data: {- 6 5 8 9 9 8 . 0 0 0 0 0d} I have a text file that ends with a decimal and no delimeter for some reason I get the above error when importing this file. I have the datatype set to 38,10 in DS. For some reason it is seeing an 0d at...