DB Get Connection

This Database tool opens up a connection to a database specified in DB Open. If you are planning to use a DB Query step to retrieve a result set, keep in mind that each connection can only hold one result set. If you want to retrieve more than one result set, you should get a connection for each result set you want to retrieve. See the DB Query step for more information on result sets. This step should always be preceded by a DB Open step.

Note: You must close the current DB Connection before opening a new connection to the same DB or your results may not be reliable.  

Settings Page

Database Variable

Specifies which database to open. For this parameter, enter the database variable created in a DB Open step.

Database Connection Variable

Names the database connection.

Timeout

Specifies how long this step will wait for a connection with the server before exiting Failure. The default for this value is 60 seconds. Entering a value <=0 results in this step using the default value of 60 seconds. This parameter takes a real value, so you may specify a decimal, such as 2.5.

Exit Paths

Success

If this step executes successfully, this step takes the Success exit path.

Failure

If this step does not execute successfully, this step takes the Failure exit path. This can occur when the DB variable or DB connection variable is not valid, if the step times out before the connection could be performed, or the DB server's connection limit has been reached. Failures on open and connect depend on the type of database (Oracle, Sybase, etc.).