Connector Management

SYSADMIN.getSchemaTmpValue

This procedure gets stored data for the specified connector's schema.

SQL

SYSADMIN.getSchemaTmpValue(IN name string NOT NULL, OUT val string NOT NULL RESULT)

Example

SQL

CALL "SYSADMIN.setSchemaTmpValue"(
    "name" => 'asdas',
    "val" => CAST( {ts'1970-01-01 00:00:00.000'} AS timestamp ) 
);

SELECT * FROM ( CALL SYSADMIN.getSchemaTmpValue( 'asdas') )a ;

SYSADMIN.setSchemaTmpValue

This procedure sets stored data for the specified connector's schema.

SQL

SYSADMIN.setSchemaTmpValue(IN name string NOT NULL, IN val string NOT NULL)

Example

SQL

CALL "SYSADMIN.setSchemaTmpValue"(
    "name" => 'asdas',
    "val" => CAST ( {ts'1970-01-01 00:00:00.000'} AS timestamp ) 
);

SELECT * FROM ( CALL SYSADMIN.getSchemaTmpValue( 'asdas') )a ;

SYSADMIN.getClientSecret

This procedure gets the client secret and may be used in dvconnector code.

SQL

SYSADMIN.getClientSecret(IN suffix string, OUT val string RESULT)

SYSADMIN.getConnProp

This procedure gets a connector's property and may be used only in dvconnector code.

SQL

SYSADMIN.getConnProp(IN pkey string NOT NULL, OUT val string RESULT)

SYSADMIN.writeConnProp

This procedure writes a connector property and may be used only within initializeMetadata() in dvconnector code.

SQL

SYSADMIN.writeConnProp(IN pkey string NOT NULL, IN val string NOT NULL)