BOOLEAN column in DB2

[Faraw]

How can I define a Boolean or Yes/No column when creating a DB2 table ? Please
help.

[J. Lemire]

"Faraw" <betemariam@hotmail.com> wrote:
>
>How can I define a Boolean or Yes/No column when creating a DB2 table ?
Please
>help.

GOOD question!

Actually you cannot have boolean in sql-92.

Use char(1) with constraint on the value or a check.

Example:

create table demotbl1
(boolcolumn1 char(1)
...
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.
very informative

(3) Books on DB2 by IBM.