Callable Routines per RDBMS

Each WhereScape RED Callable Routine exists in the database as either a Stored Procedure or a User-defined Function that can be invoked from SQL. A Callable Procedure is invoked by a SQL call/execute statement and a Callable Function is invoked in a SQL SELECT statement or a value expression. The Callable Routines are typically implemented as procedures in most database systems due to RDBMS limitations of userdefined functions, when the WhereScape RED API was originally developed.

Routine Name	SQLServer	Teradata	Oracle	DB2
Ws_Api_Glossary	Procedure	Procedure	Function	Procedure
Ws_Connect_Replace	Procedure	Procedure	Function	Procedure
Ws_Job_Abort	Procedure	Procedure	Function	Procedure
Ws_Job_Clear_Archive	Procedure	Procedure	Function	Procedure
Ws_Job_Clear_Logs	Procedure	Procedure	Function	Procedure
Ws_Job_Clear_Logs_By_Date	Procedure	Procedure	Function	Procedure
Ws_Job_Create	Procedure	Procedure	Function	Procedure
Ws_Job_CreateWait	Procedure	Procedure	Function	Procedure
Ws_Job_Dependency	Procedure	Procedure	Function	Procedure
Ws_Job_Release	Procedure	Procedure	Function	Procedure
Ws_Job_Restart	Procedure	Procedure	Function	Procedure
Ws_Job_Schedule	Procedure	Procedure	Function	Procedure
Ws_Job_Status	Procedure	Procedure	Function	Procedure
Ws_Load_Change	Procedure	Procedure	Function	Procedure
Ws_Maintain_Indexes	Procedure	Procedure	Function	Procedure
Ws_Version_Clear	Procedure	Procedure	Function	Procedure
WsParameterRead	Procedure	Procedure	Function	Procedure
WsParameterReadF	Procedure	Procedure	Function	Procedure
WsParameterReadG	Procedure	Procedure	Function	Procedure
WsParameterWrite	Procedure	Procedure	Function	Procedure
WsWrkAudit	Procedure	Procedure	Function	Procedure
WsWrkAuditBulk	Procedure	Procedure	Function	Procedure
WsWrkError	Procedure	Procedure	Function	Procedure
WsWrkErrorBulk	Procedure	Procedure	Function	Procedure
WsWrkTask	Procedure	Procedure	Function	Procedure

Content

Space Tools