SAP Knowledge Base Article - Preview

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

Symptom

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.


Read more...

Environment

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

Product

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

Keywords

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.