Intro to DBAccess and SQL
Slide 1 of 53
1: Intro to DBAccess and SQL
2: Topics
3: Informix in AWIPS
4: Informix Utilities
5: Backup
6: Queries
7: DBAccess
8: Structured Query Language - SQL
9: Data Types in Informix
10: Statements in SQL
11: SQL Syntax Diagrams
12: The INFO Statement
13: The SELECT Statement
14: The SELECT Statement
15: The SELECT Clauses
16: The SELECT Statement Structure
17: Building a SELECT statement
18: Starting Dbaccess for SQL
19: SQL in DBAccess
20: SQL in DBAccess (con't)
21: Linking two tables together with SELECT
22: Two Table SELECT
23: Using Temporary Tables
24: Using INTO TEMP
25: Be Careful
26: Lets Fix the Problem
27: More about WHERE clauses
28: Searching CHARACTER Fields
29: Subscripts
30: More SELECT Statements
31: Test Your Knowledge
32: Test Your Knowledge
33: Date Functions
34: Using Date Functions
35: Functions
36: The GROUP BY Clause
37: Subqueries
38: Subqueries
39: Test Your Knowledge
40: The UNLOAD TO Statement
41: The UNLOAD TO Statement
42: The UNLOAD TO Clauses
43: A sample UNLOAD TO Statement
44: Using UNLOAD TO
45: The UPDATE Statement
46: The UPDATE Clauses
47: A sample UPDATE statement
48: Another Look at DBAccess
49: Converting Queries to Scripts
50: Converting Queries to Scripts
51: Converting Queries to Scripts
52: Resources
53: Slide 53
Notes:
