TSO-ISPF JCL COBOL VSAM DB2 CICS Tools Articles Job Portal Forum Quiz Interview Q&A

DB2 - SQL Operators


SQL Arithmetic Operators:

OperatorDescription
+Addition
-Subtraction
*Multiplication
/Division
% Modulo


SQL Comparsion Operators:

OperatorDescription
=Equal to
>Greater than
<Less than
>=Greater than or equal to
<=Less than or equal to
<>Not equal to


SQL Logical Operators:

OperatorDescription
ORTRUE if any of the conditions separated by OR is TRUE
ANDTRUE if all the conditions separated by AND is TRUE
ANYTRUE if any of the subquery values meet the condition
BETWEENTRUE if the operand is within the range of comparisons
EXISTS TRUE if the subquery returns one or more records
INTRUE if the operand is equal to one of a list of expressions
LIKETRUE if the operand matches a pattern
NOT Displays a record if the condition(s) is NOT TRUE
ALLTRUE if all of the subquery values meet the condition
SOMETRUE if any of the subquery values meet the condition


If you have any doubts or queries related to this chapter, get them clarified from our Mainframe experts on ibmmainframer Community!

Are you looking for Job Change? Job Portal