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" <firstname.lastname@example.org> 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.
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center