User tried to insert a row following statement:
insert into VRAP.RCIT_RVRS_DUP_REF
(CLM_GID,EXTL_SRC_CD,NABP_ID,DSPN_DT,NEW_REFIL_CD,INSRT_DT,COB_PD_CD,CLM_TYP_CD,UQ_QTY,NDC_ID,RX_NB,CLM_LVL1_ID,CLM_LVL2_ID,EXTL_LVL1_ID)
values
(9469806479,'QLC','1304106','08/22/2006',0,current date,'1',1,30.0,17314585102,'000854216','1809543804','1','10136')
;
Â
An error came up:
Â
Error 05/13/2010 9:28:52 AM 0:00:00.000 DB2 Database Error: ERROR [22018] [IBM][DB2/AIX64] SQL0420N Invalid character found in a character string argument of the function "INTEGER". SQLSTATE=22018
Â
However, the same INSERT statement from the UNIX DB2 prompt against the same database, the insert works.
This table is defined on 24 partitions by range.