I was looking at the IB pdf data definition guide about generators,
and they say the following:

Generators return a 64-bit value. You should define the column that
holds the generated
value as an ISC_INT64 variable (DECIMAL or NUMERIC datatype).

In my case however, I have many columns that I will programmatically
limit to values MUCH smaller than I'd have to worry about with an
INT64. (e.x. 1000, etc). In this case, should I still use an INT64
for convention's sake, or would I better off using a SMALLINT in my
field and implicitly casting down from 64->16 bits?

Thanks,

Robby