Relational Interface
This section discusses the new and revised functionality to support the relational interface.
•
System Catalog Functions
•
Scalar Functions
System Catalog Functions
Pervasive PSQL v11 SP1 includes the following new system catalog functions:
•
dbo.fSQLColumns
•
dbo.fSQLForeignKeys
•
dbo.fSQLPrimaryKeys
•
dbo.fSQLProcedures
•
dbo.fSQLProcedureColumns
•
dbo.fSQLSpecialColumns
•
dbo.fSQLStatistics
•
dbo.fSQLTables
The system catalog functions allow you to obtain database metadata from the data dictionary files (also known as the catalog) and can be used only in a FROM clause. A temporary view schema for each system catalog function is created during SQLPrepare and data is stored in the view by calling a corresponding ODBC catalog API during SQLExecute.
See the chapter System Catalog Functions in SQL Engine Reference.
Scalar Functions
The following scalar functions are either new, have additional parameters, or were previously undocumented.
 
Function
Description
See in SQL Engine Reference
DAY (date_exp)
Returns the day of the month for the given date_exp.
Time and Date Functions
DATEPART (datepart, date_exp)
TZoffset is an addition to the values that can be used for datepart. TZoffset returns a time zone offset in number of minutes (signed).
Time and Date Functions
ISNUMERIC (string)
Returns 1 (TRUE) if string can be evaluated as a numeric value; otherwise returns 0 (FALSE).
String Functions
REVERSE (string)
Returns a character string with the order of the characters in string reversed.
String Functions
SYSDATETIMEOFFSET
Returns the current date and time along with the hour and minute offset between the current time zone and UTC of the computer on which the Pervasive PSQL database engine is running.
Time and Date Functions
WEEKDAY (date_exp)
Returns the day of the week for the given date_exp, where 1=Sunday and 7=Saturday.
Time and Date Functions