Max Value of Length property for a LongVarChar Field Type

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
cosec
Premium Member
Premium Member
Posts: 230
Joined: Tue May 08, 2007 8:10 pm

Max Value of Length property for a LongVarChar Field Type

Post by cosec »

Hi All,

In our current process to handle MQ messages, in the MQ component the message is defined as LongVarChar and in the length field a value of 9999999 is specified. Is there any limitation on the value for this length field?

From what I checked it allows a max length of 999999999.

Please help confirm if this is true. Thanks,
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Server imposes no such limitation on string length, so if that is what MQ can handle then it should work. How about testing it - that shouldn't take more than half an hour to set up the queue and read/write the long string to/from it.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Are you really expecting messages larger than this?
:shock:
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