Setting PATH
You can use SET PATH schema to set the schema search path, which SQL uses to supply the correct schema name for an unqualified table name. schema can be a single schema name, or a comma-separated list of schema names, as shown in the following example:
[SQL]USER>>SET PATH cinema,sample,user
SET PATH with no argument deletes the current schema search path, reverting to the system-wide default schema name.
If SET PATH schema is not specified, or the table is not found in the specified schemas, SQL Shell uses the system-wide default schema name. For further details on schema search paths, see the #sqlcompile path macro.
