 |
Introduction to TurboQuery400 |
1 |
| |
Chapter 1 System and Query Inventories |
3 |
| |
System Inventory Lab 1 - Create an Inventory of all Files |
5 |
| |
System Name Identification |
9 |
| |
Create Source Files |
9 |
| |
Chapter 2 System and Query-Inventory Queries |
13 |
| |
Queries Lab 2 - All File Members with Deleted Records |
14 |
| |
Queries Lab 3 - Total Deleted Records in Each Library |
19 |
| |
Queries Lab 4 - A String of Queries |
23 |
| |
Queries Lab 5 - Query-Inventory Query |
32 |
| |
Chapter 3 Query Groups |
35 |
| |
Queries Lab 6 - Create the Date File & its Update Program |
37 |
| |
Queries Lab 7 - Create the Query Group files |
44 |
| |
Queries Lab 8 - Create the CL and RPG Programs |
48 |
| |
Queries Lab 9 - Modifying Queries for Date Range |
73 |
| |
Chapter 4 Output to Excel and E-mail Notification |
79 |
| |
Queries Lab 10 - Create Folders on the IFS |
80 |
| |
Queries Lab 11 - Modify Files & Programs |
84 |
| |
Chapter 5 Testing and Trouble-Shooting |
99 |
| |
Chapter 6 DataFinder |
105 |
| |
Queries Lab 12 - Build the DataFinder System |
110 |
| |
Chapter 7 Summary |
131 |
| |
Appendix A. CD-ROM Contents |
133 |
| |
Appendix B. Copy & Restore iSeries Files from CD-ROM Files |
135 |
| |
Save files provided on the CD-ROM |
135 |
| |
Review the save files provided on the CD-ROM |
135 |
| |
Locate the save file on the CD-ROM |
136 |
| |
Create required iSeries objects |
136 |
| |
Start the FTP server |
136 |
| |
Use FTP on the PC to upload the save files |
136 |
| |
Restore objects from the save file to library RPGQUERY |
137 |
| |
View the contents of the library |
137 |
| |
Create the Data Area CLSTQRY |
137 |
| |
Appendix C. IBM's Display File Description (DSPFD) *OUTFILE'd Fields. |
139 |
| |
Appendix D. IBM's Display Object Description (DSPOBJD) *OUTFILE'd Fields. |
143 |
| |
Appendix E - Query Tips |
147 |
| |
G. Wayne Hawks Bio |
157 |