Varchar datatype length issues

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
nehavin
Participant
Posts: 2
Joined: Mon Jul 02, 2012 7:00 am

Varchar datatype length issues

Post by nehavin »

Is it mandatory to specify length in case of varchar datatypes. Actually the jobs throw a lot of warnings in case we map fields of different lengths etc.
Would it not be simpler to leave the length blank ? Any downside to it?
Neha Sharma
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Seem to recall some very specific downsides to this, perhaps an exact search for "unbounded" would be in order? Filter out all of the XML specific results, however and you'll find ones like this and this just to cherry-pick a couple of examples. Others would have to chime in if this has changed in current versions.

Oh, and as an aside, it seems to me if you are getting "a lot of warnings" then you're not doing it right. :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply