Intro to DBAccess and SQL

Topics

Informix in AWIPS

Informix Utilities

Backup

Queries

DBAccess

Structured Query Language - SQL

Data Types in Informix

Statements in SQL

SQL Syntax Diagrams

The INFO Statement

The SELECT Statement

The SELECT Statement

The SELECT Clauses

The SELECT Statement Structure

Building a SELECT statement

Starting Dbaccess for SQL

SQL in DBAccess

SQL in DBAccess (con't)

Linking two tables together with SELECT

Two Table SELECT

Using Temporary Tables

Using INTO TEMP

Be Careful

Lets Fix the Problem

More about WHERE clauses

Searching CHARACTER Fields

Subscripts

More SELECT Statements

Test Your Knowledge

Test Your Knowledge

Date Functions

Using Date Functions

Functions

The GROUP BY Clause

Subqueries

Subqueries

Test Your Knowledge

The UNLOAD TO Statement

The UNLOAD TO Statement

The UNLOAD TO Clauses

A sample UNLOAD TO Statement

Using UNLOAD TO

The UPDATE Statement

The UPDATE Clauses

A sample UPDATE statement

Another Look at DBAccess

Converting Queries to Scripts

Converting Queries to Scripts

Converting Queries to Scripts

Resources

Slide 53