Informix SQL Introduction

First, Introduction

1, Informix main products are divided into three major parts:

Database server (Database core)

Application Development Tools

Network Database Interconnection Products

2, there are two types of database server, the role is to provide data manipulation and management:

SE: Completely based on Unix operating system, mainly for non-multimedia application of less user number

Online: On-line transaction processing and multimedia application environment for a large number of users

3. Application development tools are the necessary environment and tools for developing applications, and there are two main series:

4gl:informix Traditional development tool based on character interface, the main products of this series are five, they are i-sql, 4GL RDS, 4GL C COMPILER, 4GL ID and ESQL/C;

Newera:informix is the latest to provide event-driven, object-oriented development tools based on a variety of graphical interfaces.

4, Informix Network database Interconnection products: To provide users with a variety of industrial standards based on the application interface, through it can and other compliance with these industrial standards of the database connection.

Second, i-sql menu introduction

The form can execute, create, modify, compile screen formats, or delete existing screen formats

Run executes a screen format that already exists

Modify Modify the specified existing screen format

Generate creates a default screen format for the specified table

Compile compile a set of screen formats

NEW Create a specific user screen format

Drop deletes a format file that already exists

Exit Exits Form Menu

Report can execute, establish, modify, compile, or delete reports

Run executes a report

Modify Modify the specified report

Generate set up a default report for a table

NEW Create a user-specified report

Compile Compile the specified report

Drop deletes a specified already existing report

Exit out of the menu

Query-language details of the utility: dbaccess

User-menu can execute, create, or modify user-created menus

Run executes the User menu for the current database

Modify allows users to create or modify user menus

Exit User-menu Menu

Database details of the utility instructions: dbaccess

Table for details of the utility instructions: dbaccess

Exit Exit utility ISQLRF (or isql)