Using EVAL to generate Update Statement dynamically

Hello, Following ESQL does not give the desired output:   DECLARE sqlStmt CHARACTER; SET sqlStmt = 'UPDATE Database.TEST SET (FIELDONE, FIELDTWO, FIELDTHREE) = (';SET sqlStmt = sqlStmt || Environment.Variables.VAR1 || ' ,' ;SET sqlStmt = sqlStmt || CAST(Environment.Variables.VAR2 AS CHAR) || ',' ;S

Using EVAL to generate Update Statement dynamically

Hello, Following ESQL does not give the desired output:   DECLARE sqlStmt CHARACTER; SET sqlStmt = 'UPDATE Database.TEST SET (FIELDONE, FIELDTWO, FIELDTHREE) = (';SET sqlStmt = sqlStmt || Environment.Variables.VAR1 || ' ,' ;SET sqlStmt = sqlStmt || CAST(Environment.Variables.VAR2 AS CHAR) || ',' ;

SWIFT Message Sets

Are there any standard message sets available for SWIFT.Does it come with the WMQI 2.1 s/w or do any of you have the original messgae set or a link to it or the mrp file? Do you Yahoo!? Yahoo! Tax Center - File online by April 15th

REPOST###MEssage Catalog

I have created the cat file EAI.cat ,using gencat and the msg file had   4000 :\ User defined exception but i get the following errorBIP2176S TestBkr COULD NOT FIND MESSAGE 4000 IN CATALOGUE /USR/LPP/BOFA/WMQI/MESSAGES/EN_US/EAI.CAT, and i use the throw statementThrow user exception catalog E

Repost####Parsing Embedded XML in WMQI

I have an XML test    Iam using the XML domain NOT MRM, I want the outputroot going out of the a compute node to be only the inner XML and the parser should understand thatHow do I do that ? Info on asbitstream and create/parse is only in the readme ! Has anyone used it pls let me how to do it!  Cr

Message catalog: BIP2176S could not find message 4000

I have created the cat file EAI.cat ,using gencat and the msg file had   4000 :\ User defined exception but i get the following errorBIP2176S TestBkr COULD NOT FIND MESSAGE 4000 IN CATALOGUE /USR/LPP/BOFA/WMQI/MESSAGES/EN_US/EAI.CAT, and i use the throw statementThrow user exception catalog E

Embeded XML , CREATE PARSE , ASBITSTREAM??

I have an XML test    Iam using the XML domain NOT MRM, I want the outputroot going out of the a compute node to be only the inner XML and the parser should understand thatHow do I do that ? Info on asbitstream and create/parse is only in the readme ! Has anyone used it pls let me how to do it!  Cr

message catalog files in z/os

Does WMQI z/os support user defined message catalog files? How can I create message catalog files in WMQI 2.1 on z/os ? AIX it can be done using the the gencat command, the prog guide talks about Windows and Unix only!Any pointers to this? Do you Yahoo!? Yahoo! Search - Find what you re looking for

WBI Adapters / Crossworld Adapters

  Any of  you used any of the WBI adapters both technology or application in production?Are there any performance figures published for these adapters.I believe that the retek adapter is withdrawn! Do you Yahoo!? Yahoo! Mail SpamGuard - Read only the mail you want.

Predefined XML - REQUIRED XML attributes

Iam using a pre defined XML which is created using a DTD.I've enabled the validation to occur in the input node.Now , I have an tag which has an attribute that is a required field, but I completely omit this attribute in the input message , it does'nt crib!Does'nt WMQI validate the XML attribute ?

Default values and TDS Fixed Width

Iam using the TDS format to model my output message which looks like HeaderDetail1Detail2 all fixed width and detail repeats.The header is defined as Fixed Width and the detail uses 'use data pattern'= .{length}I also have default value of space or zero assigned to all elements.It parses fine and I

WMQI Message Catalog

For a System generated Error Message, WMQI picks up the message from the message catalog ( wmqi2.1.properties file) and substitutes the context information and displays it on the log/ event viewer. For example , this is the template message 5902: BIP5902W: \ An error occurred in parser ''{0}''  wh

WMQI Error accessing DB2 Table Native Error Code '-1224';

Hi , I have a subflow that hits a DB2 Database to fetch ceratin details.Many other flows use this subflow. Broker runs on AIX (WMQI 2.1) , it works fine for few attempts after which it throws an error  Dec 17 05:20:30 myhost WMQIv210[1744942]: (myhost.Phase1)[2856]BIP2322E:Database error: SQL State

Message Sequencing in MQSeries

Hi All,   Is sequencing of persistent messages always assured in MQSeries when the messages moving from one queue manager to another ? The inter communcation is set up as follows.   -There is one sender receiver channel pair b/w the queue managers   - All the Messages are persistance - All the mess

Scheduling Message Flows-WMQI2.1

