Usage Note 5272: V8 formats are not compatible with V6 formats with SQL Pass-through
facility for Char and Number
The SAS 6.12 format for a CHAR variable is set to blanks when using SQL
Pass-through, and SAS 8.x gives a CHAR variable a format of $n (as is
the case for view descriptors, dynamic libname views, etc.). Your CHAR
variable value could be shown shorter in V8 than in V6 and PROC
CONTENTS will show a format for SAS 8.x, whereas SAS 6.12 will not show
a format.
The SAS 6.12 format for a NUMBER field is set to BESTn when using SQL
Pass-through, and the SAS 8.x format for a NUMBER field is set to
nothing.
If you would like to keep the V6 functionality, you will need to
perform the following steps for SAS 8.1 on Solaris:
1) go to
http://ftp.sas.com/techsup/download/maint/access/oracle/SOL2/8.10
2) download the module sasioora.v6.fmtfix
3) cd !SASROOT/sasexe
4) cp where-file-downloaded-to/sasioora.v6.fmtfix ./sasioora
5) ls -la (check to make sure permissions are 755, and if
not, then change them)
6) set the system optiom DEBUG=V6_FORMATS in the config file
or at SAS invocation
A Technical Support hot fix for Release 8.2 TSLEVEL TS2M0 for this
issue is available at:
http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#005272
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to Oracle | 64-bit Enabled HP-UX | 8.1 TS1M0 | 8.2 TS2M0 |
| HP-UX | 8.1 TS1M0 | 8.2 TS2M0 |
| ABI+ for Intel Architecture | 8.1 TS1M0 | 8.2 TS2M0 |
| Solaris | 8.1 TS1M0 | 8.2 TS2M0 |
| IRIX | 8.1 TS1M0 | 8.2 TS2M0 |
| 64-bit Enabled Solaris | 8.1 TS1M0 | 8.2 TS2M0 |
| 64-bit Enabled AIX | 8.1 TS1M0 | 8.2 TS2M0 |
| Tru64 UNIX | 8.1 TS1M0 | 8.2 TS2M0 |
| AIX | 8.1 TS1M0 | 8.2 TS2M0 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Usage Note |
| Priority: | high |
| Topic: | SAS Reference ==> LIBNAME Engines Data Management ==> Data Sources ==> External Databases ==> Oracle
|
| Date Modified: | 2002-04-22 16:19:35 |
| Date Created: | 2001-06-18 11:25:08 |