Search Columns
search_columnsFind DB2 for i columns by name or description text across libraries using * wildcards to match column metadata. Respects schema allowlists and skips system libraries by default.
Instructions
Find columns by name or description text across libraries. Matches COLUMN_NAME, SYSTEM_COLUMN_NAME, and COLUMN_TEXT. Use * as a wildcard. When a schema allowlist is configured, only those libraries are searched. Otherwise system libraries (Q* and SYS*) are skipped unless include_system is true.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Maximum rows to return. Capped by QUERY_MAX_LIMIT. | |
| filter | Yes | Name or text to match. Use * as a wildcard. Example: "ITEM*" matches columns starting with ITEM | |
| schema | No | Limit the search to one library. Must be in the schema allowlist when one is configured. | |
| include_system | No | Include Q* and SYS* libraries. Ignored when a schema or a schema allowlist is set. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| data | No | ||
| count | No | ||
| error | No | ||
| success | Yes | ||
| truncated | No |