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
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.