Overview


This document describes how to check the contents of the stored procedure.

 

Version


All the versions of ALTIBASE HDB

 

How to check


There are two ways to check the contents of the stored procedure.

 

Using meta table


After creating a user-defined procedure using the meta tables SYSTEM_.SYS_PROCEDURES_, SYSTEM_.SYS_PROC_PARSE_, use this to check the contents of the stored procedure.

How to create a custom procedure

How to Execute user-defined stored procedure

Using the aexport utility


aexport is a utility that saves database object creation statements to a file. After performing aexport, the contents of the stored procedure can be checked in the created file.

Execute aexport - all objects

Execute aexport for each user

Execute aexport for each object