SQL keywords supported by the IMS JDBC drivers
The SQL support provided by the IMS Universal JDBC driver is based on the SQL-92 standard for relational database management systems.
If you use a SQL keyword as a name for a PCB, segment, or field, your JDBC application program will throw an error when it attempts an SQL query. These keywords are not case-sensitive.
The following SQL keywords are supported by the IMS JDBC drivers:
- ABS
- ACOS
- ALL
- ALTER
- AND
- AS
- ASC
- ASIN
- ATAN
- ATAN2
- AVG
- BETWEEN
- CEIL
- CEILING
- COS
- COSH
- COT
- COUNT
- CREATE
- DEGREES
- DELETE
- DESC
- DISTINCT
- DROP
- EXP
- FETCH
- FIRST
- FLOOR
- FROM
- GROUP BY
- INNER
- INSERT
- INTO
- JOIN
- LN
- LOG
- LOG10
- MAX
- MIN
- MOD
- NULL
- ON
- ONLY
- OR
- ORDER BY
- POWER
- RADIANS
- ROW
- ROWS
- SELECT
- SET
- SIGN
- SIN
- SINH
- SQRT
- SUM
- TAN
- TANH
- UPDATE
- VALUES
- WHERE