Hi folks
In my session properties' object tree I've put the name of the schema I
want to load in "Schema include". So every time I open a session only that
schema is included.
I supposed that I should not need to set the schema in the SQL editor when
running a query.
But it seems that the set command is needed _only the first time a query is
run_. If I open a file without the set command, it doesn't work at first;
if i add it it works; if I remove it it keeps working within the current
session.
Is it sensible?
I should conclude that I must keep the set command in my query files?
SET SCHEMA schema_name;
Thanks for any explanation
Federico
|