System Data Procedures
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 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:
Component | Description |
---|---|
version | Global server version |
build | Build version |
interfaces | Interfaces version |
core | Core version |
infrastructure | Infrastructure version |
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)