SAS Support Site Home | Samples and SAS Notes Home
SAS Notes V6-RLIBRARY-D833
SQL VIEW COULD NOT BE PROCESSED message using Remote Library Services


In Version 6 of the SAS System, the following error may be seen when using Remote Library Services (RLS) in either SAS/CONNECT or SAS/SHARE:

    ERROR: SQL VIEW <libref>.<name> could not be processed.

Any remote SQL view with embedded data set options may fail if the local client's libref is not the same as the remote server's libref assignment. For example, user A creates the following remote view:

    RSUBMIT;
    PROC SQL;
      CREATE VIEW SASUSER.TEST AS
         SELECT * FROM SASUSER.HOUSES(WHERE=(BEDROOMS=2));
    QUIT:
    ENDRSUBMIT;

    LIBNAME LOCAL SLIBREF=SASUSER SERVER=<server_name>;

Locally accessing the view with the name LOCAL.TEST will produce the error. This problem is fixed in Releases 6.08.60 and 6.12.45.


Products: CONNECT
Component: RLIBRARY
Priority: MED
Status: Outstanding Problem
Date: Tue, 9 Dec 1997

System Release Reported Release Fixed
VM/ESA (CMS) 6.08 TS404 6.09 TS460  
OS/390 (MVS) 6.08 TS404 6.09 TS460  
OpenVMS VAX 6.08 TS404 6.09 TS460  
VSE/ESA (VSE) 6.08 TS404  
AIX/6000 6.09 TS027 6.12 TS045  
ConvexOS 6.09 TS027  
HP-UX Operating Systems 6.09 TS027 6.12 TS045  
Solaris 6.09 TS027 6.12 TS045  
DEC Ultrix 6.09 TS027  
OpenVMS Alpha 6.09 TS027 6.12 TS045  
IBM OS/2 6.11 TS020 6.12 TS045  
Windows 3.11 6.11 TS020 6.12 TS045  
Windows NT 6.11 TS040 6.12 TS045  
Windows 95 6.11 TS040 6.12 TS045  
Intel ABI 6.11 TS040  
Silicon Graphics Unix 6.11 TS040  
Compaq Tru64 Unix 6.12 TS040  
Macintosh 6.12 TS040  

No Fixes Available