Home
Extending Informix®Beyond standard relational database objects, HCL Informix® can be extended to handle specialized data types, access methods, routines, and other objects. Informix® includes many built-in extensions that are fully integrated in the database server. Informix® also provides DataBlade® modules, which are packages of extended database objects for a particular purpose and that are installed separately from the database server. Alternatively, you can create your own user-defined objects for Informix®.
Creating extensionsYou can create user-defined data types, routines, access methods, and other database objects to suit your needs. You can use application programming interfaces to write user-defined routines and applications that access data in Informix® databases.
User-Defined Routines and Data Types Developer's GuideThe Informix® User-Defined Routines and Data Types Developer's Guide describes how to define new data types and enable user-defined routines (UDRs) to extend HCL Informix®.
Improve UDR performance
Extend UPDATE STATISTICS
Support functions for UPDATE STATISTICS
The statprint() function

The statprint() function

The statprint() function converts the statistics data that the statcollect() function collects to an LVARCHAR value that the database server can use to display information. The dbschema utility executes the statprint() function.

The statprint() function has two arguments. The first argument is a placeholder argument of the required data type. The database server uses this argument to resolve the function. The first time the database server executes this function, it sets the first parameter to null.

The second argument is a value of the stat data type. The stat data type is a multi-representational data type that the database server uses to store data that the statcollect() function collects.

The statprint() function must take the histogram, which is stored in multirepresentational form, and convert it to a printable form.

After you register the functions, make sure those with DBA privilege or the table owner can execute the statcollect() and statprint() UDRs.

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.