Table of Contents

Introduction

 

1. Getting Started

1.1. Starting WOW

1.2. Signing on to WOW

1.3. User Registration

 

2. Creating Connections

2.1. Creating a Connection Definition

2.2. Connecting to Different Databases

2.3. Working With Connections

 

3. Creating Applications

3.1. Defining the Application

3.2. Application Libraries

3.1.1. Application Libraries Overview

3.1.2. Creating Application Libraries

3.1.3. Using Application Libraries

3.1.4. Using the CPYWOWENV Command (AS/400/iSeries only)

3.3. Controlling the Login

 

4. Creating User Operations

4.1. User Operations

4.2. SQL Operations

4.3. HTML Code Operations

4.4. Other Operation Types

4.5. Controlling the Display Order of Operations

4.6. Using a Please Wait Page

 

5. Selecting Records

5.1. Basic SQL Queries Using the SELECT Statement

5.2. Other Queries using the SELECT Statement

5.3. Tips: Setting Key Position Field to Select Unique Records

5.4. SQL Tips

5.4.1. Case Sensitivity

5.4.2. Optional Values

 

6. Inserting Records

6.1. Basic SQL Queries using the INSERT Command

6.2. Inserting Records without SQL Commands

6.3. Inserting Records Using Parsing

6.4. Joined Inserts

 

7. Updating Records

7.1. Basic SQL Queries using the UPDATE Command

7.2. Using a WHERE clause with the UPDATE statement

7.3. Joined Updates

 

8. Deleting Records

8.1. Basic SQL Queries using the DELETE Command

8.2. Using a WHERE clause with the UPDTE statement

8.3. Joined Deletes

 

9. Field Descriptors

9.1. Field Descriptors Overview

9.2. Field Descriptor Manager

9.3. Editing Rows within the Field Descriptor Manager

9.3.1. Case Sensitivity

9.3.2. Display Settings

9.3.3. Possible Value Settings

9.3.4. Advanced Settings

9.3.5. Authorization Settings

9.3.6. Additional Settings

9.3.7. Database Settings

9.4. Field Descriptor Views

9.4.1. Table FD’s

9.4.2. Shared FD’s

9.4.3. UsageIds

9.4.4. Search By

9.4.4. Quick Edit

9.5. Prompting Using Field Descriptors

9.6. Other Field Descriptor Notes

 

10. WOW Features

10.1. Derived Fields

10.2. Parameters

10.2.1. SQL Prompt Parameters

10.2.2. Field Descriptor Prompt Parameters

10.2.3. Row Parameters

10.2.4. User Parameters

10.2.5. Usage ID Parameters

10.2.6. Table Parameters

10.2.7. Parameter Parameters

10.2.8. Context Parameter Parameters

10.2.9. Runtime Parameters

10.2.10. Defaulting Parameter Values

10.3. Operation Property Groups

10.3.1. AutoRun { }

10.3.2. Browser { }

10.3.3. Chart { }

10.3.4. Config { }

10.3.5. CSV { }

10.3.6. DetailDisplay { }

10.3.7. DisplayColumns { }

10.3.8. Distribution { }

10.3.9. Email { }

10.3.10. LayoutDisplay { }

10.3.11. OperationLabels { }

10.3.12. OperationSettings { }

10.3.13. OptionalSignon { }

10.3.14. Paging { }

10.3.15. PDF { }

10.3.16. PleaseWait { }

10.3.17. ReportBreak { }

10.3.18. SignOn { }

10.3.19. StoredProcedure { }

10.3.20. Styles { }

10.3.21. TableDisplay { }

10.3.22. Tabs { }

10.3.23. XLS { }

10.4. Creating Reports

10.4.1. ReportBreaks { }

10.4.2. Header/Detail Reports

10.5. Associations

10.5.1. Creating Associations

10.5.2. Associated Inserts

10.5.3. Associated Updates

10.5.4. Associated Deletes

10.5.4. Join Associations

10.6. Possible Values

10.6.1. Multiple Fields in Possible Values Drop Down

10.6.2. Possible Values and the – All – Value

10.6.3. Removing – Next – and – Previous – from Possible Value List

10.6.4. Possible Values Paging (Next/Previous)

10.6.5. Possible Value Keys

10.6.6. Possible Values Selector

10.6.7. Possible Values Search

10.7. Creating and Distributing Automatic Reports

10.8. Logging Email

10.8.1. Database Files Required for Mail Logger

10.8.2. Create a WOW Mailer application

10.9. Auto Population of Fields

10.10. Blob File Upload and Download

10.10.1. Set Up File Upload

10.10.2. Set Up File Download

10.11. Work Flow

 

11. Replacement Libraries Support

11.1. What is Replacement Library Support

11.2. Four Ways to Implement Replacement Library Support

11.2.1. WOW Based

11.2.2. Field Descriptor Prompt Parameters

11.2.3. Application Based

11.2.4. User Based

11.2.5. URL Based

11.3. Replacement Library Implementation Precedence

 

12. Charts, Graphs, and Images

12.1. WOW Chart API

12.2. Creating Charts

