All,
When running this code,

TABLE FILE LOG_TABLE
SUM
    BYTES_SENT
    BYTES_RECEIVED
BY USER_ID
WHERE ( LOG_DETAILS.LOG_DETAILS.DATE_TIME GT DT(2010-11-01 12:00:00) )
  AND ( LOG_DETAILS.LOG_DETAILS.DATE_TIME LE DT(2010-11-10 23:59:59) )
WHERE READLIMIT EQ 100000
END
  

I get the following error:

 
(FOC1400) SQLCODE IS 8115 (HEX: 00001FB3) XOPEN: S0002
 :  (8115) [S0002] Arithmetic overflow error converting expression to data
 : type int.
 (FOC1407) SQL FETCH CURSOR ERROR.  : LOG_DETAILS 

Does anyone know what causes this?

Thank you,

Seyed

This message has been edited. Last edited by: Kerry,

Date fields are alpha format. You are trying to compare your DATE_TIME field to a numeric. Make sure you only compare alpha to alpha and numeric to numeric.

Thank you for the reply. I thought that perhaps, summing up the two columns was causing overflow. I am going to work on converting the numeric fields to date and then give it a try.

Thanks again,


Seyed