Skip to main content
Skip table of contents

System Data Procedures

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 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:

ComponentDescription
versionGlobal server version
buildBuild version
interfacesInterfaces version
coreCore version
infrastructureInfrastructure 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)
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.