execute_query
Execute read-only RetrieVe/UniQuery statements (LIST, SELECT, etc.) on Rocket UniVerse and UniData databases and return results with configurable row limits.
Instructions
Execute a RetrieVe/UniQuery statement and return results.
Supports read-only query commands: LIST, SELECT, SORT, COUNT, SUM, SSELECT. Results are limited by max_rows parameter or the U2_MAX_RECORDS configuration.
Args: query: RetrieVe/UniQuery statement Examples: - 'LIST CUSTOMERS WITH STATE = "CA"' - 'SELECT ORDERS WITH ORDER.DATE >= "01/01/2024" BY ORDER.DATE' - 'COUNT INVOICES WITH STATUS = "OPEN"' max_rows: Maximum rows to return (optional, defaults to U2_MAX_RECORDS)
Returns: Dictionary containing query, output, status, and row limit applied.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes | ||
| max_rows | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||