MQSeries.net :: View topic

paldebojyoti · Posted: Thu Oct 28, 2004 2:26 am Post subject:

Hi,
I am facing a problem in SELECT statement in ESQL in WMQI 2.1. My query is
SET DEP_GMT_OFFSET = THE (SELECT T.gmt_min_offset
FROM Database.GMT_OFFSET AS T
WHERE T.tm_zn_cd = 'A' );

But it gives me the errors:
UserTrace BIP2544I: Node 'IDEAS_MSG_FLOW.XMLGENERATOR': Executing database SQL statement 'SELECT T.gmt_min_offset FROM GMT_OFFSET T WHERE (T.tm_zn_cd)=('A')' derived from (1, 1); expressions ''; resulting parameter values ''.

UserTrace BIP2231E: Error detected whilst processing a message 'IDEAS_MSG_FLOW.XMLGENERATOR'. The message broker detected an error whilst processing a message in node 'IDEAS_MSG_FLOW.XMLGENERATOR'. The message has been augmented with an exception list and has been propagated to the node's failure terminal for further processing.

See the following messages for details of the error.

RecoverableException BIP2556E: An attempt has been made to assign a scalar, row or list quantity to a target of a different basic type. Scalar values may only be assigned to scalars, rows may only be assigned to rows and lists may only be assigned to lists.