BOOLEAN column in DB2
How can I define a Boolean or Yes/No column when creating a DB2 table ? Please
Re: BOOLEAN column in DB2
"Faraw" <email@example.com> wrote:
>How can I define a Boolean or Yes/No column when creating a DB2 table ?
Actually you cannot have boolean in sql-92.
Use char(1) with constraint on the value or a check.
create table demotbl1
check (boolcolumn1 in ('Y', 'N'))
There are good books on SQL and BD2
(1) Understanding the new SQL: a complete guide by J. Milton
a must for SQL but not easy reading
(2) Books by CJ Date like A guide to the SQL standard.
(3) Books on DB2 by IBM.
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL