System Data Procedures

You are looking at an older version of the documentation. The latest version is found here.

SYSADMIN.getInstalledLicense

This procedure provides license information.

SQL

CALL getInstalledLicense(OUT expDate timestamp NOT NULL RESULT, OUT trial boolean NOT NULL, OUT holder string NOT NULL, OUT startDate timestamp NOT NULL, OUT consumerType string NOT NULL, OUT consumerAmount integer NOT NULL, OUT info string NOT NULL, OUT limitInfo string )

Example

SQL

SELECT * FROM (CALL SYSADMIN.getInstalledLicense()) a;;

SYSADMIN.getSchemaVersion

This procedure returns the custom Data Virtuality schema version.

SQL

SYSADMIN.getSchemaVersion(OUT i integer RESULT)

Example

SQL

CREATE VIRTUAL PROCEDURE test2() RETURNS (i integer) AS
BEGIN
SELECT * FROM (CALL sysadmin.getSchemaVersion())a;
END;

SYSADMIN.getServerBuildInfo

This procedure returns the commit's timestamp in the following format: 2019-08-22T17:20:04+0200 as buildDate.

SQL

CREATE FOREIGN PROCEDURE getServerBuildInfo(OUT buildDate string NOT NULL)

SYSADMIN.getServerVersion

This procedure returns the version of the Data Virtuality Server.

SQL

SYSADMIN.getServerVersion(OUT version string NOT NULL, OUT build string NOT NULL, OUT interfaces string NOT NULL, OUT core string NOT NULL, OUT infrastructure string NOT NULL)

The version consists of the global server version and the components that correspond to the appropriate Data Virtuality Server part:

Component	Description
`version`	Global server version
`build`	Build version
`interfaces`	Interfaces version
`core`	Core version
`infrastructure`	Infrastructure version

Example

SQL

SELECT * FROM (CALL SYSADMIN.getServerVersion()) AS a

SYSADMIN.getXMLSchemas

deprecated

SYSADMIN.sendLicenseFile

This procedure uploads a license file via the Web Admin interface. It receives a base64 string representation of the license file and uploads it to the server.

SQL

SYSADMIN.sendLicenseFile(IN base64License string NOT NULL)