Re: The BOOLEAN data type

From: Paul Vernon <paul.vernon_at_ukk.ibmm.comm>
Date: Tue, 1 Apr 2003 15:38:07 +0100
Message-ID: <b6c8bt$qdg$1@sp15at20.hursley.ibm.com>

"Troels Arvin" <troels_at_arvin.dk> wrote in message news:pan.2003.04.01.14.00.42.519742_at_arvin.dk... [snip]
>
> I wonder if DB2 supports the boolean or bit types.

Not externally:

C:\SQLLIB\BIN>db2 create table bool(b boolean not null primary key)

SQL0486N The BOOLEAN data type is currently only supported internally. SQLSTATE=42991 And we don't have a BIT type. Have to use CHAR(1) or maybe DECIMAL(1,0) plus CHECK constraints to simulate BOOLEAN.

Regards
Paul Vernon
Business Intelligence, IBM Global Services Received on Tue Apr 01 2003 - 08:38:07 CST