How to Write an Informix SQL Query
Informix SQL queries are very important to managing a database. You can look up anything you want in any database as long as you know what the table and row names are.
Other People Are Reading
Instructions
-
-
1
Locate the table and row you want to query. In order to do this, you must have a piece of information to use to locate that row. In this example let's imagine we are looking for an invoice number, but we only have the order number. You must use the order number to look up the invoice number in the invoice table.
-
2
Type "set isolation dirty read;". This allows you to access tables through your Informix SQL query that may be in use by someone else on the system.
-
-
3
Type "select * from" and the name of the invoice table. The asterisk tells the system to show you every row in that table. If you know which row you want to look up with your Informix SQL query, you can type the name of that row instead of the asterisk.
-
4
Type "where", the name of the row holding the order number and "=" and the order number in quotations. This instructs the database engine to extract the invoice column that corresponds with that row.
-
5
Run your Informix SQL query. The system returns the information from the invoice table that matches that order number.
-
1
