SAP Knowledge Base Article - Preview

2932207 - SYSPROCEDURE proc_defn gets populated incorrectly - SAP IQ

Symptom

SQL batch consist of certain sequence.
create procedure .. ; grant .. , select proc_defn from SYSPROCEDURE ..

This batch can be read in dbisql OR executed through -nogui clause.

In IQ 16.0, proc_defn is populated correctly with just stored procedure definition whereas in IQ 16.1 all statements appear which is not correct.


Read more...

Environment

IQ 16.1  sp03

IQ 16.1  sp04

Product

SAP IQ 16.0

Keywords

KBA , BC-SYB-IQ , Sybase IQ , 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.