

Limitations › DQL Mode Limitations › Syntax Limitations › WITH Limitations
WITH Limitations
Following are important limitations to observe in constructing WITH clauses. Also see DQL Mode Nesting Limitations.
- Two columns or keys that are not the same type cannot be compared.
- Columns that are greater than 240 characters in length cannot be used in a WITH clause or in a SET statement in an INSERT or UPDATE query.
- The maximum number of literal values per WITH statement is 15.
- Columns used in a WITH clause as part of an arithmetic expression cannot be qualified.
- The maximum number of OR entries in a WITH statement is 15. (That is, a maximum of 14 ORs are allowed.)
- Values following an EQ (=) or NE (,=) cannot be separated by AND or OR.
- SQL DATE, TIME and TIMESTAMP cannot be used with DQL SET, SORT and WITH.
- A numeric column whose value can be zero should not be used as a divisor in a SET statement or an arithmetic expression.
- The maximum numeric precision is 18 digits.
- An arithmetic expression cannot have more than five levels of nested parentheses.
Copyright © 2014 CA.
All rights reserved.
 
|
|