Download Informix Web DataBlade Module Application Developer`s Guide

Creating a UDR Tag
4.
Click Continue.
APB populates the AppPage with UDR information from the sysprocedures table. You cannot update some of the text boxes, such as
Param Types, Routine Type, Owner, and Location.
5.
If you want to change the name of the UDR tag to be different from
its corresponding UDR, enter the new name in the Routine ID text
box.
6.
Enter the class in the Class text box.
For information on the class, see the table describing the WebUdrs
system table on page 10-5.
7.
Enter the list of parameters to the UDR tag.
For information on specifying parameters, see the table describing
the WebUdrs system table on page 10-5.
8.
Enter a description of the UDR in the Description text box.
9.
Click Save.
APB inserts the reference to the UDR into the WebUdrs table.
APB manages only the contents of the WebUdrs table, not the contents of the
sysprocedures table. When you delete a reference to a UDR from the
WebUdrs table, you do not also delete the corresponding UDR in the syspro-
cedures table.
If you drop and re-create a UDR with the DROP ROUTINE, CREATE
FUNCTION, and CREATE PROCEDURE SQL statements, the new UDR in the
sysprocedures table has a new procid different from the procid of the
reference to the UDR in the WebUdrs system table. APB shows this inconsistency by placing an asterisk before the UDR.
To bring the WebUdrs table up to date, use APB to delete the reference to the
UDR from the WebUdrs table and then use APB to re-insert the reference with
the new procid.
10-10
Informix Web DataBlade Module Application Developer’s Guide