MQSeries.net :: View topic

narendra · Posted: Fri Jul 12, 2002 2:40 pm Post subject:

This is my input message:
<Message>
<ACTION>INSERT</ACTION>
<TEST1>HIT1 10</TEST1>
</Message>

This is what is in my database node and it works. Please note I hardcoded the table
name and the column name in the insert statement.

If Body.Message.ACTION = 'INSERT' THEN
INSERT
INTO Database.DAVID.TEST1 (COL1)
VALUES (Body.Message.TEST1);
END IF;

However, I would like NOT to hardcode the the insert statement with the table name and column name but have them picked up from some varaibles ; that is,

I would like my input message to be
<Message>
<ACTION>INSERT</ACTION>
<TABLE>DAVID.TEST1</TABLE>
<COLUMN>COL1</COLUMN>
<TEST1>HIT1 10</TEST1>
</Message

How to code the database node to pick up the table name and column name dynamically ?

If Body.Message.ACTION = 'INSERT' THEN
INSERT
INTO Database.XXXX (YYY )
VALUES ((Body.Message.TEST1);
END IF;

what ESQL functions should I use to resolve XXXX to David.TEST1
and YYY to COL1 ?

Thanks in advance
Narendra