Db2 udb does not have native support for bit or boolean data types , neither for bitwise operation nor for boolean algebra operations Db2 udb没有为位数据类型或布尔数据类型提供本机支持,它既不支持逐位操作,也不支持布尔代数操作。
If you re migrating to ibm db2 universal database from a database that supports bit and boolean operations and functions , you may be wondering how to handle these types and functions in db2 . our author offers a method that includes table creation with columns of the bit - like or boolean data types using constraints or triggers , and a set of user - defined functions to support bitwise and boolean operations that imitate bit or boolean data - type behavior 本文作者提出了一种方法,这个方法中包括使用约束条件或触发器创建的表,表中包含类似于位( bit - like )的数据类型的列或布尔数据类型的列;该方法还包含一组用户定义函数( udf ) ,用于支持模仿位数据或布尔数据类型的行为的逐位运算和布尔运算。
This article offers a method that includes table creation with columns of the bit - like or boolean data type , using constraints or triggers , and a set of user - defined functions udfs to support bitwise and boolean operations for columns that imitate bit or boolean data type behavior 本文将提供一种方法,该方法包括使用约束条件或触发器创建了一个表,表中包含类似于位( bit - like )或布尔数据类型的列;该方法还包括一组用户定义函数( udf ) ,用于支持模仿位数据或布尔数据类型的行为的逐位运算和布尔运算。
In computer science, the Boolean or logical data type is a data type, having two values (usually denoted true and false), intended to represent the truth values of logic and Boolean algebra. It is named after George Boole, who first defined an algebraic system of logic in the mid 19th century.