Enterprise Edition Home | Express Edition Home | Previous Page | Next Page  

Data Types and Expressions

In This Chapter
Scope of Segment Descriptions
Use of Segment Descriptions
Collection Subquery
Condition
Comparison Conditions (Boolean Expressions)
Column Name
Quotation Marks in Conditions
Relational-Operator Condition
BETWEEN Condition
IN Condition
Using the IN Operator with Collection Data Types (IDS)
IS NULL Condition
LIKE and MATCHES Condition
NOT Operator
LIKE Operator
MATCHES Operator
ESCAPE with LIKE
ESCAPE with MATCHES
Stand-Alone Condition
IN Subquery
EXISTS Subquery
ALL, ANY, and SOME Subqueries
Using the ALL Keyword
Using the ANY or SOME Keywords
Omitting the ANY, ALL, or SOME Keywords
Data Type
BOOLEAN and Other Built-In Opaque Data Types (IDS)
Character Data Types
Single-Byte and Multi-Byte Characters and Locales
Fixed- and Varying-Length Character Data Types
NCHAR and NVARCHAR Data Types
Numeric Data Types
Exact Numeric Data Types
Approximate Numeric Data Types
Large-Object Data Types
Simple-Large-Object Data Types
Storing BYTE and TEXT Data
Smart-Large-Object Data Types (IDS)
Time Data Types
Distinct Data Types
Opaque Data Types
ROW Data Types
Collection Data Types
Defining the Element Type
DATETIME Field Qualifier
Expression
Rules for the Target Data Type
Examples of Cast Expressions
The Keyword NULL in Cast Expressions
Using Dot Notation
Selecting All Fields of a Column with Asterisk Notation
Selecting Nested Fields
Rules of Precedence
Using Dot Notation with Row-Type Expressions
Using Subscripts on Character Columns
Using Rowids (IDS)
Using Smart Large Objects (IDS)
CASE Expressions
Generic CASE Expressions
Linear CASE Expressions (IDS)
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)
Using NEXTVAL
Using CURRVAL
Concurrent Access to a Sequence
Restrictions
Examples
Literal Row (IDS)
Literal Collection (IDS)
ROW Constructors
Collection Constructors
Examples of Collection Constructors
Algebraic Functions
ABS Function
MOD Function
POW Function
ROOT Function
ROUND Function
SQRT Function
TRUNC Function
CARDINALITY Function (IDS)
DBINFO Function
DBINFO Options
Using the 'dbspace' Option Followed by a Tblspace Number
Using the 'sqlca.sqlerrd1' Option
Using the 'sqlca.sqlerrd2' Option
Using the 'sessionid' Option
Using the 'dbhostname' Option
Using the 'version' Option
Using the 'serial8' Option
Using the 'coserverid' Option with No Other Arguments (XPS)
Using the 'coserverid' Option Followed by Table and Column Names (XPS)
Using the 'dbspace' Option Followed by Table and Column Names (XPS)
Encryption and Decryption Functions
Column Level and Cell Level Encryption
The Password and Hint Specifications
Data Types, Encoding, and Size of Encrypted Values
Example of Column Level Encryption
DECRYPT_CHAR Function
DECRYPT_BINARY Function
ENCRYPT_AES Function
ENCRYPT_TDES Function
GETHINT Function
Exponential and Logarithmic Functions
EXP Function
LOG10 Function
LOGN Function
HEX Function
Length Functions
The LENGTH Function
The OCTET_LENGTH Function
The CHAR_LENGTH Function
IFX_REPLACE_MODULE Function (IDS, C)
Smart-Large-Object Functions (IDS)
FILETOBLOB and FILETOCLOB Functions
Pathnames with Commas
LOTOFILE Function
LOCOPY Function
Time Functions
DATE Function
DAY Function
MONTH Function
WEEKDAY Function
YEAR Function
EXTEND Function
MDY Function
TO_CHAR Function (IDS)
TO_DATE Function (IDS)
Trigonometric Functions
Formulas for Radian Expressions
COS Function
SIN Function
TAN Function
ACOS Function
ASIN Function
ATAN Function
ATAN2 Function
String-Manipulation Functions
TRIM Function
SUBSTRING Function
SUBSTR Function
REPLACE Function
LPAD Function
RPAD Function
Case-Conversion Functions
UPPER Function
LOWER Function
INITCAP Function
IFX_ALLOW_NEWLINE Function
User-Defined Functions
Statement-Local Variable Declaration (IDS)
Types of Aggregate Expressions
Built-in Aggregates
User-Defined Aggregates
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
Examples of the COUNT(*) Function
Examples of the COUNT DISTINCT Function
Examples of the COUNT column Function
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
Element Literal Value
Nested Quotation Marks
Literal DATETIME
Casting Numeric Date and Time Strings to DATE Data Types
Literal INTERVAL
Literal Number
Integer Literals
Fixed-Point Decimal Literals
Floating-Point Decimal Literals
Literal Numbers and the MONEY Data Type
Literal Row
Literals of an Unnamed Row Type
Literals of a Named Row Type
Literals for Nested Rows
Quoted String
Restrictions on Specifying Characters in Quoted Strings
The DELIMIDENT Environment Variable
Newline Characters in Quoted Strings
Using Quotes in Strings
DATETIME and INTERVAL Values as Strings
LIKE and MATCHES in a Condition
Inserting Values as Quoted Strings
Relational Operator
Using Operator Functions in Place of Relational Operators
Collating Order for U.S. English Data
Support for ASCII Characters in Nondefault Code Sets (GLS)
Literal Numbers as Operands
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]