Home |
Previous Page
Special characters
Numerics
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
Special characters
- [ ] (brackets)
- * (asterisk), wildcard of MATCHES operator
- @ (at sign)
- ^ (caret), wildcard in MATCHES clause
- - (minus sign), wildcard in MATCHES clause
- % (percent)
- ? (question mark), wildcard of MATCHES operator
- _ (underscore), wildcard of LIKE operator
- .c_ file extension
- .c file extension
(1), (2)
- .cm file extension
(1), (2)
- .cmo file extension
- .cv file extension
(1), (2), (3)
- .cvo file extension
(1), (2)
- .ec file extension
(1), (2)
- .iem file extension
- .lc file extension
(1), (2), (3), (4)
- .lco file extension
(1), (2)
- .o file extension
Numerics
A
B
C
- C compiler
- Cast
- CC8BITLEVEL environment variable
(1), (2), (3), (4)
- CHAR data type
- CHAR_LENGTH function
- Character
- Character data
- CHARACTER_LENGTH function
- Character-mapping files
- Character set
(1), (2)
- Chinese locale
- chkenv utility
- Chunk
- Client application
- checking a connection
(1), (2), (3)
- code-set conversion
(1), (2)
- definition of
- end-user formats
- establishing a connection
- opening another database
(1), (2)
- requesting a connection
(1), (2)
- sending client locale to server
(1), (2)
- setting a locale
(1), (2), (3)
- support for locales
(1), (2)
- uses of client locale
(1), (2)
- verifying locales
- Client code set
(1), (2), (3), (4)
- Client computer
- Client locale
- CLIENT_LOCALE environment variable
- default value
- ESQL filenames
- ESQL source code
- example of locale name
- interpreting command-line arguments
- location of message files
- precedence of
(1), (2), (3), (4), (5), (6), (7), (8), (9)
- role in code-set conversion
(1), (2)
- role in exception messages
- sending to database server
- setting
- syntax
- with TEXT data
(1), (2), (3), (4), (5)
- with utilities
- Client/server environment
- cmZ.txt file
- Code, sample, conventions for
- Code point
(1), (2), (3)
- Code set
- 1252
- 8859-1
(1), (2), (3)
- affecting filenames
- ASCII
(1), (2)
- character classes
- client code set
- code points
(1), (2)
- compatible
- condensed name
(1), (2), (3), (4)
- convertible
(1), (2), (3)
- database code set
- default
(1), (2), (3), (4)
- definition of
- determining
(1), (2)
- for client applications
(1), (2)
- for database
(1), (2)
- for database server
(1), (2)
- GB18030-2000
- in locale name
(1), (2), (3), (4)
- incompatible
- multibyte
(1), (2), (3), (4), (5)
- server code set
- single-byte
(1), (2), (3), (4)
- source
(1), (2)
- target
(1), (2)
- UTF-8
- wide-character form
- Code-set conversion
- Code-set-conversion file
- Code-set file
- Collation
- COLLATION locale category
- Collation order
- code-set
(1), (2), (3), (4)
- localized
(1), (2), (3), (4), (5), (6), (7), (8)
- tasks affected by
- types of
- Column (database)
- Command-line
- Command-line conventions
- Comment indicators
- Comments
(1), (2), (3), (4)
- Compliance
- Conditions
- Configuration parameters
- CONNECT statement
- Constraint
(1), (2), (3)
- Contact information
- Conventions
- Conversion functions
- Conversion modifier
(1), (2), (3)
- Converting data types
- CREATE CAST statement
- CREATE DATABASE statement
(1), (2)
- CREATE DISTINCT TYPE statement
- CREATE EXTERNAL TABLE statement
- CREATE FUNCTION statement
- CREATE INDEX statement
(1), (2), (3), (4)
- CREATE OPAQUE TYPE statement
- CREATE OPCLASS statement
- CREATE PROCEDURE statement
(1), (2), (3), (4)
- CREATE ROLE statement
- CREATE ROW TYPE statement
- CREATE SEQUENCE statement
- CREATE SYNONYM statement
- CREATE TABLE statement
- CREATE TRIGGER statement
(1), (2)
- CREATE VIEW statement
(1), (2)
- CTYPE locale category
- Currency notation
(1), (2), (3)
- Currency symbol
(1), (2), (3), (4), (5)
- Current processing locale
(1), (2)
- Cursor
(1), (2), (3), (4), (5), (6), (7)
- cvY.txt file
- Cyrillic alphabet
D
- Data
- Data definition language (DDL)
- Data type
- BLOB
- BYTE
- CHAR
(1), (2)
- character
- CLOB
- code-set conversion of
- collation order of
- complex
- DATE
- DATETIME
- DECIMAL
- distinct
- FLOAT
- INTEGER
- internal format
- locale-sensitive
(1), (2), (3), (4), (5)
- locator structure
- LVARCHAR
(1), (2)
- NCHAR
(1), (2), (3), (4), (5)
- numeric
- NVARCHAR
(1), (2), (3), (4)
- opaque
(1), (2), (3)
- SMALLFLOAT
- SMALLINT
- TEXT
(1), (2)
- VARCHAR
(1), (2)
- Database
- Database code set
(1), (2), (3), (4)
- Database locale
- Database objects
- Database server
- Database server connection
- DataBlade Developers Kit (DBDK)
- Date data
- DATE data type
- DATETIME data type
- DB-Access utility
(1), (2), (3)
- DB_LOCALE environment variable
- DBCENTURY environment variable
- DBDATE environment variable
- dbexport utility
(1), (2), (3), (4)
- dbimport utility
(1), (2)
- DBLANG environment variable
(1), (2)
- dbload utility
- DBMONEY environment variable
- DBNLS environment variable
(1), (2), (3)
- dbschema utility
- DBTIME environment variable
- DECIMAL data type
(1), (2)
- Decimal separator
(1), (2), (3), (4), (5), (6), (7)
- DECLARE statement
- Default locale
- DELETE statement
- DELIMIDENT environment variable
(1), (2)
- Delimiter, in BYTE and TEXT data
- Demonstration databases
- Dependencies, software
- DESCRIBE statement
- Diagnostic file
(1), (2)
- Distinct data type
- Documentation, types of
- Documentation conventions
- Documentation Notes
- Dollar ($) sign
- Double ( " ) quotes
- dtcvfmasc() library function
- dttofmtasc() library function
- DUMP* configuration parameters
E
- Embedded special characters
- en_us.8859-1 locale
- End-user format
- conversion modifier
(1), (2)
- customizing
- date data
(1), (2), (3), (4), (5), (6), (7), (8)
- date format qualifiers
- default
(1), (2)
- definition of
(1), (2), (3)
- environment variables
- extended DATE-format strings
- extended DATETIME format strings
- formatting data
(1), (2)
- locale categories
- monetary data
(1), (2), (3), (4), (5), (6)
- numeric data
(1), (2), (3), (4)
- printing
(1), (2), (3), (4)
- scanning
(1), (2), (3)
- sending to database server
(1), (2)
- time data
(1), (2), (3), (4), (5)
- time format qualifiers
- English locale
(1), (2)
- Environment variable
- CC8BITLEVEL
(1), (2)
- CLIENT_LOCALE
(1), (2)
- DB_LOCALE
(1), (2)
- DBCENTURY
- DBDATE
- DBLANG
(1), (2)
- DBMONEY
- DBNLS
(1), (2)
- DBTIME
- DELIMIDENT
(1), (2)
- ESQLMF
(1), (2)
- for end-user formats
- GL_DATE
- GL_DATETIME
- GLS-related
- GLS8BITFSYS
- INFORMIXDIR
- locale
- locale-related
- precedence for client locale
- precedence for DATE data
(1), (2)
- precedence for DATETIME data
(1), (2)
- precedence for monetary data
(1), (2)
- precedence for server-processing locale
(1), (2)
- SERVER_LOCALE
(1), (2), (3)
- Environment variables
- Era-based dates
- Error message
- Error message files
- Error messages
- Escape character
(1), (2)
- ESQL/C data types
(1), (2), (3)
- ESQL/C filter
- ESQL/C function library
- ESQL/C preprocessor
(1), (2)
- ESQL/C processor
- ESQL/C program
- accessing NCHAR data
- accessing NVARCHAR data
- checking database connection
(1), (2)
- comments
(1), (2), (3)
- compiling
(1), (2)
- data type constants
(1), (2), (3), (4)
- filenames
- handling code-set conversion
- host variables
(1), (2)
- indicator variables
- literal strings
(1), (2), (3), (4), (5)
- writing simple large objects to database
- ESQL library functions
- ESQLMF environment variable
(1), (2), (3)
- Explain file
- External representation of opaque data
- External tables
F
- FETCH statement
- File
- File extension
- .c
(1), (2)
- .c_
- .cm
(1), (2)
- .cmo
- .cv
(1), (2), (3)
- .cvo
(1), (2)
- .ec
(1), (2)
- .iem
- .lc
(1), (2), (3), (4)
- .lco
(1), (2)
- .o
- Filename
- finderr utility
- Fixed and Known Defects File
- FLOAT data type
(1), (2)
- Formatting
- Formatting directive
- French locale
(1), (2), (3), (4), (5), (6), (7), (8), (9), (10)
- Functions, case-sensitive
G
H
I
J
K
L
- LANG environment variable
- Language
- lcX.txt file
- Left-to-right writing direction
- LENGTH function
- LIBMI applications
- LIKE relational operator
(1), (2)
- Literal matches
(1), (2)
- Literal string
(1), (2), (3), (4), (5)
- Llternative formats
- Load file
- LOAD statement
(1), (2), (3)
- Loader, support for non-ASCII characters
- loc_buffer field
- loc_t data type
(1), (2)
- loc_type field
- Locale
- Locale environment variables
- Locale file
- Locale modifier
(1), (2), (3), (4), (5)
- Locale name
- code-set name
(1), (2), (3), (4), (5)
- example
(1), (2), (3)
- language name
(1), (2), (3), (4), (5)
- locale modifier name
(1), (2), (3), (4), (5)
- territory name
(1), (2), (3), (4), (5)
- Locale-sensitive data types
- Localization
- Locator structure
- Log file
(1), (2)
- Log filename, non-ASCII characters in
- Lossy error
- Lower class
- LOWER function
(1), (2)
- LVARCHAR data type
M
- Machine notes
- malloc( ) system call
- MATCHES relational operator
(1), (2)
- Message file
- Message log
- MESSAGES locale category
- mi_convert_from_codeset() DataBlade API function
- mi_convert_to_codeset() DataBlade API function
- mi_date_to_string() DataBlade API function
- mi_datetime_to_string( ) fumction
- mi_db_error_raise() function
(1), (2)
- mi_decimal_to_string() DataBlade API function
- mi_exec( ) function
- mi_exec() function
(1), (2)
- mi_exec_prepared_statement() function
- mi_get_string() DataBlade API function
- mi_interval_to_string() function
- MI_LIST_END tracing constant
- mi_money_to_string() DataBlade API function
- mi_prepare() function
- mi_put_string() DataBlade API function
- mi_string_to_date() DataBlade API function
- mi_string_to_datetime() function
- mi_string_to_decimal() DataBlade API function
- mi_string_to_interval() function
- mi_string_to_money() DataBlade API function
- mi_wchar data type
- Ming Guo year format
(1), (2)
- Minus (-) sign
- Monetary data
- currency notation
(1), (2), (3)
- currency symbol
(1), (2), (3), (4), (5)
- decimal separator
(1), (2), (3), (4), (5)
- default scale
- end-user format
(1), (2), (3), (4)
- format of
- locale-specific
- negative
(1), (2), (3)
- positive
(1), (2), (3)
- precedence of environment variables
(1), (2)
- thousands separator
(1), (2), (3), (4), (5)
- MONETARY locale category
- MONEY data type
- MSGPATH configuration parameter
(1), (2)
- Multibyte character
- column substrings
- definition of
- filtering
- in cast names
- in column names
(1), (2), (3), (4), (5), (6)
- in comments
(1), (2), (3)
- in connection names
- in constraint names
(1), (2), (3)
- in cursor names
(1), (2), (3), (4), (5), (6)
- in data type names
(1), (2)
- in database names
(1), (2), (3)
- in database server filenames
(1), (2)
- in database server utilities
- in delimited identifiers
- in ESQL filenames
- in filenames
(1), (2), (3), (4), (5)
- in function names
- in host variables
(1), (2), (3), (4), (5)
- in index names
- in indicator variables
(1), (2)
- in literal strings
(1), (2), (3), (4)
- in LOAD FROM file
- in NCHAR columns
- in numeric formats
- in NVARCHAR columns
- in opaque data type names
(1), (2), (3)
- in operator-class names
- in owner names
- in procedure names
- in quoted strings
- in role names
- in routine names
- in ROW data type names
- in sequence names
- in SPL routines
(1), (2), (3), (4)
- in SQL comments
- in statement IDs
(1), (2), (3), (4), (5), (6)
- in synonym names
- in table aliases
- in table names
(1), (2), (3), (4), (5), (6)
- in trigger names
- in triggers
- in UNLOAD TO file
- in view names
(1), (2), (3), (4), (5), (6)
- partial characters
(1), (2)
- processing
(1), (2), (3)
- shifting case of
- support by C compiler
(1), (2)
- support for
- with CC8BITLEVEL environement variable
- with GLS8BITFSYS environment variable
- Multicharacter collation elements
N
- National language support (NLS)
- NCHAR data type
- Non-ASCII character
- definition of
- examples
- filtering
- in cast names
- in column names
(1), (2), (3), (4), (5), (6), (7)
- in comments
(1), (2), (3)
- in connection names
- in constraint names
(1), (2), (3)
- in cursor names
(1), (2), (3), (4), (5), (6)
- in database names
(1), (2), (3)
- in delimited identifiers
- in distinct data type names
- in ESQL filenames
- in filenames
(1), (2), (3), (4)
- in host variables
(1), (2), (3), (4), (5)
- in index names
- in indicator variables
(1), (2)
- in literal strings
(1), (2), (3), (4)
- in LOAD FROM file
- in opaque data type names
(1), (2)
- in operator-class names
- in owner names
- in quoted strings
- in role names
- in ROW data type names
- in sequence names
- in SPL routines
(1), (2), (3)
- in SQL comments
- in statement IDs
(1), (2), (3), (4), (5), (6)
- in synonym names
- in table names
(1), (2), (3), (4), (5), (6)
- in trigger names
- in triggers
- in UDR source files
- in UNLOAD TO file
- in view names
(1), (2), (3), (4), (5), (6)
- processing
(1), (2), (3)
- support for
- with CC8BITLEVEL environment variable
(1), (2)
- with GLS8BITFSYS environment variable
- Non-Gregorian calendar
- Non-Roman alphabets
- Nonprintable characters
- Numeric data
- currency notation in
- decimal separator
(1), (2), (3), (4)
- end-user format
(1), (2), (3), (4)
- ESQL functions
- format of
- locale-specific
- negative
(1), (2), (3)
- positive
(1), (2), (3)
- thousands separator
(1), (2), (3), (4)
- NUMERIC locale category
- Numeric notation
- NVARCHAR data type
O
P
Q
R
- Range matches
- rdatestr() library function
(1), (2), (3)
- rdefmtdate() library function
(1), (2)
- rdownshift() library function
- receive( ) function
- registry file
(1), (2), (3)
- Regular expression
(1), (2)
- Related reading
- Relational-operator conditions
- Release Notes
- RENAME COLUMN statement
- Resource file
- rfmtdate() library function
(1), (2)
- rfmtdec() library function
- rfmtdouble() library function
- rfmtlong() library function
(1), (2), (3)
- rgetlmsg( ) library function
- rgetmsg( ) library function
- Right-to-left writing direction
- Role
- Round-trip conversion
- Row data type
- rstrdate() library function
(1), (2)
- Runtime error, custom message
- rupshift() library function
S
- sales_demo database
- Sample-code conventions
- Schema name
- Search functions
- SELECT statement
- send( ) function
- Sequence
- Server code set
- Server computer
- Server locale
- SERVER_LOCALE environment variable
(1), (2)
- Server-processing locale
- SET COLLATION statement
(1), (2), (3), (4), (5)
- SET EXPLAIN statement
- Simple large objects
- Single ( ' ) quotes
- Single-byte character
(1), (2), (3)
- SMALLFLOAT data type
- SMALLINT data type
- Software dependencies
- Spanish locale
- SPL routine
(1), (2), (3), (4)
- SQL API products
- SQL code
- SQL functions for case
- SQL identifier
- SQL length function
- SQL segments
- SQL statement
- CONNECT
- CREATE CAST
- CREATE DISTINCT TYPE
- CREATE EXTERNAL TABLE
- CREATE FUNCTION
- CREATE INDEX
(1), (2), (3), (4)
- CREATE OPAQUE TYPE
- CREATE OPCLASS
- CREATE PROCEDURE
(1), (2), (3), (4)
- CREATE ROLE
- CREATE ROW TYPE
- CREATE SEQUENCE
- CREATE SYNONYM
- CREATE TRIGGER
(1), (2)
- CREATE VIEW
- data manipulation
- DECLARE
- DELETE
- DESCRIBE
- end-user formats in
- FETCH
- in code-set conversion
(1), (2)
- in UDRs
- LOAD
(1), (2), (3)
- PREPARE
- RENAME COLUMN
- SELECT
- SET COLLATION
(1), (2), (3)
- SET EXPLAIN
- UNLOAD
(1), (2)
- UPDATE
- SQL utilities
- SQLBYTES data type constant
- sqlca.sqlwarn.sqlwarn7 flag
- sqlca structure
- sqlda.sqlvar.sqldata field
- sqlda.sqlvar.sqllen field
- sqlda.sqlvar.sqlname field
- sqlda structure
(1), (2), (3)
- SQLNVCHAR data type constant
- SQLSTATE status value
- SQLTEXT data type constant
- sqltypes.h header file
(1), (2)
- sqlvar_struct structure
- SQLVCHAR data type constant
- SQLWARN warning flag
(1), (2), (3), (4), (5), (6)
- Statement identifier
(1), (2), (3), (4), (5), (6), (7)
- stores_demo database
- Substitution conversion
- Substring
(1), (2)
- superstores_demo database
- Synonym
- Syntax diagrams
- Syntax segment
- syserrors system catalog table
(1), (2), (3)
- systables system catalog table
- System catalog
(1), (2)
- System requirements
- systracemsgs system catalog table
(1), (2), (3)
T
- Table (database)
- Taiwanese dates
(1), (2)
- Territory
(1), (2), (3), (4), (5), (6)
- TEXT data type
- Thousands separator
(1), (2), (3), (4), (5), (6), (7)
- Time data
- TIME locale category
- TOC Notes
- Token names
(1), (2)
- Top-to-bottom writing direction
- Trace block
- Trace message
- Tracing
- Trigger
(1), (2)
- TRIM function
(1), (2), (3)
- Typographical conventions
U
V
W
X
Y
Z
Home |
[ Top of Page | Previous Page | Contents |
Index ]