In RDP after connecting to iSeries DB2 from the Data Perspective opening a SQL Script editor for any SQL statement I have to always mention the schema name and the file/table name, other wise it comes up with Failed error *File not found, although in the connection properties I have mention a library/schema name as Default Schema.
Also I found if I type the file name that default to the schema which is same to my user profile will return me the data (can access the file), in this case I don’t have to mention any schema name.
Is there any other way to mention a schema name as default (other than the library/schema name similar to my user profile name) so that from SQL Editor I don’t have to type that schema name always, just typing the file/table name will return me the data.
Thanks & Regards
Dibs
Also I found if I type the file name that default to the schema which is same to my user profile will return me the data (can access the file), in this case I don’t have to mention any schema name.
Is there any other way to mention a schema name as default (other than the library/schema name similar to my user profile name) so that from SQL Editor I don’t have to type that schema name always, just typing the file/table name will return me the data.
Thanks & Regards
Dibs
Comment