SAP Knowledge Base Article - Preview

2553510 - IQ utilities does not work as expected in user defined procedure.

Symptom


When executing a user defined procedure to get the table size, iq utilities does not work as expected.
The name of table is returned as capital letter in spite of small letter in system table.

---------------------------------------------------------------------------------------------
CREATE procedure "DBA"."sp_tablesize"(

declare local temporary table iq_tablesize_temp(
execute immediate 'iq utilities main into iq_tablesize_temp table size ' || full_tbl;
---------------------------------------------------------------------------------------------

      It makes the data has been omitted when joining with iq_rowcount_temp table.
      The iq_rowcount_temp table stores the name of table as small letter as expected.

      --------------------------------------------------------      
      Select

      ...
      from

             iq_tablesize_temp ts
             inner join
             iq_rowcount_temp rc

 on ts.Ownername = rc.Ownername
 and ts.Tablename = rc.Tablename;
 --------------------------------------------------------


Read more...

Environment

  • SAP IQ 16.0

Product

SAP IQ 16.0

Keywords

IQ, SYBASE, SAP IQ, procedure, utility, iq utilities, user defined procedure, udf, capital letter, small letter , 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.