Usage Note 69453: "Error attempting to CREATE a DBMS table. ERROR: CLI execute error" occurs when you try to create a Cockroach database temporary table
 |  |  |  |
When you use SAS/ACCESS® Interface to PostgreSQL to create a temporary table in Cockroach, an error similar to the following might occur:
ERROR: Error attempting to CREATE a DBMS table. ERROR: CLI execute error:
ERROR: temporary tables are only supported experimentally;
ERROR: temporary tables are only supported experimentally;
At this time, temporary tables are experimental in Cockroach.
To work around this issue, specify the DBLIBINIT and DBLIBTERM LIBNAME options with the following syntax:
%let connopt=%str(server='cockroach.server.com' port=xxxx user=xxxx password='xxxx' database=xxxx cursor_type=FORWARD_ONLY);
libname x postgres &CONNOPT connection=shared DBMSTEMP=YES DBLIBINIT='SET experimental_enable_temp_tables = "on"' DBLIBTERM='SET experimental_enable_temp_tables = "off"';
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Viya | Linux for x64 | 2021.1.5 | Viya | ||
| Type: | Usage Note |
| Priority: |
| Date Modified: | 2022-08-17 14:26:03 |
| Date Created: | 2022-08-05 15:02:10 |