Code: Select all
Extract_date CHAR 8
ID CHAR 11
NAME NVarChar 30
Date format String = %yyyy%mm%dd
input record like: 20131121+0000448416CHARLOTTESVILLE<spaces to rec end>
Error Says:
Unhandled conversion error on field Extract_Date from string[8] to dest. type DATE. Source value "0131121+"
Looks as if the reader starts at position 2 of the record. Please help
=======================
Problem solved - The input file was created with a format other than ISO8859-1. When recreated transferred (as binary) to datastage with source parm set to "EBCDIC input (IBM500)" and target set to ISO8859-1 the alignment worked fine. Thanks