Options for Routines

Home | Previous Page | Next Page Programming Guidelines > Programming Language Options >

Options for Routines

If you choose to program your user-defined routines in C, you can choose any of the routine options available in BladeSmith. For a description of these options, see Creating Routines.

When you implement a routine in Java, you cannot specify the following options:

That it has a selectivity function or is a selectivity function
That it takes row data types or collection data types as arguments
That it is internal
Its stack size
Its cost
That it has a commutator function or is a commutator function

Tip:

You can also choose to implement routines in IBM Informix Stored Procedure Language (SPL). See Creating Routines for more information.

Overloading Routines in Different Languages

You can overload routines to handle different data types in either C or Java. You cannot, however, overload a routine in a different language with the same data type. For example, you can create the following two functions:

MyFunction(lvarchar) written in C
MyFunction(int) written in Java

However, you cannot create the following two functions:

MyFunction(lvarchar) written in C
MyFunction(lvarchar) written in Java