You try to retrieve a table of values from a database and only get the last one

Technote (troubleshooting)


Problem(Abstract)

WebSphere Message Broker (WMB): When you retrieve a table of values from a database you just get the last one.

Resolving the problem

If you execute SQL of the following format, you will only see one of the relevant rows from your table:

SET OutputRoot.XML.Test.Results = [SELECT T.column FROM Database.Table];

If you want to see all of the rows, use the following syntax:

SET OutputRoot.XML.Test.Results[] = [SELECT T.column FROM Database.Table];

Product Alias/Synonym

WMB / WBIMB / WMQI / MQSI

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

WebSphere Message Broker
ESQL

Software version:

6.1, 7.0, 8.0

Operating system(s):

AIX, HP-UX, Linux, Linux SUSE - zSeries, OS/390, OS/400, Solaris, Tandem NSK, Windows, z/OS

Reference #:

1127567

Modified date:

2012-11-30

Translate my page

Machine Translation

Content navigation