Welcome Guest! Log in
Stambia versions 2.x, 3.x, S17, S18, S19 and S20 are reaching End of Support January, 15th, 2024. Please consider upgrading to the supported Semarchy xDI versions. See Global Policy Support and the Semarchy Documentation.

The Stambia User Community is moving to Semarchy! All the applicable resources have already been moved or are currently being moved to their new location. Read more…


This article demonstrates how to define SQL Queries which will be executed when initializing a connection.

Those user defined queries can be useful when you need to execute automatically the same list of queries each time a connection is initialized, such as defining options, changing current working databases, ...

Prerequisites:

  • Stambia DI Designer S19.0.18 or higher
  • Stambia DI Runtime S17.6.6 or higher


Metadata Configuration

Defining SQL Queries which should be executed at connection initialization is performed directly in corresponding Metadata.

  1. Open database Metadata
  2. Create a new "Connection Initialization SQL" node on root server node
  3. Define a semi-colon separated list of SQL Queries
  4. Optionally repeat from step 2 to add additional nodes and queries if you want, for instance, to separate them in multiple nodes

 

Creation of "Connection Initialization SQL" node

create node

 

Definition of SQL Queries

defining queries

 

Miscellaneous

You can define multiple "Connection Initialization SQL" nodes, which will be executed in the order defined in Metadata.

multi init node

 

 

 

Articles

Suggest a new Article!