THE USE OF NUMERIC SCALAR FUNCTIONS (LIKE ABS, COS, SIN, MOD,
POWER, ETC) PUSHING NUMERIC ARGUMENT TYPES (DECIMAL, FLOAT, ETC)
THROUGH A JOIN OR UNION MAY PRODUCE A FODC_APPERR DIRECTORY.
A -901 error may be observed in the db2diag.log file during
execution of queries that use numeric scalar functions (like
ABS, COS, SIN, MOD, POWER, etc). For a complete list of the
numeric scalar functions search the DB2 10.5 information center
for "Built-in functions".
An example of select using the ABS function is shown:
2014-06-13-17.42.14.166246-240 I43171A890 LEVEL:
Severe
PID : 7995792 TID : 71522 PROC :
db2sysc 0
INSTANCE: db2inst NODE : 000 DB :
SAMPLE
APPHDL : 0-37526 APPID: *N0.db2inst.140613213958
AUTHID : DB2INST HOSTNAME: hostname
EDUID : 71522 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc,
probe:300
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -901 sqlerrml: 28
sqlerrmc: Invalid operand type for ABS
sqlerrp : SQLRI007
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3)
0x00000000
(4) 0x00000000 (5) 0xFFFFFFCE (6)
0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: |
