USE

Function

Uses the named database, rather than the default database associated with your user name. (Sybase and ODBC only)

Syntax

USE database

Arguments

database

The name of the database to use.

Description

Use USE in the SETUP section only. When used, it must appear at the top of your report, before any queries are defined.

To reference more than one database in a program, specify secondary databases explicitly. For example:

from sqdb.sqr.customers

You cannot issue the Sybase or ODBC USE command from within an SQL paragraph.

Examples

begin-setup
  use pubs
end-setup

See Also

The -DB command-line flag described in Production Reporting Command-line Flags.