#INFORMIX ODBC CAST AS MONEY HOW TO#
#INFORMIX ODBC CAST AS MONEY SOFTWARE#
#INFORMIX ODBC CAST AS MONEY CODE#

features These topics explain how the GLS feature affects, an SQL application programming interface (API).

#INFORMIX ODBC CAST AS MONEY SOFTWARE#

General SQL API features (ESQL/C) These topics explain how the GLS feature affects applications that you develop with the HCL OneDBв„ў Client Software Development Kit.Database server features These topics describe how the GLS feature affects the database server.

#INFORMIX ODBC CAST AS MONEY CODE#

Data definition statements HCL OneDBв„ў supports a configuration parameter, SQL_LOGICAL_CHAR, whose setting can simplify the use of certain Data Definition Language (DDL) statements of SQL when you declare character data types in locales that support multibyte code sets.Data manipulation statements The choice of a locale can affect certain SQL data manipulation statements.Locale-sensitive data types These topics explain how a locale affects the way that a database server handles the MONEY data type, extended data types, and smart large objects (CLOB and BLOB data types).Handle character data The GLS feature allows you to put non-ASCII characters (including multibyte characters) in the elements of an SQL statement.Character data types The locale affects the collation of built-in SQL character data types.The alpha class lists all characters that are classified as alphabetic.

Valid characters in identifiers In an SQL identifier, a letter can be any character in the alpha class that the locale defines.

Delimited identifiers A delimited identifier is an identifier that is enclosed in double quotation marks.

Multibyte characters in hard-coded path names, for example, limits the portability of your application to operating systems that can support multibyte file names.

Path names and file names Valid path names and file names are operating system-dependent.

Owner names The owner name is the identifier of the user (or of a pseudo-user, for an owner like informix that does not correspond to the login name of an actual user) who is associated with the creation of a database object.

Qualifiers of SQL identifiers A complete syntax can include other identifiers.

Rules for identifiers An SQL identifier is a string of letters, digits, and underscores that represents the name of a database object such as a table, column, index, or view.

GLS environment variables HCL OneDBв„ў products establish the client, database, and server locales with information from GLS-related environment variables and from data that is stored in the database.

GLS fundamentals The Global Language Support (GLS) feature lets HCLВ® OneDBВ® products handle different languages, cultural conventions, and code sets for Asian, African, European, Latin American, and Middle Eastern countries.

#INFORMIX ODBC CAST AS MONEY HOW TO#

ESQL/C Guide The HCL OneDBв„ў ESQL/C Programmer's Manual explains how to use, the HCL OneDBв„ў implementation of Embedded Structured Query Language (SQL) for C (ESQL/C), to create client applications with database-management capabilities.

The HCL OneDBв„ў Change Data Capture API Programmer's Guide describes how to program applications to process changed data from HCL OneDBв„ў databases using the HCLВ® OneDBВ® Change Data Capture API.

Change Data Capture API Programmer's Guide These topics describe how to program applications to process changed data from HCL OneDBв„ў databases using the HCLВ® OneDBВ® Change Data Capture API.

Non-ASCII characters in identifiers HCL OneDBв„ў database servers support non-ASCII (wide, 8-bit, and multibyte) characters from the code set of the database locale in most SQL identifiers, such as the names of columns, connections, constraints, databases, indexes, roles, SPL routines, sequences, synonyms, tables, triggers, and views.

Name database objects You must declare names for new database objects (and in some cases, for storage objects, such as dbspaces) when you use data definition language (DDL) statements such as CREATE TABLE, CREATE INDEX, and RENAME COLUMN.

SQL features These topics explain how the GLS feature affects the HCLВ® OneDBВ® implementation of SQL.

The HCL OneDBв„ў GLS User's Guide describes the Global Language Support (GLS) feature available in HCLВ® OneDBВ® products.

GLS User's Guide These topics describe the Global Language Support (GLS) feature available in HCLВ® OneDBВ® products.

Client APIs and tools You can use the HCL OneDBв„ў implementation of client APIs to develop applications for HCL OneDBв„ў database servers.

Informix odbc cast as money