I'm in the process of using "FireBird Maestro" and the following query to
move data from one massive table into much smaller individual tables.

In this case, the SSN field in both tables is CHAR (9)
The other two "source" fields are TIMESTAMP as are the DESTINATION fields.

INSERT INTO VARIVAX (SSN,D1,D2)
SELECT
PUBLIC_TBL_EMP1.SSN,
PUBLIC_TBL_EMP1.VARIVAX1_D,
PUBLIC_TBL_EMP1.VARIVAX2_D
FROM
PUBLIC_TBL_EMP1
WHERE
PUBLIC_TBL_EMP1.SSN IS NOT NULL AND
PUBLIC_TBL_EMP1.VARIVAX1_D IS NOT NULL

After attempting to execute this query, I get the following error :


Engine Error (code = 335544321):
arithmetic exception, numeric overflow, or string truncation.
unknown ISC error 335544914.

SQL Error (code = -802):
Arithmetic overflow or division by zero has occurred.


Would you please help me understand what is causing this error so that if
possible, I can correct it.

Respectfully yours,
Allan


[Non-text portions of this message have been removed]