get_sql_definition
Need the SQL definition for a PeopleSoft SQL object? Provide the SQLID to retrieve concatenated SQL text from all definition rows.
Instructions
Get the SQL text for a PeopleSoft SQL object by SQLID.
PSSQLTEXTDEFN stores SQL used by views, App Engine programs, and PeopleCode
(SQL.SQLID). Long SQL is split across multiple rows by SEQNUM.
Args:
sql_id: The SQL object ID (e.g. 'HR_ABSV_JOB_EFFDT', 'GP_PIN_SELECT')
max_length: Maximum total characters to return (default 64000).
Use to avoid huge responses for very long SQL.
Returns:
SQL definition with sql_text (concatenated from all SEQNUM rows),
sql_type, market, and row_count.
Example:
get_sql_definition("HR_ABSV_JOB_EFFDT")
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql_id | Yes | ||
| max_length | No |