Content LongVarBinary to Image

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Try explicitly setting Precision to 65535 for that column.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
UCDI
Premium Member
Premium Member
Posts: 383
Joined: Mon Mar 21, 2016 2:00 pm

Post by UCDI »

Its a system mismatch!
The second value is an unsigned 16 bit integer.
The first value is a signed 32 bit integer.
I am not sure what the implication of that is, but maybe it helps you to understand that the two systems are doing something incompatible --- old machines are notorious for defining words like "long" as anywhere from 16 to 64 or even 80 bits.
Post Reply