Importing data from JDE char 3 via datalink into Oracle; "0xC14040... display in rows

[hazeky]

Hi,

I am importing data from JDE char 3 field via datalink into an Oracle table. The field returns "0xC14040.. .". Does anyone know anything about this error, or how to view JDE char fields in Oracle?

Thanks

[Rabbit]

I don't use oracle but it would help if you posted the full error message.

[hazeky]

Hi

I do not have an "Error". I am expecting a letter in the column, but Instead I have "0xC14040.. ." and it is wrong. Each row in the column has the same value "0xC14040.. ."

[Rabbit]

What is the code you're using to do the import? 0x is usually the prefix for hexadecimal and it looks like something is converting the string to hexadecimal before inserting.

[hazeky]

I noticed all the number fields are correct, but the numeric fields are full of junk. I tried to cast the fields, but to no avail. I believe the problem starts before the import. I cannot even view the correct data.

SELECT *, cast(Field1 as char(6)), cast(Field1 as varchar2(10)) FROM myTable@JDeLink

SELECT * FROM myTable@JDeLink

Field1 “0xD4E4D5F0F1F0 F3F840404040404 0404040404040.. .”
Field2 “0x40...”
Field3 “0x404040. ..”
Field4 “0xC14040. ..”

Thanks

[Rabbit]

I've never used JDE before but hopefully someone who has will stumble upon this thread.

I don't understand what you mean by this:

I noticed all the number fields are correct, but the numeric fields are full of junk.

It seems like a contradictory statement.