Returns the current type of Priority Scheduler, WORKLOADS.
Syntax
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.
Example: Using GetPSFVersion
This example shows the current Priority Scheduler is using workload definitions.
SELECT TD_SYSFNLIB.GetPSFVersion();
Result:
*** Query completed. One row found. One column returned. *** Total elapsed time was 1 second. getpsfversion() WORKLOADS