Set Source

This Set command allows a default SQL/relational data source to be set for use with the SQL command and dialog and for the Data Definition Wizards "Select Data Source" panel.

Note: The SQL data source can also be set by checking the "Save As Default" check box in either the SQL command dialog or in the Data Definition Wizards "Select Data Source" panel.

Note: This SET command is only temporary for the current Analyzer session.

Set Source can also be used with no parameters to reset (clear) a saved data source established using a prior Set Source command (or via the "Save as Default" check box in the SQL command dialog or the Data Definition Wizard's "Select Data Source" panel).

Note: The default SQL/relational data source can be viewed in the Command Log by using the Display Source command. For more information see Display.

Command Mode Syntax

Local Data Sources

SET SOURCE "LOCAL, data-source-name"

Server Data Sources

SET SOURCE "server-profile-name, data-source-name"

Clearing Saved Data Source

SET SOURCE

Examples:

Local:

SET SOURCE "local,sql_server"

SET SOURCE "local,'sql server'"

Server:

Set Source:

SET SOURCE "arbutus_windows_server,sql_server_2008"

SET SOURCE "'arbutus windows server','sql server 2008'"