How do you build databases and tables in Informix? We will discuss best practices for creating and managing databases and tables, partitioning, and database security. We will demonstrate object-oriented data types, using SQL to generate SQL Scripts and creating a Non-OS user for Informix database security.


Using SQL to Generate SQL Scripts (DBA Tricks and Tips)

First published in the Washington Area Informix User Group Newsletter Volume 7, No.3 – July 1997 This article will take a look at some tricks for using SQL to generate SQL to help you maintain and support your databases. One of the advantages of querying the system tables is that you can use the output […]

An Introduction to INFORMIX Database Security

First published in the Washington Area Informix User Group Newsletter Volume 4, No. 3 – July 1994 Informix applies security at the database, table and column level. All security is based on a users login name. Using Informix SQL, the creator of a database can give and remove privileges. The SQL command to give access […]