MQSeries.net :: View topic - problem in messageflow with database operation

rohit

Hi,
I was trying to create a messageflow by which i can retrieve the details from the database.
I have created a database called dbase1 and table called table1 with two fields item and cost.
then i configured DSN using administrative tool->odbc(32 bit) with (dbase name)same name.
and in compute node i coded the following.

SET OutputRoot=InputRoot;
SET OutputRoot.XML.Product.cost[] =
(SELECT T.Item,T.Cost FROM TABLE1 AS T);

the input message i am planning is

<product>
<item>orange</item>
</product>

the output message i prefer is

<product>
<item>orange</item>
<cost>500</item>
</product>

when i try to deploy the following error message is comming,Can anyone tell me what is the mistake i am doing .
Is my dsn creation is correct or am i missing anything.

BIP2432E: (, 5.28) : The correlation name 'TABLE1' is not valid. Those in scope are: Environment, InputLocalEnvironment, OutputLocalEnvironment, InputRoot, InputBody, InputProperties, OutputRoot, InputExceptionList, OutputExceptionList, Database, InputDestinationList, OutputDestinationList.

The first element of a field reference must be a valid correlation name, from those in scope. This message may sometimes be due to an incorrectly formed or spelled expression which is not intended to be a field reference being parsed as if it were a field reference because the parser does not recognize it.

Correct the syntax of the expression and redeploy the message flow.

Regards
Rohit