12.3. Chart Properties

12.4. Chart Examples

12.5. Referencing Images

12.5.1. Image URL Reference Field Class

12.5.2. Using SQL For Static Images

12.5.3. Using SQL For Dynamic Images

12.5.4. Relative Image Paths in WOW

 

13. Tabs

13.1. Tab Overview

13.2. Creating Tab Operations

13.3. Using Tabs

13.4. Tab Configuration

13.4.1. Default Tabs

13.4.2. Tab Fields

13.4.3. Tabs Per Line

13.4.4. Automatic Tab View

13.4.5. Allowing Tab Display

13.4.6. Empty Tab Results

13.4.7. Changing Tab Field Order

13.4.8. Hiding Search Parameters

13.5. Further Tab Customization

 

14. Stored Procedures

14.1. Stored Procedure Overview

14.2. Calling Basic Stored Procedures

14.3. Passing Parameters to Stored Procedures

14.4. Inserting, Updating, and Deleting

 

15. Running Your Applications

15.1. Running SQL Queries and Operations

15.2. Running WOW Applications by URL

15.2.1. Running Applications in Application Libraries

15.3. Directly Executing Operations

15.3.1. Passing Parameters

 

16. Creating Custom Themes

16.1. Saving HTML from the Web

16.2. Creating Custom Theme Folders

16.3. Creating Header and Footer JSPs(Java Server Page)

16.4. Cascading Style Sheets (CSS)

16.5. Configuring the Header and Footer

 

17. Further Customization

17.1. Customization Overview

17.2. Customization Example: Adding a Hyperlink

17.3. Customizable JSP’s

 

18. WOW File Server

18.1. WOW File Server Setup

 

19. WOW Security Protocols

19.1. Securing Applications

19.1.1. Local Users Only

19.1.2. Local Users Only or Operating System Profile

19.1.3. Operating System Profile

19.1.4. Personal Connection Pool

19.1.5. HTTP Referrer

19.1.6. SQL Operation

19.1.7. Unsecured

19.1.8. User List Authentication Operation

19.2. Securing Operations

19.3. Optional Sign On

19.4. Table Authorization

19.5. Securing Fields and Operations with User Authorization Operations

 

20. Deploying Applications

 

21. WOW Utilities

21.1. WOW Utilities Overview

21.2. Users

21.3. Themes

21.3.1. Dynamic Themes with URL Parameter

21.4. Keyed Values

 

22. Interfacing WOW with Excel

22.1. Creating Reports and Graphs with WOW and Excel

22.2. WOW Setup for Excel Web Query

21.3. Creating and Updating Excel Tables from WOW Web Data

22.4. Integrating WOW with Existing Excel Files

22.5. Setting WOW Operations to Use Existing Excel Templates

22.6. Creating Reports From Data Imported From WOW Into Excel

22.7. Restrictions

 

23. Utilizing Existing RPG Applications

23.1. Calling an RPG Program That Returns a Result Set

23.1.1. Add Code to Return a Result Set

23.1.2. Defining the Stored Procedure

23.1.3. Defining the WOW Operation

23.2. Calling an RPG Program That Returns a Multiple Occurrence Data Structure (Array) in RPG Free

23.2.1. Add Code to Return a Result Set

23.2.2. Defining the Stored Procedure

23.2.3. Defining the WOW Operation

23.3. Calling an RPG Program That Returns a Multiple Occurrence Data Structure (Array) in RPG IV

23.3.1. Add Code to Return an Array

23.3.2. Defining the Stored Procedure

23.3.3. Defining the WOW Operation

23.4. Calling an RPG Program That Returns Parameters

 

24. WOW Performance

24.1. Basic Overview

24.2. WOW's Built In High Performance Cache

24.3. Connection Properties

24.4. Controlling the Number of Records Returned

24.5. Controlling the Number of Fields Read

24.6. Optimizing SQL Performance for AS400 (iSeries)

24.6.1. Compare SQL Performance Against Non-WOW Methods

24.6.2. Using STRDBG

24.6.3. Using iSeries Navigator (STRDBMON)

24.6.4. Controlling How the Data is Accessed

24.7. Tomcat Server Performance

 

25. Troubleshooting and Debugging WOW

25.1. My iSeries DB2 files are locked by WOW which is affecting my saves and other programs.

25.2. WOW not able to connect IBM iSeries Metadata Server because of restricted ports.

25.3. Change User Name and Password of WOW for new metadata system

25.4. Configuring Logging (Log4j)

25.5. Running a SQL Statement with Period in the name of a Database Table

25.6. When Running WOW off of a Linux or Unix machine and with MySQL, some operations don’t work

25.7. When creating a row, the Current Date *CURRENT returns the wrong date

 

26. WOW Administration and Support

26.1. Backing Up WOW Metadata

26.2. Disaster Recovery

26.3. Version Control

26.3.1. Web Resources (Java, JSPs, HTML, etc)

26.3.2. Metadata

26.4. Web Application Server Information

26.5. Getting Support for WOW

26.6. WOW Copyright Information

 

Appendix A. UsageId Specification