SUPPORT / SAMPLES & SAS NOTES
Problem Note 58975: Users cannot create and access Netezza temp tables when using SAS/ACCESS® Interface to Netezza
 |  |  |  |  |
When using SAS/ACCESS® Interface to Netezza, you can specify an ODBC data source name (DSN) in the CONNECT statement. If the CONNECT statement specifies the DSN instead of the Netezza user ID and password, you cannot create and access a Netezza temp table.
Here is an example in which the DSN is specified:
libname pwdb netezza dsn=nzsql connection=global;
proc sql;
connect to netezza (dsn=nzsql connection=global autocommit=yes);
execute (create temporary table testtmp(brand_id varchar(1), brand_desc varchar(35),
update_date date)) by netezza;
insert into pwdb.testtmp select * from sasdir.brand;
ERROR: File PWDB.testtmp.DATA does not exist.
To create and access the Netezza temp table, you must specify the Netezza user ID and password when connecting to the database. Here is an example:
libname pwdb netezza user=user-ID pwd=password server=server-name connection=global;
proc sql;
connect to netezza (user=user-ID pwd=password server=server-name connection=global autocommit=yes);
execute (create temporary table testtmp(brand_id varchar(1), brand_desc varchar(35),
update_date date)) by netezza;
insert into pwdb.testtmp select * from sasdir.brand;
quit;
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Netezza | Linux for x64 | 9.4 TS1M3 | 9.4 TS1M4 |
| HP-UX IPF | 9.4 TS1M3 | 9.4 TS1M4 | ||
| 64-bit Enabled Solaris | 9.4 TS1M3 | 9.4 TS1M4 | ||
| 64-bit Enabled AIX | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Windows 7 Ultimate 32 bit | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Windows 7 Professional x64 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Windows 7 Professional 32 bit | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Windows 7 Home Premium x64 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Windows 7 Home Premium 32 bit | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Windows 7 Enterprise x64 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Windows 7 Enterprise 32 bit | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2012 Std | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2012 R2 Std | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2012 Datacenter | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2008 for x64 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2008 R2 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2008 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Windows 7 Ultimate x64 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows 10 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows 8.1 Pro x64 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows 8.1 Pro 32-bit | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows 8.1 Enterprise x64 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows 8 Pro x64 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows 8 Pro 32-bit | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows 8 Enterprise x64 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows 8 Enterprise 32-bit | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft® Windows® for x64 | 9.4 TS1M3 | 9.4 TS1M4 | ||