Table Conversion Error

[Patrick]

TCEngine Level 0 \b9\common\TCEngine\tcdtacnv.c : TCE009021 - Size of delimited column TextLine is greater than 32769 and will not fit in the format buffer.

Never seen it before. 8.11 SP1

Using a CSV file to load a standard JDE table. Any ideas?

 

[DBohner-(db)]

Hey Patrick!

In P93081 the setting need to be:

*PUBLIC *ALL REPORTNAME VersionID IBM-37 EBCDIC-Latin 1 or Western Euro AV Active

After inserting the record - make sure you mark it as ACTIVE (Row Exit button).

(db)

 

[Patrick]

That's huge!!!!!! Thank you sir.

 

[DBohner-(db)]

Patrick,

I assume that worked for you? It worked at my client - iSeries.

BTW - Naveed provided me the same answer a few days ago, thus it was fresh on my bramaged.

(db)

 

[Patrick]

I think it fixed problem #1. Now the TC blows up with no error in the log at all. It runs longer than before though. Nothing in the error log. It's defined as a CSV and all fields are defined. Is there any formatting of the CSV that I need to do to get JDE to read it correctly? It's been a while since I have done TCs. Not really sure why. Any ideas?

 

[Patrick]

It is working now. I used your settings for IBM (foolishly). We are a windows shop and after setting it to the appropriate windows setting it worked like a champ. Thanks again!!!