2395374 - Error: 'HY000:ERROR: CREATE TABLE AS SELECT not permitted in read-only session' when attempting to create a report using temp table in Crystal Reports

• Unable to create a new report off a Command Object.
• When attempting to create a report using a custom SQL Query it fails.
• When attempting to create a new report connecting to Netezza using an ODBC connection in Crystal Reports, and entering in a Command Object an SQL Query that uses a temp table, it fails with the error:
        
  "Database Connector Error: 'HY000:ERROR: CREATE TABLE AS SELECT not permitted in read-only session [Database Vendor Code: 46 ]'"

• SAP Crystal Reports 2011
• SAP Crystal Reports 2013
• SAP Crystal Reports 2016
• SAP Crystal Reports 2020
      
• IBM Netezza

CR, Temp Table , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem