Table 10 lists the tasks for developing, compiling, and running client application programs and DataBlade modules that access database server data.
| If You Want To | Manual |
|---|---|
| Test database applications that you intend to store for use in a production environment. | IBM Informix DB–Access User's Guide |
| Write
procedures with SPL and store them in a database.
Use a primary access method. |
IBM Informix Guide to SQL: Syntax |
| Use embedded SQL in programs.
Program in a multiuser environment. Create and use routines with SPL. Work with user-defined and system-defined casts on extended data types. |
IBM Informix Guide to SQL: Tutorial |
| Use IBM Informix ODBC
Driver to access relational databases with SQL.
Create custom applications with IBM Informix ODBC API functions. |
IBM Informix ODBC Driver Programmer's Manual |
| Embed SQL statements directly into C programs. | IBM Informix ESQL/C Programmer's Manual |
| Create new data types and user-defined routines using Java. | J/Foundation Developer's Guide |
| Use the GLS features that let Informix SQL APIs and database servers handle different languages, cultural conventions, and code sets. | IBM Informix GLS User's Guide |
| Work with the TP/XA library in an X/Open distributed transaction-processing (DTP) environment. Develop applications for a third-party transaction manager and an Informix database server. | IBM Informix TP/XA Programmer's Manual |
| Create new data types and user-defined routines using C.
Define new data types or extend the functionality of existing data types. Extend operations on data types, create new casts, extend operator classes for secondary access methods, and create opaque data types for your database or DataBlade programs. Create application-specific SPL or external routines for application end-users. Create and register a user-defined routine (UDR) to invoke within an SQL statement or another routine. |
IBM Informix User-Defined Routines and Data Types Developer's Guide |
| Use DataBlade API functions
to develop server and client applications that access data stored in a Dynamic Server database.
Write server routines and client LIBMI applications that use smart large objects and complex and extended data types. |
IBM Informix DataBlade API Programmer's Guide |
| Use DataBlade API functions. Use ESQL/C functions with the DataBlade API. | IBM Informix DataBlade API Function Reference |
| Use Java to create client applications or applets that
run against Dynamic Server.
Install and load the IBM Informix JDBC Driver. Use standard JDBC to connect to a database or database server. Use standard JDBC to send queries, retrieve results, get database and column metadata, and handle errors. Learn how standard Java data types map to Informix data types. Store and retrieve XML documents. Use the IBM Informix HTTP proxy servlet. Debug JDBC API programs. |
IBM Informix JDBC Driver Programmer's Guide |
| Use the object-oriented C++ programming language to create
database client applications for Informix database servers.
Use Object Interface for C++to create value objects that let C++ client applications support DataBlade module data types. |
IBM Informix Object Interface for C++ Programmer's Guide |
| Work with the R-tree secondary access method. | IBM Informix R-Tree Index User's Guide |
| Develop a secondary access method with the Virtual-Index Interface (VII)
to create new types of indexes.
Use functions in the VII library. |
IBM Informix Virtual-Index Interface Programmer's Guide |
| Develop a primary access method with the Virtual-Table Interface (VTI) so that users can access external data. | IBM Informix Virtual-Table Interface Programmer's Guide |
| Develop applications using DataBlade modules. | DataBlade Manuals |