New functions added to assist with Boolean data type Simon Hutchinson

​The Boolean data type was introduced as part of IBM i 7.5, and does not work for lower releases. With the last couple of Technology Releases, TRs, a number of SQL functions have been added to make using the Boolean data type easier. These are: BOOLEAN:  Returns Boolean value for parameter ISTRUE:  Returns “true” if the parameter is Boolean true, and if not returns “false” or null ISFALSE:  Returns “true” if the parameter is Boolean false, and “false” or null if it is not ISNOTTRUE:  Returns “true” if the parameter is not Boolean true, and returns “false” or null if not ISNOTFALSE:  Returns “true” if the parameter is not Boolean false, and if not then “false” or null Read more » Read More