Casting in Oracle Enterprise

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
kld05
Charter Member
Charter Member
Posts: 36
Joined: Fri Apr 28, 2006 8:12 am

Casting in Oracle Enterprise

Post by kld05 »

Is it possible to cast directly in the sql of an oracle enterprise stage? I keep getting the error "the modify operator has a binding for the non-existent output field" The field I'm trying to cast is an Oracle function with metadata of varchar2(4000) but the function only returns two characters.

What is the best way to handle this?
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”