show_sql_proc - Kinetica Docs

show_sql_proc

show_sql_proc(
procedure_name?: string,
options?: Record<string, string>,
callback?: GPUdbCallback,
): Promise<ShowSqlProcResponse>
Shows information about SQL procedures, including the full definition of each requested procedure.
Parameters
- Optionalprocedure_name: string
  Name of the procedure for which to retrieve the information. If blank, then information about all procedures is returned.
- Optionaloptions: Record<string, string>
  Optional parameters.
- Optionalcallback: GPUdbCallback
  Optional callback function
Returns Promise<ShowSqlProcResponse>
Promise<Types.ShowSqlProcResponse> - Promise resolving to the response
- Defined in src/GPUdb.ts:13737

show_sql_proc_request

show_sql_proc_request(
request: ShowSqlProcRequest,
callback?: GPUdbCallback,
): Promise<ShowSqlProcResponse>
Shows information about SQL procedures, including the full definition of each requested procedure.
Parameters
- request: ShowSqlProcRequest
  Request object containing the parameters for the operation
- Optionalcallback: GPUdbCallback
  Optional callback function
Returns Promise<ShowSqlProcResponse>
Promise<Types.ShowSqlProcResponse> - Promise resolving to the response
- Defined in src/GPUdb.ts:13713