XML transaction size

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
betterthanever
Participant
Posts: 152
Joined: Tue Jan 13, 2009 8:59 am

XML transaction size

Post by betterthanever »

hello all,
I am trying to find out what dictates the size of a XML transaction(one record) within datastage. i know we define the columns as LongNVarchar, would like to find out up to what size it can accommodate. I appreciate your inputs.
eostic
Premium Member
Premium Member
Posts: 3838
Joined: Mon Oct 17, 2005 9:34 am

Post by eostic »

It depends on the Job, the Job-Type, the Stage Type, the context (how your are reading it, where are you reading it from, etc.).....there is no particular hard limit.

Tell us what you are trying to do with the xml and we can review what you need to be concerned with.

Ernie
Ernie Ostic

blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
Post Reply