Welcome
Client APIs and tools
You can use the HCL Informix® implementation of client APIs to develop applications for Informix database servers.
Informix® JDBC Driver Guide
The HCL® Informix® JDBC Driver Programmer's Guide describes how to install, load, and use HCL Informix JDBC Driver to connect to the Informix database from within a Java™ application or applet.
Appendixes
Error messages
-79799
An invalid character is found in the DBDATE string after the 'Y' character

HCL Informix® V15.0.0 documentation
Welcome to the documentation for HCL Informix® 15.0.0 and related client tools and products.
Product overview
HCL Informix® is a fast and scalable database server that manages traditional relational, object-relational, and dimensional databases. Its small footprint and self-managing capabilities are suited to embedded data-management solutions.
Installing
These topics describe how to install HCL Informix® database servers, client products, and modules.
Administering
In addition to administering the database server, you can tune performance, replicate data, and archive data.
Migrating and upgrading
You can upgrade to the 15.0.0 release of HCL Informix® or migrate from other database servers to Informix. Upgrading is an in-place migration method that uses your existing hardware and operating system software. Some changes to the Informix database server can affect upgrading from a previous release.
Client APIs and tools
You can use the HCL Informix® implementation of client APIs to develop applications for Informix database servers.
- Change Data Capture API Programmer's Guide
  The HCL® Informix® Change Data Capture API Programmer's Guide describes how to program applications to process changed data from HCL Informix databases using the HCL Informix Change Data Capture API.
- Embedded SQLJ for HCL Informix®
  The HCL® Informix® Embedded SQLJ User's Guide contains information about using IBM Informix Embedded SQLJ.
- ESQL/C Guide
  The HCL® Informix® Enterprise Replication Guide explains how to use , the Informix implementation of Embedded Structured Query Language (SQL) for C (ESQL/C), to create client applications with database-management capabilities.
- GLS User's Guide
  The HCL® Informix® GLS User's Guide describes the Global Language Support (GLS) feature available in HCL Informix products.
- Informix GLS API
  The Informix GLS API Programmer's Guide describes the global language support (GLS) application programming interface (API) available in Informix® ESQL/C and HCL Informix modules.
- Informix® Object Interface for C++ Guide
  The Informix® Object Interface for C++ Programmer's Guide describes how to develop HCL Informix client applications by using the object-oriented C++ programming language.
- Informix® ODBC Driver Guide
  The Informix® ODBC Driver Programmer's Manual serves as a user guide and reference for HCL Informix ODBC Driver, which is the Informix implementation of the Microsoft™ Open Database Connectivity (ODBC) interface, Version 3.0.
- .NET provider options
  The HCL Data Server Provider for .NET IBM® DB2® provider option is the preferred Informix® provider for developing new applications.
- HCL Informix 4GL
  This topic provides a link to the Informix 4GL documentation.
