IBM Informix Guide to SQL: Syntax
Introduction
Overview of SQL Syntax
SQL Statements
SPL Statements
Data Types and Expressions
In This Chapter
Scope of Segment Descriptions
Use of Segment Descriptions
Collection Subquery
Condition
Data Type
DATETIME Field Qualifier
Expression
Rules for the Target Data Type
Examples of Cast Expressions
The Keyword NULL in Cast Expressions
Using Dot Notation
Using Subscripts on Character Columns
Using Rowids (IDS)
Using Smart Large Objects (IDS)
CASE Expressions
NVL Function
DECODE Function
Quoted String
Literal Number
USER Operator
CURRENT_ROLE Operator
DEFAULT_ROLE Operator
DBSERVERNAME and SITENAME Operators
TODAY Operator
CURRENT Operator
Non-default Time Zones for CURRENT or TODAY (XPS)
Literal DATETIME
Literal INTERVAL
UNITS Operator
NEXTVAL and CURRVAL Operators (IDS)
Literal Row (IDS)
Literal Collection (IDS)
ROW Constructors
Collection Constructors
Algebraic Functions
CARDINALITY Function (IDS)
DBINFO Function
Encryption and Decryption Functions
DECRYPT_CHAR Function
DECRYPT_BINARY Function
ENCRYPT_AES Function
ENCRYPT_TDES Function
GETHINT Function
Exponential and Logarithmic Functions
HEX Function
Length Functions
IFX_REPLACE_MODULE Function (IDS, C)
Smart-Large-Object Functions (IDS)
Time Functions
Trigonometric Functions
String-Manipulation Functions
Case-Conversion Functions
IFX_ALLOW_NEWLINE Function
User-Defined Functions
Types of Aggregate Expressions
Subset of Expressions Valid in an Aggregate Expression
Including or Excluding Duplicates in the Row Set
AVG Function
Overview of COUNT Functions
COUNT(*) Function
COUNT DISTINCT and COUNT UNIQUE Functions
COUNT column Function
Comparison of the Different COUNT Functions
MAX Function
MIN Function
SUM Function
RANGE Function
STDEV Function
VARIANCE Function
Error Checking in ESQL/C
Summary of Aggregate Function Behavior
User-Defined Aggregates (IDS)
INTERVAL Field Qualifier
Literal Collection
Literal DATETIME
Literal INTERVAL
Literal Number
Literal Row
Quoted String
Relational Operator
Other Syntax Segments
Appendix A. Reserved Words for IBM Informix Dynamic Server
Appendix B. Reserved Words for IBM Informix Extended Parallel Server
Appendix C. Accessibility
Notices
Index
Introduction
