No Check Temp-table Names (-nochkttnames)

Use the No Check Temp-Table Names (-nochkttnames) parameter to suppress the limited checking of temp-table column names when passing temp-table as parameters to procedures.

Operating system and syntax	UNIX / Windows	-nochkttnames
Use with	Maximum value	Minimum value	Single-user default	Multi-user default
Client Session	—	—	—	—

When passing temp-table as a parameter to a procedure, the calling procedure's temp-table and the called procedure's temp-table must match with respect to the number of columns, the data type of each column, and the number of extents of each column (for columns with extents).

The AVM provides limited checking of temp-table column names when passing temp-tables as parameters to procedures. That is, for any given column:

If the name of a column in the calling procedure's temp-table does not match any column defined in the called procedure's temp-table, the AVM processes the column.

If the name and position of a column in the calling procedure's temp-table matches a column defined in the called procedure's temp-table, the AVM processes the column.

If the name of a column in the calling procedure's temp-table matches a column defined in the called procedure's temp-table, but the positions do not match, the AVM reports an error and the called procedure does not run.

Use the No Check Temp-table Names (-nochkttnames) parameter when you want the AVM to process the temp-table without verifying column names.

Note: Temp-table column names are case-insensitive.