Not able to extract the Data from MQ

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
abha.kalra
Participant
Posts: 37
Joined: Fri Oct 21, 2005 4:09 am

Not able to extract the Data from MQ

Post by abha.kalra »

Hi,
i have problem with extracting data from MQ stage.
for eg i am putting 2 records to MQ but while extracting messages it is coming as 16. there is some spaces coming in between . But i m not able to find out the reason why this is happening and how should i solve this issue.

i also checked that data is breaking after each 999 charater. my queue length is 8000
Thanks and Regards
Abha
kalpna
Premium Member
Premium Member
Posts: 78
Joined: Thu Feb 02, 2006 3:56 am

Re: Not able to extract the Data from MQ

Post by kalpna »

abha.kalra wrote: i also checked that data is breaking after each 999 charater. my queue length is 8000
Hi! abha
what is the max mesaage length of ur queue..?
how did u place the message on to queue?
and what is your message type?

Kalpna
abha.kalra
Participant
Posts: 37
Joined: Fri Oct 21, 2005 4:09 am

Re: Not able to extract the Data from MQ

Post by abha.kalra »

hi Kalpana
details are
queue max length is 8000
and depth is 250000

and putting the data from a flat file transforming it to XML output satge and loading into MQ.
also i solve the problem bu checking the option "do not add spaces at the end of varchar column" while loading data to MQ . :)
if u have any other solution then please let me know
Thanks and Regards
Abha
Post Reply