News
Abstract
With the addition of Boolean, Db2 for i supports the concept of true or false within the database and the applications that derive answers to business-critical questions.
Content
You are in: IBM i Technology Updates > Db2 for i - Technology Updates > Db2 for i Functional Enhancements > Boolean support added to SQL
The addition of Boolean to SQL within Db2 for i touches many aspects of the database and SQL support.
With this additional capability, some of the things Db2 for i clients can do will include:
- Establish queries that include true or false as part of the predication, or as part of the query result
- Establish column(s) within SQL tables with the data type of BOOLEAN
- Use SQL to transform and interpret an existing non-BOOLEAN column as BOOLEAN
- Shred and publish JSON or XML documents that include Boolean data
- Simplify code that has been tasked at managing true and false data via non-Boolean data types
See the SQL Reference for details:
Additional background on this new Boolean support:
[{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z0000000CHeAAM","label":"IBM i Db2"}],"ARM Case Number":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.5.0;and future releases"}]
Was this topic helpful?
Document Information
Modified date:
29 March 2023
UID
ibm16575531