Loading
Filed Under: DB2
Logical Operators in DB2
| Functionality | Operator |
| Logical AND | <condition 1> AND <condition 2> |
| Logical OR | <condition 1> OR <condition 2> |
| Logical NOT | NOT <condition> |
| Greater than | <value 1> > <value 2> |
| Less than | <value 1> < <value 2> |
| Greater than or equal to | <value 1> >= <value 2> |
| Less than or equal to | <value 1> <= <value 2> |
| Not Eqaul | <value 1> <> <value 2> |
| Between | <variable> BETWEEN <value 1> AND <value 2> |
Related Posts
- DIRECT YES and DIRECT NO options in BMC unload plus
- DB2 commands : TERM, START, STOP, DIS
- Embedded DB2 SQL in Easytrieve
- Using MAXASSIGNEDVAL from SYSIBM.SYSSEQUENCES (IBM DB2 for Z OS)
- Creating (Declaring), Inserting data into DB2 temporary tables
- Using IKJEFT01 for Binding a normal batch DB2 program
- Using IKJEFT01 for running a normal batch DB2 program
- Running DSNTIAUL using IKJEFT01 for batch unload
- Running DSNTEP2 / DSNTEP4 using IKJEFT01 for batch SQL(DB2) processing
There's 0 entry So Far
Leave your Feedback / Question here. Thanks!