SAP Knowledge Base Article - Preview

2479771 - How to detect whether a local temporary table exists or not in a user connection.


Is it possible to check the existence of a local temporary table in IQ?
The sp_iqtable and any systable doesn't list the local temporary table.



  • SAP IQ 16.0
  • SAP IQ 15.4
  • SAP Sybase IQ 15.2
  • SAP Sybase IQ 12.7


SAP IQ 16.0 ; SAP IQ 16.1 ; SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4 ; Sybase IQ 12.7


IQ, SYBASE, temp, temporary, temporary table, local temporary table, global temporary table, sp_iqtable, systab, sysiqtable, drop if exist, temp table, local, global , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.