SET_SCHEMA_NAME¶
Applies to: ORAFlex SQLFlex
This command is used to set the schema name to be used when opening tables. Note that this command will override the schema name that is set in the INT file. The default schema for the current user is used when no name is set.
Syntax
SET_SCHEMA_NAME to {schema}
Parameter |
Description |
|---|---|
variable |
Name of the schema |
Example
SET_SCHEMA_NAME to 'CustomerSchema'
OPEN "CUSTOMER.INT" as CUSTOMER
SET_SCHEMA_NAME to 'SalesSchema'
OPEN "SALESP.INT" as SALESP