At 7.2 I can do this:
values int(zoned(-1))

And I can do:
CREATE TABLE QTEMP.TEMP (
MYZONED NUMERIC (5 , 2) NOT NULL WITH DEFAULT)

INSERT INTO QTEMP.TEMP (MYZONED) VALUES(-1) WITH NC

INSERT INTO QTEMP.TEMP (MYZONED) VALUES(-1.2) WITH NC

SELECT INT(MYZONED) FROM QTEMP.TEMP


Rob Berendt

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].