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, B035-2206.
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