I am using an RvRPC Client to request the following information from ADBselect count(c.cod) cnt from table c where...How do I then access the value returned from "count(c.cod)"?
Article ID: KB0087704
Updated On:
| Products | Versions |
|---|---|
| TIBCO MessageBroker | - |
| Not Applicable | - |
Description
Resolution:
In SQL you can assign an arbitrary name to a return column.
Try modifying your SQL statement to be something like:
select count(c.cod) cnt from table c where...
It assigns the name "cnt" to the return column. The result you get back should be something like:
(results={row={cnt=0.0}},status=0}
and you can then access the value as "results.row.cnt" in MB.
In SQL you can assign an arbitrary name to a return column.
Try modifying your SQL statement to be something like:
select count(c.cod) cnt from table c where...
It assigns the name "cnt" to the return column. The result you get back should be something like:
(results={row={cnt=0.0}},status=0}
and you can then access the value as "results.row.cnt" in MB.
Issue/Introduction
I am using an RvRPC Client to request the following information from ADBselect count(c.cod) cnt from table c where...How do I then access the value returned from "count(c.cod)"?
Environment
Product: TIBCO MessageBroker
Version: 4.1, 3.2.1.6
OS: All
--------------------
Feedback
Yes
No
Powered by
