Message Queue Maximum Input length

harryhome · Post by **harryhome** » Tue May 15, 2007 1:35 am

Hi

I have a Message Queue from where I am taking input which is having characters more than 5 lakhs in a single line on queue.

But in datastage , in message queue stage , in metadata I can find only

LONGVARCHAR (125000) as result when there is single row on queue (say of length 5 lakhs character), I am getting 4 row as output from message queue stage.

Plz tell if I can increase this input columns length further.

clarcombe · Post by **clarcombe** » Wed May 16, 2007 2:51 am

Where are you getting your data from? Is there anyway to split it beforehand.

If you cannot read the message because of the size and you cannot increase it in the MQ stage, your best bet would be to read the queue and dump it to a file, then use DS to process it that way.

See my other post to you regarding triggers for this.