Re: XML CDATA

2004-11-17 Thread Raul Acevedo
-- Insert the input message tree as CDATA embedded XML in the messageData element set OutputRoot.XML.RibMessages.ribMessage.messageData.(XML.CDataSection) = BlobToChar(BITSTREAM(InputRoot.XML.*[1])); Raul L. Acevedo Senior IT Architect EAI Application

Re: WBIMB SQLCODE

2004-08-03 Thread Raul Acevedo
I found that when doing a SELECT, the SQLCODE is always 0 even if there are no rows. INSERT and UPDATE does set the SQLCODE correctly. Raul L. Acevedo Senior IT Architect EAI Application Innovation Services IBM Global Services 818 230 5859 Office 818-599-6626 Mobile [EMAIL PROTECTED]

Re: WBIMB SQLCODE

2004-08-03 Thread Raul Acevedo
Please respond to MQSeries List To [EMAIL PROTECTED] cc Subject Re: WBIMB SQLCODE THANKS, If you do a select and the DB is not available will it return an ERROR?? bobbee From: Raul Acevedo [EMAIL PROTECTED] Reply-To: MQSeries List [EMAIL

Re: Workflow 3.4 Installation

2003-10-20 Thread Raul Acevedo
I recall getting the message and it was the PATH being full Raul L. Acevedo [EMAIL PROTECTED] Instructions for managing your mailing list subscription are provided in the Listserv General Users Guide available at http://www.lsoft.com Archive: http://vm.akh-wien.ac.at/MQSeries.archive

Re: Migrating from WMQI 2.1 to WBI Message Broker 5.0

2003-08-26 Thread Raul Acevedo
Yes we are doing it and it is a lot different It has a lot of nice features, you just need to get used to Eclipse Raul L. Acevedo Consulting IT Architect Application Innovation Services IBM Global Services 818-539-3203 Office (TL 396-3203) Glendale, CA 818-599-6626 Mobile [EMAIL PROTECTED]

Re: CASE statement problem....

2003-05-31 Thread Raul Acevedo
Here are some examples. set MailType = CASE InputBody.WfMessage.ActivityImplInvoke.ProgramID.ProgramName when 'WorkItemNotification' then 'is Ready for Your Approval' when 'RejectionNotice' then 'Has Been Disapproved' when 'ReWorkNotice ' then 'Requires Rework'

Re: Integrator V2.1 - How do you take off a specific number of leading bytes from a BLOB

2002-11-27 Thread Raul Acevedo
declare len INTEGER; declare firstByte INTEGER; -- blob comes in double bytes plus X' at the beginning and ' at the end. set firstByte = 88*2 + 3; set len = length(InputRoot.BLOB.BLOB) - firstByte; set OutputRoot.BLOB.BLOB = substring(InputRoot.BLOB.BLOB from firstByte for len); I haven't

Re: EDI transformations w/ MQSI

2002-11-12 Thread Raul Acevedo
Yes, I used MQSI to translate EDI to XML at a client. I do not have the code. It is possible and not difficult, just a lot of ESQL code. Quigley, Robert Robert.Quigley@PTo: [EMAIL PROTECTED] S.NET

Re: Workflow in Websphere

2002-10-31 Thread Raul Acevedo
What platform ? Make sure that the path is correct, and it is defined in the platform where you are running. I assume that you are not using the Web Client and the you are not trying to run a JSP. Correct ? Raul L. Acevedo IT Architect IBM Global Services Business Consulting Services, EAI -

Re: Do you have customer referece of MQ Shared Q ?

2002-09-24 Thread Raul Acevedo
Yes, Country Peru Industry Banking Banco de Credito de Peru Raul L. Acevedo IT Architect IBM Global Services 818-539-3203 Office (TL 396-3203) Glendale, CA 818-599-6626 Mobile [EMAIL PROTECTED] Yuuji Nagasaki/Japan/IBTo: [EMAIL

Re: MQSI Parser problem

2002-08-15 Thread Raul Acevedo
Robert, That usually means that the message being read is not in the expected format. For instance, reading an invalid XML message, or the message read is not in exactly the same format as the definition. Can you use the support pack again? Raul L. Acevedo IT Architect IBM Global Services

Java Object to XML Workflow message

2002-07-11 Thread Raul Acevedo
Does anyone have a Java class or any other way to convert Java objects to XML Workflow messages to CreateAndStartInstance ? Raul L. Acevedo IT Architect IBM Global Services 818-539-3203 Office (TL 396-3203) Glendale, CA 818-599-6626 Mobile [EMAIL PROTECTED] Instructions for managing your

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

2002-06-24 Thread Raul Acevedo
SET OutputRoot.XML.Message = THE(SELECT T.column1, T.column2 FROM Database.table1 AS T); Your values will be in OutputRoot.XML.Message.column1 and OutputRoot.XML.Message.column2 Raul L. Acevedo IT Architect IBM Global Services 818-539-3203 Office (TL 396-3203) Glendale, CA 818-599-6626 Mobile

Re: XML to MRM transformation

2002-05-30 Thread Raul Acevedo
Belinda, Attached is a message flow with a sample of what I think you are trying to do. To move the data in an XML message to the MRM fields with the same name as the XML tag attributes. I hope this helps, (See attached file: EAI_Test.xml) DECLARE Ix INTEGER; SET Ix = 1; WHILE Ix =