Specifying schemas within the simple specification of database table information

Magic

3.0.0

When you specify a table name during simple specification in the Database Table - Detailed Information screen, you can use a dot (.) in the format "schema-name.table-name". You can specify schemas even when not specifying SQL statements.

If you treat a prefix and a dot within a table name as a schema qualifier, you can specify the setting as follows:

  • Select the Treat a prefix and a dot within a table name as a schema qualifier. check box in the General tab of the System Environment Settings screen.

  • Specify "1" in the treat a prefix and a dot within a table name as a schema qualifier (treat_dot_as_schema) field of the system environment settings file (huledenv.conf).