Hi

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.

Thanks

Roger