Getting OBBC error while trying to insert record into Image/Sql database.
All Image fields are Xn (Char type) except
 WIDTH = Z6 (Sql value= 000.00);  LENGTH = Z4 (Sql value= 0);
 LBS_INV_TRAN = Z6 (Sql value= 0); QTY_INV_TRAN = Z6 (Sql value= 0);
 COUNT_INV_TRAN = Z2 (Sql value= 01).
Anyone know which fields are causing the problem?

Error: -2147467259.
Desc: [ODBCLINK Host][Allbase]Incompatible data types INTEGER and CHAR in
expression.  (DBERR 2609).
Location: ProcessSQL in modODBCCommunication.
HPSQL string (single quotes replaced with double quotes):
INSERT INTO CBSI.WCS_INV_TRAN_DTL (BPI, PKG_CODE, QUAL_CODE, WGT_CLS_CD,
  MKT_VAR_CD, PRD_VAR_CD, WIDTH, LENGTH, NFS, STK_LOC_CD,
TRAN_CODE, LBS_INV_TRAN,
  QTY_INV_TRAN, UNIT_OF_MEASURE, COUNT_INV_TRAN,
TIME_INV_TRAN, DATE_INV_TRAN,
  CONTAINER_NUMBER, FLANGE_NUMBER, SET_NUMBER, IC_PROCESS,
BILL_NUMBER, TIME_ENTERED, DATE_ADDED,
  MFFLAG, MFTRAN, MFBPI, MFPKG, MFQUAL, MFDEPT, MFPARENT_BPI,
MFPARENT_DEPT, MFNWT, FILLER)
 VALUES ('016187', '447', '3', 'A04', '   0', '  36', 000.00, 0, ' ',
    '251', 0, 0, 0, 'LB  ', 01,
    1038,
20001213, '00800033', '00000000', '0000', '  ', '        ',
0, '        ', ' ', '00',
    '016187', '447', '3', '350',
    '      ', '   ', 0, ' ')