CONNECTION_TOGGLEΒΆ

Toggle the connection-name. Connection might point to different physical data-sources for different systems but share the same logical connection-name. This view returns the SQL-Commands to toggle (rename) the pre-installed connections so the site-Admin can activate the correct connection without the need of (re-) create it and therefore does not need the credentials for the connection.

This script ist driven by the view REDSYS.ADM_CONNCTION_TOGGLE

Parameter Name

Required

DefaultValue

Values

Description

p_connection

yes

connection-name which should be toggled

p_doExecute

yes

  • true

  • false

execute statement when true - if false the statement will just be generated and send to output

Example

EXECUTE SCRIPT api_redsys.connection_toggle
           ( 'ZDW_DATA_SOURCE_!' -- p_connection
           , false               -- p_doExecute
           );