- Informix® JDBC Driver Guide
  The HCL® Informix® JDBC Driver Programmer's Guide describes how to install, load, and use HCL Informix JDBC Driver to connect to the Informix database from within a Java™ application or applet.
  - Getting started
  - Connect to the database
  - Perform database operations
  - Work with Informix® types
  - Work with opaque types
  - Globalization and date formats
  - Push data feature
  - Tuning and troubleshooting
  - Appendixes
    - Sample code files
    - DataSource extensions
    - Mapping data types
    - Convert internal Informix® data types
      For your Java™ application to work with the internal server representation of HCL Informix® data types, use the IfxToJavaType class. For example, if your application is using the HCL Informix Change Data Capture API, you can use the IfxToJavaType class to interpret the byte stream.
    - Error messages
      - -79700
        Method not supported
      - -79702
        Cannot create new object
      - -79703
        Row/column index out of range
      - -79704
        Cant load driver
      - -79705
        Incorrect URL format
      - -79706
        Incomplete input
      - -79707
        Invalid qualifier
      - -79708
        Cannot take null input
      - -79709
        Error in date format
      - -79710
        Syntax error in SQL escape clause
      - -79711
        Error in time format
      - -79712
        Error in timestamp format
      - -79713
        Incorrect number of arguments
      - -79714
        Type not supported
      - -79715
        Syntax error
      - -79716
        System or internal error
      - -79717
        Invalid qualifier length
      - -79718
        Invalid qualifier start code
      - -79719
        Invalid qualifier end code
      - -79720
        Invalid qualifier start or end code
      - -79721
        Invalid interval string
      - -79722
        Numeric character(s) expected
      - -79723
        Delimiter character(s) expected
      - -79724
        Character(s) expected
      - -79725
        Extra character(s) found
      - -79726
        Null SQL statement
      - -79727
        Statement was not prepared
      - -79728
        Unknown object type
      - -79729
        Method cannot take argument
      - -79730
        Connection not established
      - -79731
        MaxRows out of range
      - -79732
        Illegal cursor name
      - -79733
        No active result
      - -79734
        INFORMIXSERVER has to be specified
      - -79735
        Cant instantiate protocol
      - -79736
        No connection/statement establish yet
      - -79737
        No metadata
      - -79738
        No such column name
      - -79739
        No current row
      - -79740
        No statement created
      - -79741
        Cannot convert to
      - -79742
        Cannot convert from
      - -79744
        Transactions not supported
      - -79745
        Read only mode not supported
      - -79746
        No Transaction Isolation on non-logging db's
      - -79747
        Invalid transaction isolation level
      - -79748
        Cannot lock the connection
      - -79749
        Number of input values does not match number of question marks
      - -79750
        Method only for queries
      - -79755
        Object is null
      - -79756
        Must start with 'jdbc'
      - -79757
        Invalid subprotocol
      - -79758
        Invalid IP address
      - -79759
        Invalid port number
      - -79760
        Invalid database name
      - -79761
        Invalid property format
      - -79762
        Attempt to connect to a non 5.x server
      - -79764
        Invalid fetch direction value
      - -79765
        ResultSet type is TYPE_FETCH_FORWARD, direction can only be FETCH_FORWARD
      - -79766
        Incorrect fetch size value
      - -79767
        ResultSet type is TYPE_FORWARD_ONLY
      - -79768
        Incorrect row value
      - -79769
        A customized type map is required for this data type
      - -79770
        Cannot find the SQLTypeName specified in the SQLData or Struct
      - -79771
        Input value is not valid
      - -79772
        No more data to read or write. Verify your SQLData class or getSQLTypeName()
      - -79774
        Unable to create local file
      - -79775
        Only TYPE_SCROLL_INSENSITIVE and TYPE_FORWARD_ONLY are supported
      - -79776
        Type requested (%s) does not match row type information (%s) type
      - -79777
        readObject/writeObject() only supports UDTs, Distincts, and complex types
      - -79778
        Type mapping class must be a java.util.Collection implementation
      - -79780
        Data within a collection must all be the same Java™ class and length
      - -79781
        Index/Count out of range
      - -79782
        Method can be called only once
      - -79783
        Encoding or code set not supported
      - -79784
        Locale not supported
      - -79785
        Unable to convert JDBC escape format date string to localized date string
      - -79786
        Unable to build a Date object based on localized date string representation
      - -79788
        User name must be specified
      - -79789
        Server does not support GLS variables DB_LOCALE, CLIENT_LOCALE or GL_DATE
      - -79790
        Invalid complex type definition string
      - -79792
        Row must contain data
      - -79793
        Data in array does not match getBaseType() value
      - -79794
        Row length provided (%s) does not match row type information (%s)
      - -79795
        Row extended ID provided (%s) does not match row type information (%s)
      - -79796
        Cannot find UDT, distinct, or named row (%s) in database
      - -79797
        DBDATE setting must be at least four characters and no longer than six characters
      - -79798
        A numeric year expansion is required after 'Y' character in DBDATE string
      - -79799
        An invalid character is found in the DBDATE string after the 'Y' character
      - -79800
        No 'Y' character is specified before the numeric year expansion value
      - -79801
        An invalid character is found in DBDATE format string
      - -79802
        Not enough tokens are specified in the string representation of a date value
      - -79803
        Date string index out of bounds during date format parsing to build Date object
      - -79804
        No more tokens are found in DBDATE string representation of a date value
      - -79805
        No era designation found in DBDATE/GL_DATE string representation of date value
      - -79806
        Numerical day value can not be determined from date string based on DBDATE
      - -79807
        Numerical month value can not be determined from date string based on DBDATE
      - -79808
        Not enough tokens specified in %D directive representation of date string
      - -79809
        Not enough tokens specified in %x directive representation of date string
      - -79811
        Connection without user/password not supported
      - -79812
        User/Password does not match with datasource
      - -79814
        Blob/Clob object is either closed or invalid
      - -79815
        Not in Insert mode. Need to call moveToInsertRow() first
      - -79816
        Cannot determine the table name
      - -79817
        No serial, rowid, or primary key specified in the statement
      - -79818
        Statement concurrency type is not set to CONCUR_UPDATABLE
      - -79819
        Still in Insert mode. Call moveToCurrentRow() first
      - -79820
        Function contains an output parameter
      - -79821
        Name unnecessary for this data type
      - -79822
        OUT parameter has not been registered
      - -79823
        IN parameter has not been set
      - -79824
        OUT parameter has not been set
      - -79825
        Type name is required for this data type
      - -79826
        Ambiguous java.sql.Type, use IfxRegisterOutParameter()
      - -79827
        Function doesn't have an output parameter
      - -79828
        Function parameter specified isnt an OUT parameter
      - -79829
        Invalid directive used for the GL_DATE environment variable
      - -79830
        Insufficient information given for building a time or timestamp Java™ object.
      - -79831
        Exceeded maximum no. of connections configured for Connection Pool Manager
      - -79834
        Distributed transactions (XA) are not supported by this database server.
      - -79836
        Proxy Error: No database connection
      - -79837
        Proxy Error: Input/output error while communicating with database
      - -79838
        Cannot execute change permission command (chmod/attrib)
      - -79839
        Same Jar SQL name already exists in the system catalog
      - -79840
        Unable to copy jar file from client to server
      - -79842
        No UDR information was set in UDRMetaData
      - -79843
        SQL name of the jar file was not set in UDR/UDT MetaData
      - -79844
        Cant create/remove UDT/UDR as no database is specified in the connection
      - -79845
        JAR file on the client does not exist or cant be read
      - -79846
        Invalid JAR file name
      - -79847
        The 'javac' or 'jar' command failed
      - -79848
        Same UDT SQL name already exists in the system catalog
      - -79849
        UDT SQL name was not set in UDTMetaData
      - -79850
        UDT field count was not set in UDTMetaData
      - -79851
        UDT length was not set in UDTMetaData
      - -79852
        UDT field name or field type was not set in UDTMetaData
      - -79853
        No class files to be put into the jar
      - -79854
        UDT java class must implement java.sql.SQLData interface
      - -79855
        Specified UDT java class is not found
      - -79856
        Specified UDT does not exists in the database.
      - -79857
        Invalid support function type
      - -79858
        The command to remove file on the client failed
      - -79859
        Invalid UDT field number
      - -79860
        Ambiguous java type(s) - can't use Object/SQLData as method argument(s)
      - -79861
        Specified UDT field type has no Java™ type match
      - -79862
        Invalid UDT field type
      - -79863
        UDT field length was not set in UDTMetaData
      - -79864
        Statement length exceeds the maximum
      - -79865
        Statement already closed
      - -79868
        Result set not open, operation not permitted
      - -79877
        Invalid parameter value for setting maximum field size to a value less than zero
      - -79878
        Result set not open, operation next not permitted. Verify that autocommit is OFF
      - -79879
        An unexpected exception was thrown. See next exception for details
      - -79880
        Unable to set JDK Version for the Driver
      - -79881
        Already in local transaction, so cannot start XA transaction
