On IBM AS400/iSeries/System i/IBM i - call it what you will - there is a distinction in the way a DECIMAL column is stored internally, and the way a NUMERIC column is stored. So although the external representation is the same (e.g. 12.34 is what would be displayed for either of a numeric(4,2) or a decimal(4,2) column) the internal representation, number of bytes used etc is different.
Squirrel at 3.3.0 generates the wrong 'Create table' entries for a NUMERIC column.
If I create my table:
CREATE TABLE sqtest
Goodcol decimal(12,5) DEFAULT 0 NOT NULL,
Badcol numeric (12,5) DEFAULT 0 NOT NULL
Then use Squirrel to generate a new create table script, I get:
CREATE TABLE SQTEST
GOODCOL decimal(12,5) DEFAULT 0 NOT NULL,
BADCOL bigint DEFAULT 0 NOT NULL
That is the NUMERIC column has been reported as BIGINT - definitely wrong!
I have tried this on I/OS versions 5.4, 6.1 and 7.1 - all are the same.
Log in to post a comment.