1 / 57

APPX Release 4.1

Conference - 2002. APPX Release 4.1. APPX 4.1 is the single, most significant release in the history of the product!. APPX Release 4.1. Three Major Areas of Focus. GUI Design by Specification RDBMS Enhancements Performance. APPX Release 4.1. OS Requirements. HPUX 11 AIX 4.3.3 Solaris 8

pearly
Download Presentation

APPX Release 4.1

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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. GUI Demo Application • Included with APPX 4.1 • Application DMO 00 • Database DMO • Requires APPX GUI Client APPX Release 4.1

  11. 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

  12. 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

  13. Window Attributes • Resource (Wallpaper) • Background Color • Border Style • Border Color APPX Release 4.1

  14. 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

  15. Pull-Down/Right-Click Menus • Separator Lines (Before/After) • Invisible? • Enabled? • Menu Item Tooltips APPX Release 4.1

  16. 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

  17. Named Resources • Graphic formats supported • GIF • Animated GIF • JPEG • BMP APPX Release 4.1

  18. 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

  19. 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

  20. 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

  21. File Level Event Points • Possible uses • Enforcing referential Integrity between files • Key change • Delete related records • Updates to related files APPX Release 4.1

  22. 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

  23. “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

  24. “Fast” Queries • “Designed” fast queries • Optimize complex selection logic • New event point • ESTABLISH PCF RANGE • New subroutine • PROCESS QUERY RECORD APPX Release 4.1

  25. “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

  26. “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

  27. RDBMS Interfaces • Major rewrite of RDBMS interfaces • Significantly improved performance • Major new features • Support for more databases APPX Release 4.1

  28. 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

  29. 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

  30. 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

  31. 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

  32. 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

More Related