The files PORTQRY.611 and PORTSQL.611 contain QUERY and SQL catalog
entries in transport format.  The files contain the fixes for several
SQL Query Window problems in Release 6.11:


V6-QUERY-A950

  CREATE TABLE or CREATE VIEW options fail in the Query Window

  In Release 6.11, you can not create a SAS data set or view in the SQL
  Query Window using the access mode of ODBC.  You will receive the
  messages when you attempt to create a SAS data set or view:

    ERROR:  Invalid connect option: create
    ERROR:  ODBC SQL API Error #IM002:   Microsoft ODBC Driver Manager
            Data source name not found and no default driver specified
    ERROR:  Connection to the ODBC DBMS does not exist.


V6-QUERY-A961

  QW_RUN SCL class method will not run query when data is on remote host

  The QW_RUN SCL class method allows you to run a SQL query created and
  stored through the SQL Query Window in a AF/SCL program without having
  to invoke the Query Window.  However, the query will not execute when
  the data resides on a remote host system.  You may receive a program
  halt on PC systems.


V6-QUERY-A984

  The Lookup Distinct Values feature has been added to the Prompt at
  Runtime window.  You can request the unique values for a column while
  resolving a prompt string at runtime.  However, a problem issues when
  the value you are resolving is a DBMS date.  Once you have selected a
  value for the date column, the value is not displayed in the WHERE
  clause.




INSTALLATION OF THE NEW CATALOG ENTRIES:
---------------------------------------

To install the new catalogs, please follow these steps:

PC INSTALLATION INSTRUCTIONS:
----------------------------

1)  Download the files, PORTQRY.611 and PORTSQL.611 to your pc.
2)  Invoke the SAS System and submit the following SAS code from the
    SAS DMS program editor:

     /* CHANGE dir TO THE APPROPRIATE DIRECTORY */
     filename tranfle1 'dir:\portqry.611';

     /* CHANGE dir TO THE APPROPRIATE DIRECTORY */
     filename tranfle2 'dir:\portsql.611';

     proc cimport cat=sashelp.query infile=tranfle1;
     run;

     proc cimport cat=sashelp.sql infile=tranfle2;
     run;

This step replaces existing entries in your production SASHELP library.



UNIX INSTALLATION INSTRUCTIONS:
-------------------------------

1)  Download the files, PORTQRY.611 and PORTSQL.611 to your Unix System.
2)  Invoke the SAS System and submit the following SAS code from the
    SAS DMS program editor:

      
      /* CHANGE dir TO THE APPROPRIATE DIRECTORY */
      filename tranfle1 'yourdir/portqry.611';  
      
      /* CHANGE dir TO THE APPROPRIATE DIRECTORY */        
      filename tranfle2 'yourdir/portsql.611';  
                   
      proc cimport cat=sashelp.query infile=tranfle1;
      run;

      proc cimport cat=sashelp.sql infile=tranfle2;
      run;

This step replaces existing entries in your production SASHELP library.