API Definition
REPLACE PROCEDURE tdstats.SelectFromObjectlistJSON
(IN jIn JSON(3000) CHARACTER SET UNICODE,
OUT jOut JSON(3000) CHARACTER SET UNICODE)
DYNAMIC RESULT SETS 1
JSON Input Keys
| JSON Key |
Data Type |
Description |
|---|
| ObjectListName |
VARCHAR(128) |
Name of the existing list whose object entries should be displayed. |
| ObjectListID |
BIGINT |
Optional numeric identifier for the list to be displayed. |
Dynamic SQL Result Columns
| Column Name |
Data Type |
Description |
|---|
| ObjectListName |
VARCHAR(128) |
Name of the list containing the object. |
| DatabaseName |
VARCHAR(128) |
Database with one or more objects contained in the list. |
| ObjectName |
VARCHAR(128) |
Individual table contained within the object list. If NULL, all tables in the displayed DatabaseName are part of the list.
|