fieldNum

An integer that specifies the position of the field to retrieve from the fetched record.

fieldType

A short integer that specifies the data type of the parameter. The allowable defined values for fieldType are listed in the table below, grouped by category of data type.

Table 1. Allowable values for fieldType in getValue
Character Exact numeric Approximate numeric Date‑time Bit string
CHAR INTEGER REAL DATE BIT
CHARACTER SMALLINT FLOAT TIME BINARY
VARCHAR TINYINT DOUBLE TIMESTAMP VARBINARY
— NUMERIC — — LVARBINARY
— DECIMAL — — —