Below is a simple example with constants:
The number of columns must be equal and of compatible data types.
Statement provides the same result as
SELECT * FROM DEPTBL WHERE DEPT='Shipping' AND BRANCH='0012M'
Please note the parentheses usage in first example.
This saves some coding, but could look confusing in the beginning. It is just the matter of preferences.
Do write me @ iSeriesblogs@gmail.com for any query or you can simply post comments below.