Re: WDSCi Data perspective thinks my user name is the library name.

[CRPence <CRPbottle@xxxxxxxxx>]

  Pending a[s likely resolution to the concern by a] change to the 
SQL "naming" option, just library-qualify the object references in 
the SQL statements.  So for example instead of issuing the request 
"SELECT * FROM MYFILE" for which the SQL infers the request to have 
been "SELECT * FROM MYUSER.MYFILE", issue the request "SELECT * FROM 
THELIBNAME.MYFILE".  FWiW: Depending on the interface established by 
WDSC for its connection\session, the option may exist to just issue 
the "SET CURRENT SCHEMA THELIBNAME" before invoking SQL with 
unqualified name references, to effect the library name as the 
default for those unqualified non-path object references.

Regards, Chuck

GKern@xxxxxxxxxxxxxxxx wrote:
> I recently discovered the data perspective and want to use it for
>  adhoc sql, but when I run a simple select statement, it returns
> errors saying the file isn't found in 'library' - and the error
> text shows the library as being my user id.
>
> I tried qualifying the library name but that didn't work either.
>
> How do I get it to recognize the proper location of the data 
> file?