OSQL CREATE DS Command

PURPOSE: This command connects all or specific Oracle tables in a particular Oracle Server (database) to the current DBL (Data Base Library) repository. This command creates the DS object or objects in the current DBL. This command will prompt you for the Oracle user name and password that you wish to use.

Syntax

OSQL CREATE DS FOR {ALL TABLES, TABLE table_name} [HUSH]

table_name	is the name of the table from which you want to copy rows.
HUSH	tells the CREATE DS command to process the Oracle Server without displaying the associated messages.

EXAMPLE

*CREATE DBL ONLINE_DATA

*OSQL CREATE DS FOR ALL TABLES HUSH

enter your user name:

enter your password:

SEE ALSO: OSQL IMPORT, OSQL EXPORT