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$>

"Troels Arvin" <> wrote in message [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.

Paul Vernon
Business Intelligence, IBM Global Services Received on Tue Apr 01 2003 - 16:38:07 CEST

Original text of this message