SQL command

Data source

This tab view sets the database connection and the default schema that will be used for executing the SQL query. If the database table(s) used in the query are qualified with the schema name, this overrides the default schema specification.

When the Direct SQL Retrieval component is executed, it issues two SQL commands, in the given order:

Set the default schema to the one specified in this view
Run the SQL query as set in the SQL command tab view.

The exact command that sets the default schema is database-dependent. The following table shows sample SQL statements for some of the supported databases:

Database	Set default schema to Northwind
MS SQL Server 2000 and Sybase	use database Northwind
Oracle	alter session set current_schema = NORTHWIND
MySQL	use Northwind
McKoi	set schema Northwind