APPX Release 4'1

1
Conference - 2002
APPX Release 4.1
2

• APPX 4.1 is the single, most significant release
  in the history of the product!

APPX Release 4.1
3
Three Major Areas of Focus

• GUI Design by Specification
• RDBMS Enhancements
• Performance

APPX Release 4.1
4
OS Requirements

• HPUX 11
• AIX 4.3.3
• Solaris 8
• Windows NT 4 SP6
• Windows 2000
• Red Hat Linux 6.2
• SCO 5.0.4p
• NCR SVR4 MP RAS 03.02.00.39
• OS400 5.1

APPX Release 4.1
5
RDBMS Requirements

• Oracle 7, 8
• Sybase 12
• DB2 6.1 (Windows NT/2000)
• DB2 7.1 (Unix)
• SQL Server 2000
• Access 2000

APPX Release 4.1
6
Upgrade Considerations...

• OS Release
• RDBMS Release
• Data files are compatible
• Design files changed
• Design files cannot be downgraded

APPX Release 4.1
7
FREE Features in APPX 4.1!!!

• APPX Reportwriter (SQL)
• APPX Client (GUI)
• APPX/ODBC Driver
• Language Translation
• Four sessions per user
• Web Interface to APPX Backend
• APPX Client in a Browser
• APPX/Net

APPX Release 4.1
8
Only Four Chargeable Items!!!

• User Rights
• Designer Rights
• RDBMS Interfaces
• Maintenance
• Software Updates
• Tech Support

APPX Release 4.1
9
GUI Design by Specification

• Menu processes
• Input processes

APPX Release 4.1
10
(No Transcript)
11
GUI Demo Application

• Included with APPX 4.1
• Application DMO 00
• Database DMO
• Requires APPX GUI Client

APPX Release 4.1
12
GUI Menus/Inputs

• Title Bar
• Wallpaper/Background Color
• Pull-down Menus
• Toolbar buttons
• Right-Click Menu
• Buttons
• Frames
• Labels
• Pictures
• Fields

APPX Release 4.1
13
Title Bar Attributes

• Title bar Color
• Title Text
• Text Alignment (Left/Right/Center)
• Text Font/Scaling/Style/Color
• Resource (Icon)
• Buttons (Help/Return/End)

APPX Release 4.1
14
Window Attributes

• Resource (Wallpaper)
• Background Color
• Border Style
• Border Color

APPX Release 4.1
15
Pull-Down/Right-Click Menus

• Defined as GUI Attributes of Optional Children
• Multiple pull-down menus
• Multiple pullout menus
• Menu Item Resource (Icon)
• Menu Item Icon location (Left/Right of text)
• Shortcut keys
• Menu Item Text (Font/Scaling/Style/Color)
• Menu Item Background color

APPX Release 4.1
16
Pull-Down/Right-Click Menus

• Separator Lines (Before/After)
• Invisible?
• Enabled?
• Menu Item Tooltips

APPX Release 4.1
17
Named Resources

• Isolate graphics from application
• Different graphic for each state
• Identifies graphic location type
• Server
• Client
• Identifies graphic location
• Pathname
• url

APPX Release 4.1
18
Named Resources

• Graphic formats supported
• GIF
• Animated GIF
• JPEG
• BMP

APPX Release 4.1
19
(No Transcript)
20
(No Transcript)
21
(No Transcript)
22
(No Transcript)
23
(No Transcript)
24
Cached Files

• Stored in memory
• Implemented via ILF statements
• CREATE
• SCRATCH
• OPEN
• Possible uses
• Increase runtime performance
• Constrained Scans
• Temporary copy of disk file

APPX Release 4.1
25
(No Transcript)
26
Desktop Integration via the APPX Client

• Client-side printing
• Send file to client
• Retrieve file from client
• Run a document on client
• Run a program on client

APPX Release 4.1
27
(No Transcript)
28
(No Transcript)
29
File Level Event Points

• Triggered by file I/O
• Defined as rules for a file
• File Open
• Post Read
• Pre Update
• Post Update
• File Close

APPX Release 4.1
30
File Level Event Points

• Possible uses
• Enforcing referential Integrity between files
• Key change
• Delete related records
• Updates to related files

APPX Release 4.1
31
(No Transcript)
32
APPXIO

• Support for variable length records
• Support for compressed records
• Save disk space
• Quick restructures
• Support for larger file sizes
• Up to 4GB for Unix
• Up to 2GB for Windows

APPX Release 4.1
33
(No Transcript)
34
Fast Queries

• Automatic Fast Queries
• Query record selection will use indexes
• APPX will pick the best index to use
• Designer can supply hints
• BEG AT
• END AT
• APPX will skip the sort if possible
• APPX will sort in memory if possible
• APPX_RUN_MEM
• APPX_DISK_SORT_THRESHOLD

APPX Release 4.1
35
(No Transcript)
36
Fast Queries

• Designed fast queries
• Optimize complex selection logic
• New event point
• ESTABLISH PCF RANGE
• New subroutine
• PROCESS QUERY RECORD

APPX Release 4.1
37
(No Transcript)
38
(No Transcript)
39
True Subroutines

• ILF Statements
• PASS statement enhanced
• RECEIVE statement implemented
• Use with
• GOSUB
• Process invocation ILF statements
• Automatic/Optional child processes
• Nested subroutine calls supported

APPX Release 4.1
40
True Subroutines

• PASS Statement
• Pass arguments to subroutines
• Returned results from subroutines
• RECEIVE Statement
• Receive arguments
• Automatic data type conversion
• Localize variables

APPX Release 4.1
41
(No Transcript)
42
(No Transcript)
43
RDBMS Interfaces

• Major rewrite of RDBMS interfaces
• Significantly improved performance
• Major new features
• Support for more databases

APPX Release 4.1
44
RDBMS Interfaces

• Significantly improved performance
• Quick restructures
• Use ALTER TABLE when possible
• Faster record I/O
• SQL Statement Caching
• Retrieve rows by Row ID
• Partial Record I/O
• Cached Files

APPX Release 4.1
45
RDBMS Interfaces

• Major new features
• Commit
• COMMIT statement
• Process Commit Mode
• Compatibility
• PCF Cycle
• End
• Manual
• Rollback
• ROLLBACK statement
• SAVE PNT statement

APPX Release 4.1
46
RDBMS Interfaces

• Major new features
• Field Overrides when creating tables
• Field Name
• Field Type
• Nullability
• Table Sizing when creating table
• FMS Group enhanced
• Better data type conversions

APPX Release 4.1
47
RDBMS Interfaces

• Support for more databases
• Oracle
• ODBC for Windows
• MS SQL Server
• MS Access
• DB2 (Beta status)
• Sybase (Beta status)
• ODBC for Unix/Linux (Beta status)

APPX Release 4.1
48
RDBMS Interfaces

• FMS Groups
• Replaced control strings with specifications
• Added Table sizing options
• Added a few RDBMS runtime options
• Added Identities for remote logins
• User IDs
• Passwords

APPX Release 4.1
49
(No Transcript)
50
(No Transcript)
51
Data Dictionary Importer (0UT)

• Oracle table
• MS SQL Server
• Text Files

APPX Release 4.1
52
Application Generator

• Generates
• Menus
• File Maintenance
• Transaction Entry
• File Lists

APPX Release 4.1
53
APPX/ODBC Driver for Windows

• Fixed all known bugs
• New version of asql table importer
• Prompts for Login
• Prompts for host/port
• Prompts for Database/Application
• Improved reliability
• Improved performance

APPX Release 4.1
54
APPX/ODBC Driver for Windows

• Client Applications
• Prompt for login
• Validate Server login
• Validate APPX login
• Run File Level Event Points
• Enforce APPX Data Security
• Enforce APPX Key Protection

APPX Release 4.1
55
APPX/ODBC Driver for Windows

• Enforce APPX Data Security
• File Read/Modify
• Field Read/Modify
• Record Access
• Enforce APPX Key Protection
• Key Change
• Key Delete

APPX Release 4.1
56
Auto-GUI for Character Mode Applications

• Buttons on menu and input images
• Pull-down menu
• System (Direct Process 1)
• Application (Direct Process 2)
• Process (Current Process)
• Title Bar with buttons
• Check boxes for Logic fields
• Horizontal scrolling
• Scrolling text fields

APPX Release 4.1
57
Auto-GUI for Character Mode Applications

• Scan indicators (Binoculars)
• PCF scan
• DLU scan
• List box for token fields
• Scrolling screens
• Boxes around column headings
• Separator lines between fields and records
• Scroll bar

APPX Release 4.1