Skip to main content
Skip table of contents

Connection-level Interface Management

All currently available connection-level interface templates are listed in the CliTemplates system table. It has the following fields:

Column Name

Type

Description

id

biginteger

Template ID
namestringTemplate name
createScriptstringCLI script which creates a data source/resource adapter
dropScriptstringCLI script which removes a data source/resource adapter
hiddenPropsstringComma-separated list of properties that will be stored encrypted
creationDatetimestampTemplate creation date
lastModifiedDatetimestampTemplate last modification date
creatorstringName of the user who created the template
modifierstringName of the user who last modified the template
translatorstringTranslator name

SYSADMIN.addCliTemplate

This procedure adds a new CLI template with a specified name.

SQL
CREATE FOREIGN PROCEDURE addCliTemplate(IN name string NOT NULL, IN createScript string NOT NULL, IN dropScript string NOT NULL, IN hiddenProps string, OUT id biginteger NOT NULL RESULT)

SYSADMIN.editCliTemplate

This procedure edits a CLI template with a specified id assigning it a new namecreateScript, and dropScriptnamecreateScript, and dropScript may be set to NULLProperties that should be stored encrypted can be specified by providing them as a comma-separated list via hiddenProps.

 Arguments set to NULL will not be changed during the call.

SQL
CREATE FOREIGN PROCEDURE editCliTemplate(IN id biginteger NOT NULL, IN name string, IN createScript string, IN dropScript string, IN hiddenProps string)

SYSADMIN.dropCliTemplate

This procedure drops a CLI template with the specified id.

SQL
CREATE FOREIGN PROCEDURE dropCliTemplate(IN id biginteger NOT NULL)

SYSADMIN.resetCliTemplates

This procedure restores default templates.

SQL
CREATE FOREIGN PROCEDURE resetCliTemplates()
JavaScript errors detected

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

If this problem persists, please contact our support.