Purpose
Returns the current type of Priority Scheduler.
Definition
REPLACE FUNCTION TD_SYSFNLIB.GetPSFVersion() RETURNS VARCHAR (10) CHARACTER SET LATIN, ... ;
Usage Notes
Priority Scheduler is managed by TASM, and is configured using the Teradata Viewpoint workload management portlets. For more information on those portlets, see Teradata Viewpoint User Guide.
Return Values
| Value | Description |
|---|---|
| WORKLOADS | Current Priority Scheduler uses workload definitions. |
Example: Using GetPSFVersion
This example shows the current Priority Scheduler is using workload definitions.
SELECT TD_SYSFNLIB.GetPSFVersion(); *** Query completed. One row found. One column returned. *** Total elapsed time was 1 second. getpsfversion() WORKLOADS