Page 1 of 1
Posted: Mon Oct 13, 2014 3:24 pm
by ray.wurlod
How is the file encoded, and what NLS map are you using in the DataStage job? The two need to be compatible, if not identical.
Posted: Mon Oct 13, 2014 4:03 pm
by joycerecacho
The NLS map is the project default: ISO-8859-1
And about your first question "How is the file encoded?", what do you mean?
I didnt get it.
Best regards,
Posted: Mon Oct 13, 2014 4:06 pm
by joycerecacho
I derivated the text field like:
NOM_DEV (Char 70 | Unicode | NotNull)
If Isnull(Lnk_Ler_Contratos.NOM_DEV) Then
Str(' ',70)
Else
Left(Lnk_Ler_Contratos.NOM_DEV:Str(' ',70),70)
Posted: Mon Oct 13, 2014 4:15 pm
by ray.wurlod
Because the file contains accented characters, it cannot be plain ASCII, it must be encoded somehow. Perhaps it is encoded using ISO-8859-1, perhaps using a different encoding. You also need to ascertain what the mapping used in the DB2 table is, for the same reason.