Voltar
-
Título
'SQL0420N Invalid character found in a character string argument of the function' -
Descrição
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.
Login necessário
é necessário estar conectado e ter um contrato de manutenção atual para visualizar os artigos de conhecimento premium.