The LAND function returns a string that is the logical 'AND' of the argument strings. This function takes the first argument string, does an AND operation with the next string, and then continues to do AND operations with each successive argument using the previous result. If a character-string or graphic-string argument is encountered that is shorter than the previous result, it is padded with blanks. If a binary-string argument is encountered that is shorter than the previous result, it is padded with hexadecimal zeros.
The arguments must be compatible.
The arguments are converted, if necessary, to the attributes of the result. The attributes of the result are determined as follows:
If an argument can be null, the result can be null; if an argument is null, the result is the null value.
The CCSID of the result is 65535.
SELECT LAND(:L1,:L2,:L3) FROM SYSIBM.SYSDUMMY1Returns the value X'A0B00040'.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.