GetPSFVersion Function | Application Programming Reference | Teradata Vantage - 17.05 - GetPSFVersion - Teradata Database

Teradata Vantage™ - Application Programming Reference

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Programming Reference
featnum
B035-1090-170K

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