Hi , Is there some way I can schedule message flows ?The input node is always constantly looking for messages in a queue and grabs it .But if I want have a message flow 'A' , to start only after I receive a message from a certain application in another queue , what do I do?? Do you Yahoo!? Protect

Limit on the Destination List in WMQI2.1 (AIX)

For routing , when you populate the destination list have you encountered any limitation on the number of destinations that we can have. Are there any performance issues if the destination list is too big? Any pointers to these in the manuals /Redbooks? Do you Yahoo!? Protect your identity with Ya

Perl and MQ

Hi , If I have a program that puts a zipped file in the queue using Perl in MIME format, can I have a C/Java program to retrieve back the zipped file? Thanks       Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard

Support Pac IA91 , to store temporary data in WMQI

I was looking at this support pac IA91 to store temprary data  in WMQI , looks useful for critical response time by avoiding database hits , but has anyone used it in production?Did you face any issues? Do you Yahoo!? The New Yahoo! Shopping - with improved product search

IA91 , storing temporary data in WMQI

I was looking at the support pac ia91 , looks useful to store temp data and not hit the database , but has anyone used this in production? Any problems with it with huge key value pairs in a hashtable?   Do you Yahoo!? The New Yahoo! Shopping - with improved product search

CopyBook with Occurs Clause

Hi, I have the following COBOL copy book imported into WMQI 2.1 CSD 5. 01 MYCOMPOUND_ELEMENT. 05 MYREPEAT_ELEMENT OCCURS 3 TIMES. 10 TEST-ELEM PIC X(2). CWF properties , Min Occurs and Max Occurs is set to 3. I modified min occurs to 1. If I send a AB12XY , it works fine. But if I send only the

Crossworlds MQConnector and data conversion

Hi,   Iam using MQConnector to get messages from a queue and populate a BO. Message is put by an RPG pgm on AS/400 , contains a string data, zoned decimal and packed decimal. I get a number format exception. How does the data conversion happen with MQConnector? This is what the doc has to say Th

Putting MQRHF2 header using MQ Classes for Java

Hi ,   Is it possible to put MQRFH2 header using MQ classes for Java. Class ,MQMessage has properties and methds that only manipulate MQMD. Is it possible WITHOUT using MQ JMS.   Thanks In Advance     Do you Yahoo!? The New Yahoo! Shopping - with improved product search

Crossworlds MQConnector and data conversion

Hi,   Iam using MQConnector to get messages from a queue and populate a BO. Message is put by an RPG pgm on AS/400 , contains a string data, zoned decimal and packed decimal. I get a number format exception. How does the data conversion happen with MQConnector? This is what the doc has to say Th

Re: Packed Decimal Positive Code- CWF properties in WMQI

lare a sign on the 4P2 >value (should this by -4P2?). The RPG compiler will then generate code to >create a sign zone. This is certainly the case on a zOS system with COBOL. >It sounds like WMQI might be very strict in the way it interprets the sign >value, and doesn't understan

Packed Decimal Positive Code- CWF properties in WMQI

Hi, What is this 'packed decimal positive code' in the CWF properties tab.Doc says it should be 'C' but for few systems it has to be 'F'. Iam curious about this field , coz iam having a RPG pgm that declares a  variable as  4P2 and assigns a value -56.78 , but when my broker retrieves this  (WMQI o

Re: SOC 7 error while displaying S99 Fields in COBOL (WMQI 2.1)

:50:26 -0700> >> >Someone correct me if I am wrong It has been in the> >back of my mind that the S9 and COMP-3 fields have to> >be changed ,before they are MQPUTed, to flat PIC 9 s> >without the assumed sign and COMP-3, and that the> >assumed sign to be co

Re: REPOST@@@@@ !SOC 7 error while displaying S99 Fields in COBOL (WMQI 2.1)

, 27 Aug 2003 08:50:26 -0700> >> >Someone correct me if I am wrong It has been in the> >back of my mind that the S9 and COMP-3 fields have to> >be changed ,before they are MQPUTed, to flat PIC 9 s> >without the assumed sign and COMP-3, and that the> >assumed sign to

SOC 7 error while displaying S99 Fields in COBOL (WMQI 2.1)

Hi , I have the following COBOL copy book imported into WMQI(2.1 WinNT) 06  TESTVARIABLES.    07  TESTINPUT.   08  INTEGERNOSIGN   PIC 99.   08  INTEGERSIGNED   PIC S99.   08  DECIMALNOSIGN   PIC 99V99.   08  DECIMALSIGNED   PIC S99V99.   08  COMP3NOSIGN

COMP-3 , Signed fields in COBOL Copybooks

Hi,   I have the following COBOL copybook imported into MQSI.01   TESTVARIABLES.   05  INTEGER_NOSIGN   PIC 99.   05  INTEGER_SIGNED   PIC S99.   05  DECIMAL_NOSIGN   PIC 99V99.   05  DECIMAL_SIGNED   PIC S99V99.   05  COMP3_NOSIGN PIC 99V99 COMP-3.