To read the rejected record in error table created by TPUMP

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
s_porkalai
Participant
Posts: 38
Joined: Sun Mar 25, 2007 11:05 pm
Location: chennai

To read the rejected record in error table created by TPUMP

Post by s_porkalai »

hi All,
I need to read and use the rejected record in error table which is created by tpump stage. But the rejected record is stored as BLOG with data type of VARBYTE(63666). when i try to read the record from another job using teradata enterprise stage it is showing the following error.

"Host data " Parsing Parameters max=1870 for schema type RAW value must be positive got "-1870"

where host data is the name of the column of rejected record.
Note: I specify the data type of host data as LongVarBinary and i tried with VarBinary also

Thanks in Advance
thanks & Regards
A.S.Porkalai Lakshmi
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Looks like an incompatibility between using signed and unsigned integer. This is a bug. Report it via your support provider.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply