Transcript No Slide Title - The WA Franke College of Business

SESSION: ENTER SESSION
SPEAKER: ENTER SPEAKER
Web to Oracle Using Net
Express and OO Cobol
Alden C. Lorents
College of Business
Northern Arizona University
Flagstaff, AZ
[email protected]
Introduction
• Next Wave After Y2K
– Web Development
– E-Commerce
– Linkage to Existing Systems
– Web, Java and Cobol
• Project to teach Web/Existing
System Integration using Net
Express
Project Components
• Web Component
– Forms and CGI Development
– Java Script
• Data Base Component
– Database Interface to Oracle
– OO Cobol
– Oracle Database Running on an NT
Server
• Building, Packaging and Testing
Figure 1 Project Components
DBI.PCO
Oracle
Libraries
Oracle
Pre compile
DBI.CBL
Net Express
Build
CGI.EXE
CPY, CPV, CPF
Files
Java
Script
Web
Window
Build
Form & CGI
Build
HTML
Forms
Web
Window
Net Express
Test Process
CGI.CBL
Business
Logic
Execute
Database
Solo Web
Emulator
Oracle SQL
and Libraries
Building the Web
Component
• Net Express IDE
– Building the Input and Output Forms
with Form Designer
– Copy file generation from Designer
– Generating the CGI
– Adding Business Logic
– Adding Java Script
Input Form and IDE
Output Form and IDE
Form Designer Generated CPY
Form Designer Generated CPV
Form Designer Generated CPF
Generating the CGI
Partial List from Generated CGI
Adding CGI Data Division Entries
Adding CGI Business Logic
Generated Input HTML
Java Script Added to Input HTML
Generated Output HTML
Database Interface Component
• The PCO Source File
– Embedded SQL
– OO Structure and Methods
• The Oracle Precompile Process
– Error Correction
• The Cobol Compile Process
Partial DBI Source (PCO)
DBI Oracle Logon Method
DBI Read-Reservation Method
Oracle Precompile Process
Precompiled Read-Reservation
Compiling the DBI
Building and Testing
• Building the Executable
• Testing using Solo
– Animating
• CGI Animation
• DBI Animation - SQL Calls
– Testing the Java Script
• Migration to the Web Server
– Oracle Client
– Micro Focus OO Support
Net Express Build Set UP
Net Express Build Process
Testing Data Validation
Testing Good Data
Output From a Successful Test
Future Development
•
•
•
•
Multiple Web Form Interaction
More Robust System of Queries
Database Updating
Moving the System to a Web
Server
– Oracle Client
– Micro Focus OO Support