MX Release 3.2 (H06.25+, J06.14+)

ManualsBrandsHP ManualsServerHP Integrity NonStop J-Series

return 0;

}

Starting with SQL/MX Release 3.2, MFC supports parameterized queries with BIGNUM data type.

The following is a sample .sql file:

EXEC SQL MODULE "MFCABS1031CAT"."SCH"."B4FABF7702B9046B0E8F94FAC72E7027" NAMES A

RE ISO88591;

int main ()

{

EXEC SQL BEGIN DECLARE SECTION;

NUMERIC(56,20) param0;

short param0_ind = -1;

EXEC SQL END DECLARE SECTION ;

EXEC SQL CONTROL QUERY DEFAULT ODBC_PROCESS 'TRUE';

EXEC SQL CONTROL QUERY DEFAULT JDBC_PROCESS 'TRUE';

EXEC SQL CONTROL QUERY DEFAULT GENERATE_EXPLAIN 'ON';

EXEC SQL CONTROL QUERY DEFAULT NAMETYPE 'ANSI';

EXEC SQL CONTROL QUERY DEFAULT INFER_CHARSET 'ON';

EXEC SQL CONTROL QUERY DEFAULT RECOMPILATION_WARNINGS 'ON';

EXEC SQL DECLARE SCHEMA CAT.SCH ;

EXEC SQL SET SCHEMA CAT.SCH ;

EXEC SQL DECLARE MXSTMT01 CURSOR FOR SELECT * FROM MYTAB6 WHERE INFO = :param0 ;

return 0;

}

Disk Activity

The MFC access plans are stored in the disk OSH location as specified in the attribute

compiled_module_location. For more information on setting this attribute, see “Configuring

MFC from the MXCS mode” (page 49). Assume that the value for the attribute is /usr/mymodules.

If specifying this location attribute causes an increase in the processor utilization of disks, then to

overcome this problem, use the fileset setting for that directory. It is beneficial to have OSS caching

enabled on data volumes. To enable fileset and OSS caching, see “Enable Fileset and OSS

Caching” (page 53).

NOTE: If the table is altered using data definition language (DDL) or if it is dropped, run the

management script (mgscript) to delete module files associated with that table or catalog. For

information on management script, see “Managing MFC” (page 50).

Enable Fileset and OSS Caching

To add a fileset pointing to a value in the compiled_module_location directory, complete

the following steps:

1. At a TACL prompt, enter:

SCF

and then enter:

assume $zpmon

2. At an SCF prompt, enter the SCF command:

add server <SERVER_NAME>, cpu 1, backupcpu 2

3. Add a fileset:

add fileset mxc1,nameserver #(server name),catalog $(volume other

than $oss), pool mxc1pool, mntpoint "/usr/mymodules"

NOTE: Copy the ‘POOL’ template file located in the $SYSTEM.ZXOSSMON volume and

modify the default volume setting to point to the location of the newly defined fileset mountpoint.

Module File Caching (MFC) 53