Skip to main content

  • ​
    showSqlProc

    public ShowSqlProcResponse showSqlProc(ShowSqlProcRequest request) throws GPUdbException
    Shows information about SQL procedures, including the full definition of each requested procedure.
    Parameters:
    request - Request object containing the parameters for the operation.
    Returns:
    Response object containing the results of the operation.
    Throws:
    GPUdbException - if an error occurs during the operation.

  • ​
    showSqlProc

    public ShowSqlProcResponse showSqlProc(String procedureName, Map<String,String> options) throws GPUdbException
    Shows information about SQL procedures, including the full definition of each requested procedure.
    Parameters:
    procedureName - Name of the procedure for which to retrieve the information. If blank, then information about all procedures is returned. The default value is ”.
    options - Optional parameters.
    • NO_ERROR_IF_NOT_EXISTS: If TRUE, no error will be returned if the requested procedure does not exist. If FALSE, an error will be returned if the requested procedure does not exist. Supported values:The default value is FALSE.
    The default value is an empty Map.
    Returns:
    Response object containing the results of the operation.
    Throws:
    GPUdbException - if an error occurs during the operation.