Propogate

2002-06-24 Thread Ghosh, Shiladitya
Hi All, I am using MQSI2.1 and as some of you maybe aware that there is a PROPOGATE function which breaks a consolidated XML into separate messages.My problem is that we need to upload records close to 5000 from a SAP interface system to DB2.Now the problem with PROPOGATE is that if there are 50

Re: Retrieving a row of data from an external database?

2002-06-24 Thread Ghosh, Shiladitya
ase.table1 AS T > > This came back with the old can't put list into nonlist error. > > Were you using xml? > > Thanks for your help, > > Tina. > > > > > > > "Ghosh, Shiladitya" <[EMAIL PROTECTED]>@AKH-WIEN.AC.AT> on > 24/06/2002 13:

Re: Retrieving a row of data from an external database?

2002-06-24 Thread Ghosh, Shiladitya
Hi Tina, Tell you what..I faced the same problem and I got a workaround with it..what I did was take the result in an array and then assign a variable to the first element of the array in my loop.I am not aware about how effecient this is..but I'm still in the "If-it-wrks-it'll-do" phase in my M

Problem connecting with DB

2002-06-21 Thread Ghosh, Shiladitya
Hi all... We are facing a rather starnge problem.Right now we are at the developemnt level so we have both the CM and the Brk on the same NT machine.The problem is that whenever we have to restart the machine fer any reason the flows simply refuse to connect to the application DB

Dynamic XML tag generation

2002-06-13 Thread Ghosh, Shiladitya
Hi, A basic MQSI/XML question(i think!)..We are using MQSi 2.1 and in one of our compute nodes, we retrieve a value from the database using the ITEM keyword.Now we need to use this value to create a tag like so. SET ENVIRONMENT.TEMP = "SELECT ITEM EMP_ORD"; NOw if EMP_ORD returns A9

Re: Propogate function in MQSI 2.1???

2002-06-13 Thread Ghosh, Shiladitya
thanks a lot chris,amit.will get to it... > -Original Message- > From: Christopher Frank [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, June 12, 2002 9:58 PM > To: [EMAIL PROTECTED] > Subject: Re: Propogate function in MQSI 2.1??? > > Adi, > > >>>We were using MQSI 2.0.1 till some

Propogate function in MQSI 2.1???

2002-06-12 Thread Ghosh, Shiladitya
Hi, We were using MQSI 2.0.1 till some time back and we picked up data from the DB and generated a common single XML message for all the reccords and used the SQL4j parser API's to break these into individual XML's for each record through a triggered java program.However,I was told by a MQ guru

Trace node

2002-05-26 Thread Ghosh, Shiladitya
Hi, I am using MQSI 2.1 and in one of my flows there was some problem with the message 'cuz of which I had to insert a Trace node (a file trace) to check the message.This trace node i put in between a compute node and a Rote To label.Is there some constraint with the TRACE node before a route to

Re: Re-triggering a process

2002-05-19 Thread Ghosh, Shiladitya
Hi, Before I proceed I must mention that this problem is not a strictly MQ problem.It has got to do more with the WebSphere Application Server.We are using WAS 3.5.3 and DB2 as well as MQ and MQSI for data transferring.However, the problem that we are facing is that the WAS serv