IDAX.DROP_SUMMARY1000 - Drop output tables created by SUMMARY1000

Use this stored procedure to drop all the output tables that are created by the SUMMARY1000 stored procedure.

Authorization

The privileges held by the authorization ID of the statement must include the IDAX_USER role.

Syntax

IDAX.DROP_SUMMARY1000(in parameter_string varchar(32672))

Details

When you call the SUMMARY1000 stored procedure, the outtable parameter is specified, for example, outtable=<tbname>.

The SUMMARY1000 stored procedure then creates the <tbname> table and depending on the type of its input table columns, one or several of the following tables:

<tbname>_char
<tbname>_num
<tbname>_date
<tbname>_time
<tbname>_timestamp

When you call DROP_SUMMARY('intable=<tbname>'), all these tables are dropped.

Parameter descriptions

parameter_string

Mandatory one-string parameter that contains pairs of <parameter>=<value> entries that are separated by a comma.

Data type: VARCHAR(32672)

The following list shows the parameter values:

intable: Mandatory.; The table that is specified in the outtable parameter of the SUMMARY1000 stored procedure.; Data type: VARCHAR(ANY)

Returned information

INTEGER the number of tables that are deleted.

Example

CALL IDAX.DROP_SUMMARY1000('intable=ORDER_HEADER_SUM1000');