The rest of this chapter describes what you can do with SQL statements and presents statement syntax examples. Many of these examples manipulate the sample relational tables named SYSTEMS and APPLICATIONS.
The SYSTEMS table contains this information:
|
ROW |
NAME |
CURRENT_ STATE |
DESIRED_ STATE |
RECOV_PROC |
|---|---|---|---|---|
|
Row 1 |
CICS |
DOWN |
UP |
FIXCICS |
|
Row 2 |
IMS |
UP |
UP |
FIXIMS |
The APPLICATIONS table contains this information:
|
ROW |
APPL_ID |
USER_ID |
UPDATE |
STATUS |
|---|---|---|---|---|
|
Row 1 |
APPL1 |
TSOUSR1 |
1992-02-13 |
UP |
|
Row 2 |
APPL2 |
TSOUSR2 |
1992-02-05 |
DOWN |
|
Row 3 |
APPL5 |
TSOUSR8 |
1992-01-31 |
DOWN |
|
Row 4 |
APPL10 |
TSOUSR22 |
1992-03-04 |
UP |
|
Copyright © 2014 CA.
All rights reserved.
|
|