- Informix International Language Supplement (ILS) User Guide
  These topics include information about the translated user interface files for Informix® UNIX™ products, locales, and code set conversion tables
- Informix® OLE DB Provider Guide
  The HCL Informix OLE DB Provider Programmer's Guide describes the software requirements for using HCL Informix® OLE DB Provider, show how to install and configure the provider for your use, and explain how to use Informix OLE DB Provider to enable client applications, such as ActiveX Data Object (ADO) applications and web pages, to access data on the Informix server.
Embedding Informix®
When you embed HCL Informix®, you can use enterprise-class high-availability and high performance with embeddability features such as easy programmability, a small disk and memory footprint, and silent deployment.
Extending Informix®
Beyond standard relational database objects, HCL Informix® can be extended to handle specialized data types, access methods, routines, and other objects. Informix includes many built-in extensions that are fully integrated in the database server. Informix also provides modules, which are packages of extended database objects for a particular purpose and that are installed separately from the database server. Alternatively, you can create your own user-defined objects for Informix.
Data warehousing
In addition to designing and implementing Informix® dimensional databases, you can use tools to create data warehouse applications and optimize your data warehouse queries.
Designing databases
The first step in creating a relational database is to construct a data model, which is a precise, complete definition of the data you want to store. After you prepare your data model, you must implement it as a database and tables. To implement your data model, you first select a data type for each column and then you create a database and tables and populate the tables with data. You can also implement fragmentation strategies and control access to your data.
JSON compatibility
You can use the popular JSON-oriented query language created by MongoDB to interact with data stored in HCL Informix®.
Security
You can secure your Informix® database server and the data that is stored in your Informix databases. You can encrypt data, secure connections, control user privileges and access, and audit data security.
SQL programming
You can use the HCL Informix® implementation of the SQL language to develop applications for Informix database servers.
Troubleshooting HCL Informix®
Several troubleshooting techniques, tools, and resources are available for resolving problems that you encounter in your HCL Informix® database server environment.

-79799

An invalid character is found in the DBDATE string after the 'Y' character

This error occurs because the DBDATE format string has a year designation (specified by the character Y), but the character following the year designation is not a 2 (two-digit years) or 4 (four-digit years).

To fix the problem, modify the DBDATE format string to include the required numeric year expansion value after the Y character. Only a 2 or 4 character should immediately follow the Y character designation.