GetPSFVersion Function | Application Programming Reference | Teradata Vantage - 17.10 - GetPSFVersion - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Application Programming Reference

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1090-171K
Language
English (United States)

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();
 *** Query completed. One row found. One column returned.
 *** Total elapsed time was 1 second.
getpsfversion()  WORKLOADS