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
Not able to extract the Data from MQ
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 37
- Joined: Fri Oct 21, 2005 4:09 am
Not able to extract the Data from MQ
Thanks and Regards
Abha
Abha
Re: Not able to extract the Data from MQ
Hi! abhaabha.kalra wrote: i also checked that data is breaking after each 999 charater. my queue length is 8000
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
-
- Participant
- Posts: 37
- Joined: Fri Oct 21, 2005 4:09 am
Re: Not able to extract the Data from MQ
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
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 .
![Smile :)](./images/smilies/icon_smile.gif)
if u have any other solution then please let me know
Thanks and Regards
Abha
Abha