Preface
Introduction to PowerExchange
- PowerExchange Overview
- PowerExchange Components
DBMOVER Configuration File
Netport Jobs
PowerExchange Message Logs and Destination Overrides
- PowerExchange Message Logs
  - PowerExchange Message Log File
  - PowerExchange Alternative Log Files
    - Determining the Size of the Alternative Log Data Sets on z/OS
    - Allocation Options for Alternative Log Data Sets on z/OS
- PowerExchange Message Destination Overrides
  - DTLMSGO File and Statements
SMF Statistics Logging and Reporting
PowerExchange Security
Secure Sockets Layer Support
PowerExchange Alternative Network Security
PowerExchange Nonrelational SQL
DTLDESCRIBE Metadata
- DTLDESCRIBE Metadata Overview
  - DTLDESCRIBE Metadata Syntax
  - DTLDESCRIBE Qualifiers
PowerExchange Globalization
Using the PowerExchange ODBC Drivers
PowerExchange Datatypes and Conversion Matrix
- PowerExchange Datatype Conversions
- ODBC and PowerExchange Datatype Equivalencies
Appendix A: DTL__CAPXTIMESTAMP Time Stamps
- Time Stamps That Are Reported in the DTL__CAPXTIMESTAMP Field by Data Source
Appendix B: PowerExchange Glossary
- Glossary of Terms

Reference Manual

10.5.4
- 10.5.6
- 10.5.5
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

BETWEEN Comparison

This comparison is testing a column for being falling in side or outside (used with NOT) a range of values.

Example:

col1 [NOT] BETWEEN   valueA AND valueB

In this example valueA and valueB could be another column or a constant of the same type as the column being compared against. It is equivalent to coding two simple conditions as follows:

[NOT] (col1 >= valueA AND col1 <= valueB)

Rename Saved Search

Table of Contents

Reference Manual

Reference Manual

BETWEEN Comparison

BETWEEN Comparison