informix sql functions

Setting Informix Environment Variables I. Environment exampleVariable Name DescriptionDBDELIMITER specifies the field delimiters used by dbload in the extract data file.DBDATE specifies the date format (Y4MD/, MDY4-) to be used in the database

In Linux/Unix, some programs are command-line or service programs. Generally, there is a configuration file to describe their running rules. These rules are usually stored in the database, maintained by other applications. This involves a question:

Informix is a relational database management system that can be used to develop powerful applications that can run on multiple platforms. Informix Database Dynamic Server (IDS) is the core of INFORMIX database technology products, featuring

Oracle basic concepts and comparison with informix I. ConceptsUser: informix directly uses the user management system of the operating system. Generally, root and informix are used as super operators to manage other users. Oracle has its own user

The Informix Dynamic Server provides two levels of access privileges to ensure database security. Database privileges control the access to the database and the right to create tables and indexes on the database. TABLE privileges specify the actions

INFORMIX uses the lock technology to solve the concurrency control problem of accessing the same object when multiple users access the database. INFORMIX supports complex and scalable locking technologies. Lock type INFORMIX has three different

Many people who are familiar with Oracle usually encounter various questions when starting to use the Informix Database: Informix is not supported, and Informix does not have this function? In fact, many times Informix is implemented in different

I. Introduction 1) INFORMIX consists of three main products: Database Server (Database Core) Application development tools Network Database interconnection Products 2) The database server provides two functions: Data Operations and Management:

First, Infomix use MemoDirectory structure:1. Start and stop orders;2. Modify the database encoding;3. View the ports that Informix occupies;4. Use the dbaccess command to import and build table information from a file;5. Give a user DBA authority

1. Introduction         stored procedure (Stored Procedure) is a set of SQL statements that are compiled and stored in a database in order to accomplish a specific function. The user executes it by specifying the name of the stored procedure and