reading ebcdic data

ArndW · Post by **ArndW** » Fri Jun 11, 2010 3:11 am

(2nd attempt, somehow my longer first post disappeared)

Use the CFF stage, it makes reading COBOL and EBCDIC files simple and performs the EBCDIC to ASCII conversion automagically.

Manfred Hagedorn · Post by **Manfred Hagedorn** » Fri Jun 11, 2010 3:13 am

Hello,
in parallel i tried with CFF stage,
i also used the cobol copy book definitions and got erros like:
Complex_Flat_File_14,0: Field "JNAFOC_DATCRE" has import error and no default value; data: {o c1 c3 c7}, at offset: 1

ArndW · Post by **ArndW** » Fri Jun 11, 2010 3:30 am

Stick with the CFF stage. What is the data type of JNAFOC_DATCRE and do you have NLS turned on?

Manfred Hagedorn · Post by **Manfred Hagedorn** » Fri Jun 11, 2010 3:37 am

Hello,
the column is decimal (Picture PIC9(7) Comp-3)
NLS=Project default (ISO-8859-1)

Manfred Hagedorn · Post by **Manfred Hagedorn** » Fri Jun 11, 2010 3:38 am

Hello,
the column is decimal (Picture PIC9(7) Comp-3)
NLS=Project default (ISO-8859-1)

Manfred Hagedorn · Post by **Manfred Hagedorn** » Mon Jun 14, 2010 10:26 am

Hello,
thank for your comments and feedback.
Meanwhile my problem is solved.
I don't really understand, but the data was shonw as unreadable characters in file-output
but data is well readable when using an oracle output and access the data from oracle.
Best regards
Manfred