System Data Procedures

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

These procedures enable you to get information about your Data Virtuality Server instance: license, schema version, server build and version. There is also a procedure to upload the license file via the Web Admin interface.

SYSADMIN.getInstalledLicense

This procedure provides license information.

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

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

SYSADMIN.getSchemaVersion

This procedure returns the custom Data Virtuality schema version. 

SYSADMIN.getSchemaVersion(OUT i integer RESULT)

Example

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.

CREATE FOREIGN PROCEDURE getServerBuildInfo(OUT buildDate string NOT NULL)

SYSADMIN.getServerVersion

This procedure returns the version of the Data Virtuality Server.

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:

Example

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.

SYSADMIN.sendLicenseFile(IN base64License string NOT NULL)