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_at_sp15at20.hursley.ibm.com>
Date: Tue, 1 Apr 2003 15:38:07 +0100
Message-ID: <b6c8bt$qdg$1_at_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 - 16:38:07 CEST