PWB514 — PowerBuilder to Web Using Appeon to Get to the Web Fast

1. PWB514 — PowerBuilder to Web Using Appeon to Get to the Web Fast Rex GeisslerAppeon Product EvangelistRex.Geissler@sybase.com / 303-409-7887August 5th, 2003

2. Appeon Technical Overview • Web Business Drivers & Pains • Appeon Web Application Overview & Demonstration • Appeon Product Overview • Appeon Development Overview & Demonstration • Appeon Deployment Overview & Demonstration • Appeon Enterprise Manager Overview & Demonstration • Appeon Server Overview • Appeon Security Overview • Appeon Web Application Sizing & Performance Example • Appeon Documentation

3. PowerBuilder New Features • XML DataWindow • XML Import and Export Templates customizable for each DataWindow • Apache Xerces PowerScript XML parser used with cross platform portability • Java Server Page application development • Web Services Access • Fully compliant with WSDL 1.1 and SOAP 1.1 specifications • Automatically parse a WSDL file and generate a web services proxy object • Save As XML & PDF capability • EJB Connectivity • ORCA Batch Script Features • PBNI with C++ • DataWindow Print and SaveAs functions for Solaris (PB 8.0.3) • Memory usage (new memory manager – PB 8.0.3) • DataStore (non-visual DataWindow) with no Windows Handles(8.0.3) • Pocket PowerBuilder PocketPC Development – separate license

4. Business Drivers/Pains & Need for Web Browser • Fastest creation of Web apps w/ RAD/4GL tool and Rich-Client GUI to sell • Minimize the cost and dependence on continual user PC hardware upgrades and user PC software upgrades and purchases • Speed up the enhancement and maintenance process through server apps • Remove the requirement for continual desktop deployment/enhance apps • Remove the requirement for deploying the large Fat Client Virtual Machine or PBVM for the first deployment and for every version upgrade (7, 8, 9, 10…) • Remove the need for Screen-scraping Emulation Servers (Citrix, Win TS, etc.) • Reduce the network bandwidth resources required for applications • Support Web Standards dictated by architecture groups in the Marketplace, Corporation, Division, or Department • Support external users for web applications • Employees on the road, Remote internal employees, Partners, Customers • Enterprise Portal natural step for business content with dozens/hundreds of windows

5. The Appeon goal is to transform the vast majority of Client/Server PowerBuilder application code into a Web application with the click of a button Appeon works inside PowerBuilder to convert PB code to a Web Browser Appeon™ for PowerBuilder® - RAD/4GL GUI Web Rich-Client GUI in Thin-Client Browser with Fastest 4GL/RAD Dev IDE

6. Appeon™ for PowerBuilder® - RAD/4GL GUI Web Rich-Client GUI in Thin-Client Web Faster Development J2EE/.NET

7. Appeon Demo - Appeon_Code_Examples Demos on www.try.sybase.com

8. Appeon Demo - Appeon_Code_Examples Demos on www.try.sybase.com

9. Appeon™ for PowerBuilder® - RAD/4GL GUI Web Rich-Client GUI in Thin-Client Browser with Fastest 4GL/RAD Dev IDE • Demo Appeon Code Examples and the power of the Rich-Client GUI in a Thin-Client Web Browser

10. Web Solution Landscape 2003 PowerBuilder with EAServer Partner or SPS Framework UI Sophistication PowerBuilder with EAServer Only Slow, Complex, Costly Effort/Time/Cost to Market(Objects to the right take more time and more effort)

11. Appeon Customer Quotes Rich-Client GUI in Thin-Client Browser with Fastest 4GL/RAD Dev IDE • "The PowerBuilder/Appeon Web RAD solution is significantly shorter than a Java rewrite ever would be. I had an experienced Java/J2EE programmer looking over my shoulder and the guy was ‘blown away’ with the Appeon product and with the speed of development in PowerBuilder. My account manager is a strong proponent of Oracle and Java solutions, and has been pushing me to convert the apps to run on Oracle solutions only. However, after testing the Appeon converted web application, my manager is convinced that Appeon's revolutionary approach is the way to go, and told me that the Appeon web architecture and our applications are light-years ahead of J2EE, Oracle and .NET. Our Appeon web applications are not trivial and I converted them to the web using a service-based framework like PowerBuilder's complex PFC framework and I used 5 levels of Window ancestor inheritance and 4 levels of User Object ancestor inheritance as well as many DataWindow features and different DataWindow Presentation Styles including Graph and Composite DataWindows."

12. Appeon Business Benefits Rich-Client GUI in Thin-Client Browser with Fastest 4GL/RAD Dev IDE • For Businesses: • Leverages Dozens or Hundreds of Man-years of Investments for Web Applications & Enterprise Portals • Extends Applications to remote End Users for 24x7 productivity over the Internet • Improve cash flow and transaction throughput by moving apps to remote employees, partners and customers • Improved Customer Satisfaction • For End Users: • Increase User Productivity (Practically identical GUI in Web as in Client/Server) • No Re-Training Expenses • No User Frustration with Appeon whereas legacy web applications promote weak HTML user interface • For Developers: • Focus on Business Issues not N-Tier, Architectural, and Technology problems – this is why PB C/S popular • Fastest Way to move much PB code to the Web • Increases Productivity Tremendously & Experience with 4GL/RAD IDE – many times faster J2EE & .NET • Standard for all new web application development for many customers • Low Risk With Time-Tested Code, GUI, & Business Logic • Leverage existing investment and maturity of Client-Server apps for Web Applications & Enterprise Portals

13. Appeon Technical Benefits Rich-Client GUI in Thin-Client Browser with Fastest 4GL/RAD Dev IDE • Best ROI • Reuse most PowerBuilder object types: PowerScript code, Event-driven architecture, OOP, and embedded SQL • Windows, DataWindows, Menus, Toolbars, Visual User Objects, NVOs • Standard, Easy, Straight-Forward Programming • Code and Maintain with straight-forward PowerBuilder C/S coding • Single PowerBuilder (PB) Code Base Possible for both C/S and Web • Requires No Coding in HTML, JavaScript, JSP, EJB, J2EE, or .NET • Deploy to a true web architecture quickly • No need to Re-architect, Re-design and Re-write Applications from scratch or to memorize constantly changing specifications, new IDEs, new languages, etc. • No need to Re-architect, Re-design and Re-write Navigational GUI • Automatic Point & Click Features added to web applications (Adobe Acrobat PDF, Microsoft Excel, Text files, Filtering, Sorting, and Find records) • Rich client GUI minimizes network and the server usage • Robust Security Support • SSL/HTTPS, Firewall/Port 80, Appeon Security, LDAP, Application Timeout, Built-in Application Security, Business Logic Encryption, Digital Certificates • High Scalability & Load Balancing

14. 5 PowerBuilder-to-the-Web Options • Complete Rewrite in Java/J2EE, HTML, and JavaScript • Complete rewrite of everything taking years and costing a lot of money • Complete Rewrite in .NET, HTML, and JavaScript • Complete rewrite of everything taking years and costing a lot of money • PowerBuilder and EAServer Only • Reuse all DataWindows (60-95% of avg. app) and all Business Logic NVOs (0-15% of avg. app) • Rewrite user interface and navigation with JSPs and JavaScript taking months and suggest Partner/SPS Framework/Help on first project • PowerBuilder and EAServer with Partner/SPS Frameworks • Reuse all DataWindows (60-95% of avg. app) and all Business Logic NVOs (0-15% of avg. app) • Rewrite portions of every window or web page taking weeks or months • PowerBuilder with Appeon – Complete PowerBuilder Server • Reuse all Windows (30-50% of avg. app), all DataWindows (60-95% of avg. app), all Menus/Toolbars, all User Objects & NVOs (0-30% of avg. app), and most PowerScript code • Rewrite or remove any unsupported features taking days or weeks

15. Appeon Languages in Unicode Supported Languages for text in the Graphical User Interface (GUI) of the application and application data from the database • English • Simplified Chinese • Traditional Chinese • Japanese • Korean Other languages plan to be certified on future releases Customers using Spanish today

16. Appeon Database Support Databases certified for SQL DataWindows, Embedded SQL, Dynamic SQL, and many Stored Procedures • Sybase ASE 12.x • Sybase ASA 7.x and 8.x • Oracle 8i and 9i • Microsoft SQL Server 2000 • IBM DB2 UDB 8.1 (certified in 2.6) • Informix (used by customers but not certified)

17. Security • Firewall Security • HTTP over Port 80 so Appeon can take advantage of Firewalls and does not propose a security threat • Authentication Security • LDAP Authentication Security – Applications, Groups, and Users • Appeon Authentication Security – Applications, Groups, and Users • SSL (HTTPS) Encryption Security • Application Timeout Security • Direct URLs Security • Built-in PowerBuilder Application Security • Business Logic Encryption Feature Security • Protects customer’s intellectual property and hacking • Database Role Security • Proxy the database userid for Sybase ASE and Sybase ASA • Digital Certificates Security

18. Unsupported Features In Web Browser and Appeon • Two Types of Unsupported Features • Web Browser Limitations or Standards (i.e. No JavaScript GOTO, Security paradigm dictates no Client OS access, etc.) • Appeon Unsupported Features (Appeon supports a tremendous amount today but just like your apps have deadlines and cutoffs, Appeon has to stop coding at some point for each release like 2.5, 2.6, 2.7, 3.0, etc.) • External Applications to the PowerBuilder Application (Browser sandbox security limits this support) • File Functions (Browser sandbox security limits this support) • Registry Functions (Browser sandbox security limits this support) • Miscellaneous Properties and Functions in the thousands of PowerBuilder features – See the Appeon Migration Guide and Appeon Supported Features Guide • GOTO, THROWS PowerScript Statements • i.e. Checkbox Control - BringToTop Property, RightToLeft Property, Other Event, etc. • Miscellaneous system functions and objects

19. Event Driven Achitecture with Database Connectivity GUI Architectures: Multiple Document Interface (MDI), Single Document Interface (SDI) PowerBuilder Objects: Application, Custom Class Non-Visual (NVO), Custom Visual User Object, DataWindow, Function, Menu/Toolbar, Standard Visual User Object, Structure, Window DataStore (Non-Visual DataWindow) Windows: Child, Main, MDI, MDIHelp, Popup, and Response windows Window Controls: CheckBox, CommandButton, DataWindow, DropDownListBox, DropDownPictureListBox, EditMask, GroupBox, Line, ListBox, ListView, MultiLineEdit, Picture, PictureButton, PictureListBox, RadioButton, Rectangle, SingleLineEdit, StaticText, Tab Folder, and TreeView PowerBuilder Supported Features

20. DataWindow Is The Power In PowerBuilder DataWindows Comprise 65-90% Of Existing Apps • Language-independent: • PowerBuilder • HTML • XML & PDF • Architecture-independent: • Two-tier • Distributed • Competitive: • Visual Basic – no DataWindow • Delphi – no DataWindow • J2EE – no DataWindow • 3rd Party components Sybase patented technology to: • Retrieve • Automatic Add/Update/Delete SQL • Present GUI • Report • Manipulate • Filter • Sort

21. DataWindow Presentation Styles: Composite, Crosstab, Freeform, Group, Graph, Grid, Nested, Label, N-Up, Tabular DataWindow Bands: Header, Detail, Footer & Summary DataWindow Buffers: Primary, Filter, Delete, every item status DataWindow Data Sources: SQL, Query, Stored Procedure, External DataWindow Column Style Types: Edit Mask, Format Style, Edit, CheckBox, DropDownDataWindow, DropDownListBox, and RadioButton DataWindow Child: GetChild with almost all DataWindow functions DataWindow Controls: Button, Column including Computed Column, Computed Field, Text DataWindow Describe & Modify DataWindow Dot Notation DataWindow Expressions & Operators DataWindow Validation Rules DataWindow Printing & SaveAs Automatically (No Coding) for Adobe Acrobat PDF, Microsoft Excel & Text DataWindow Is The Power In PowerBuilder DataWindows Comprise 65-90% Of Existing Apps

22. PowerScript Statements Reserved Words Pronouns (This, Parent, Super) Identifiers Operators & Expressions ASCII Characters (~n, ~t, etc.) Data Types & Constants Arrays Null Values Statement Continuation/Separation Comments OOP: Inheritance, Encapsulation, Polymorphism System Events & Functions User Defined Events & Functions Global and Object Events & Functions Triggering & Posting Events Static Calls to Events & Functions Dynamic Calls to Events & Functions Extending, Overriding, and Overloading Events & Functions Arguments & Return Values Structures Embedded SQL Dynamic SQL Transaction Management Statements Cursor Statements Database Stored Procedures PowerScript Supported Features

23. Step 1 – Develop Quickly create new PowerBuilder Client/Server Windows and DataWindows using Appeon supported features Three Steps to the Web for New Applications Build Products to Sell Worldwide – Faster Development J2EE/.NET • Step 2 – Test • Test PowerBuilder application in the PowerBuilder IDE • Step 3 – Deploy • Click Appeon Wizard • Choose Deployment Profile (Local, Dev, Test/QA, Prod) • Choose Deployment Mode (Full, Incremental, Previous) • Auto-Create HTML, XML, and JavaScript

24. Step 1 – Analyze Appeon scans the entire PowerBuilder application, flagging any Web browser or Appeon unsupported incompatibilities found Three Steps to the Web for Existing Applications Convert Apps to Web – 100s or 1000s times faster dev than J2EE/.NET • Step 2 – Modify & Test • Rewrite or remove any unsupported PB features or code using standard PB programming • Test in PB IDE • Step 3 – Deploy • Click Appeon Wizard • Choose Deployment Profile (Local, Dev, Test/QA, Prod) • Choose Deployment Mode (Full, Incremental, Previous) • Auto-Create HTML, XML, and JavaScript

25. Appeon Developer • PowerBuilder IDE GUI Toolbar • Easy Wizard and Property Sheet Driven Dialog Windows • No Appeon Coding • PowerBuilder to Web Previews • Configure Web Application & Appeon Server Environment • Deploy Web Application • Run Web Application • Undeploy Web Application • DataWindow Repository (Automatic Reporting & Update Web Application) • AEM (Appeon Enterprise Manager) • Appeon Help

26. Appeon Enterprise Manager (AEM) • A GUI Web-based application that manages the transformed Web applications and the Appeon Server over the Internet, an Intranet or an extranet, and includes a comprehensive set of easy-to-use tools for system configuration, system maintenance, and performance optimization.

27. Appeon Server – 6 Patents Pending • Appeon Server (Runtime Server Components) • No client downloads for Plug-ins, Java applets, Java Virtual Machines, Flash, or ActiveX! • All files (e.g. XML, HTML, JPG, PDF, JavaScript, JScript, etc.) are downloaded by a standard HTTP request for the file from the Web server and not through any applets • Java and PowerBuilder Components and Servlets that provide run-time services for the deployed Web application, such as Database Connectivity & Pooling, DataWindows Support, PowerBuilder Virtual Machine (PBVM) support, Transaction Management, Printing, and Security • Stateless components for excellent N-Tier performance • Appeon removes printing issues with Adobe Acrobat PDF • Minimizes round-trips through JavaScript web library • The run-time environment that supports a PowerBuilder-style graphical user interface (GUI) on a standard browser • Uses only web standards with HTML, XML, JavaScript, LDAP, and Web Security

28. Appeon™ for PowerBuilder® - RAD/4GL GUI Web Rich-Client GUI in Thin-Client Browser with Fastest 4GL/RAD Dev IDE • Demo Appeon Developer All Toolbar Icons • Inherit New PowerBuilder Window & Code Business Logic • Deploy Web Application • Demo Appeon Enterprise Manager (AEM)

29. Appeon Deployment Process Button • Exports PowerBuilder objects into source code • After export, can work on PB objects while deploy is going • Converts PowerBuilder source code into standard Unicode source code • Converts Unicode source code into XML files • Analyzes XML files for any unsupported features • Converts XML files into HTML, XML and compressed and encrypted JavaScript files • JavaScript has a 1-1 mapping with PowerScript statements as well as object and control properties • Deploys all Web Application files to the Appeon Server environments

30. Appeon Deployment Web App Files • Compression reduces the JavaScript file size by more than 50%

31. Web Server Database C/C++ PB Java JDBC Component Types Plug-in ODBC EJB MDB Active X/ COM Native TransMgmt JDMK LoadBalancing HighAvailability Repository ConnPooling JNDI JMS JAXP Threading Connectors Adapters Appeon Server Runtime Overview Client PC / AEM Appeon Server Dynamic Web Content HTML/JS XML Servlet JSP DataWindow Repository Appeon Server Web Server Microsoft IIS Apache iPlanet Netscape Web Services J2EE Custom SSL OS

32. Appeon Size & Performance Example • Appeon Web HTML, JavaScript, and XML files are all cached on the client permanently and not downloaded again unless there are enhancements at the server, which means very little network bandwidth is used. • Window HTML Files Size – 1 KB to 8 KB • Application Logic JavaScript Files Size – typically 1 KB to 30 KB depending on the amount of PowerScript in the objects – compressed • DataWindow Property XML Files Size – typically 1 KB to 50 KB depending on number of controls/properties • DataWindow Result Set Data XML Files Size - depends on the result set size being retrieved from the database • Retrieves 9,000 rows of data, converts them to XML, and downloads in about 3-4 seconds • DataWindows can also be cached locally for any length of time through the Appeon Enterprise Manager, which is extremely helpful for caching Code/Reference Tables that are DropDownDataWindows • Appeon Server JavaScript Web Library • Automatic, one-time only, browser-cached, compressed and encrypted JavaScript files

33. Documentation Resources • Appeon Release Bulletin • Appeon Introduction Guide • Appeon Installation Guide • Appeon Developer User Guide • Appeon Demo Applications Tutorial • Appeon Enterprise Manager User Guide • Appeon Migration Guide • Appeon Supported Features Guide • Appeon What’s New Guide • Appeon Help File

34. Appeon 2.6 Application Targets • New Client/Server PowerBuilder applications or enhancements • New Web-based applications to sell or distribute worldwide • Existing PowerBuilder Applications With Requirements • Simple to medium complexity application frameworks (no PFC until 2.7) • 25MB total application PBL size or less or break up based on whitepaper guidelines (50MB in 2.7) at at ftp://appeon:app30n@www.try.sybase.com/AppeonBreakUp.zip • Client/Server apps only (no N-Tier until 2.7) • Levels of inheritance should be 5 or 6 or less • The application user interface and/or data must be English, Simplified Chinese, Traditional Chinese, Korean, or Japanese • Database should be Sybase Adaptive Server Enterprise 12.x, Sybase Adaptive Server Anywhere 7.x or 8 .x, Oracle 8i or 9i, Microsoft SQL Server 2000, or IBM DB2 8.1 (Appeon 2.6 with limitations on Stored Procedures) • PowerBuilder 8.0.3 Build 9961 or above (Appeon 2.6)

35. Appeon 2.7 Application Targets • New Client/Server PowerBuilder applications or enhancements • New Web-based applications to sell or distribute worldwide • Existing PowerBuilder Applications With Requirements • No PowerTool or similar complexity application frameworks • 50 MB total application PBL size or less or break up app based on whitepaper guidelines located at ftp://appeon:app30n@www.try.sybase.com/AppeonBreakUp.zip

36. Appeon 2.6 Features – GA End of August Rich-Client GUI in Thin-Client Browser with Fastest 4GL/RAD Dev IDE • DataWindow Popup Menu Enhancements • IBM DB2 UDB 8.1 • Windows XP for Appeon Server & Appeon Developer • Registry defaults to Appeon Enterprise Manager for currency, date format, time format, etc. that PowerBuilder Client/Server uses from registry • Appeon Developer & Appeon Enterprise Manager Enhancements

37. Appeon 2.6 Features • DataWindow Enhancements • Controls: Edit Mask Enhancements, Line • Events: SQLPreview for Retrieve • Functions Web DataWindow: GetSQLPreview, SetSQLPreview • Properties: Enabled, SQLPreviewFunction, SQLPreviewType • Popup Menu Enhancements • Filter Rows Dialog • Find By Value In Selected Columns • Find Next • Find Previous • Sort Multiple Column Dialog

38. Appeon 2.7 Features – Beta October Rich-Client GUI in Thin-Client Browser with Fastest 4GL/RAD Dev IDE • Increase Deployment Performance 5-10 times faster • Increase Overall Runtime Performance multiple times faster • Several times faster performance for sample DataWindow retrieves • N-Tier Server-side Integration • Connectivity to Java/EJB, PB NVO, C/C++ DLL, COM/ActiveX Components on Application Servers • Connectivity to Web Services • Connectivity to Messaging Queues (MQSeries, JMS, etc.) • PowerBuilder Non-Visual Object (NVO) Component Support • No Web Browser or Appeon limitations on PowerBuilder NVO code running inside Appeon Server • Customer decides which PB NVOs to run inside Appeon Server and which to run in browser through encrypted JavaScript through simple checkbox • Customer Popup Menus

39. Appeon 2.7 Features • Certified to 5 levels and tested to 10 levels of inheritance • Dynamic SQL Format 3 • Codeless Dynamic DataWindow Cache Refresh for Automatic Browser-cached DataWindow XML data • Add Application Name to AEM Active Sessions & Transactions • Two Global Variables are added into Appeon Web Library that the PowerBuilder application can access to get the Authentication Userid that was logged in with for either Appeon Security or LDAP Security • Multiple application parsing to deploy multiple applications at once • Unsupported Features Analysis Report Enhancements • User Object Constructor and Destructor Events • Window List

40. Appeon 2.7 Features • DataWindow Functions: FindRequired, PopMenu, SetTabOrder • DataWindow Properties: Required, Syntax.Data, Table.Arguments • System Functions: KeyDown, PopMenu, SetFocus, SetPointer • Window Functions: PointerX, PointerY • Tab Control Inside Tab Control • Tab Page Enable Property, SelectTab Functions • Japanese Localization • Stress testing performance document • Parse applications through 50MB

41. Appeon Framework for PFC Features • Appeon Framework for PFC allows fast web development using PFC standards • The Appeon Framework will become a basis and standard for much new application development and enhancements, including Web-based, Portlet-based, and Client/Server-based potentially for all time to come • The Appeon Framework will be Appeon-compliant for automatic deployment to the web • The Appeon Framework will support the most-used PFC services and features • The Appeon Framework will have enhancements as well to the PFC • All Appeon work-arounds documented in the PFC code

42. Appeon Framework for PFC Features • PFC support based on version 8 syntax • All Appeon work-arounds documented in the PFC code • Appeon inheritance-collapsing technology built-in • Fast web development • Document upgrade path from PFC 5 to PFC 8 syntax • Context: PowerBuilder PFC support began in the fifth major version so Appeon is moving quickly, especially for web engineering development

43. Appeon Framework for PFC Features • Multiple inheritance levels supported with Appeon Inheritance-collapsing technology • PFC Naming Conventions & Standards • PFC Corporate Layer • PFC Extension Layer • PFC Windows • PFC NVO Services • PFC Standard Visual User Objects • PFC DataWindow Services & Features • PFC Controls • PFC Events • PFC Functions • PFC Structures

44. PFC Application Deployment Process • Swap the PFC*.PBL ancestor framework layer with the Appeon Framework’s PFC*.PBL • PFC work-arounds documented and PFC code commented out • Perform a PowerBuilder Full Build on the application and correct any errors that occur • Go through the normal Appeon development process • Look for Appeon unsupported features • Provide work-arounds for Extension PFC Layer, Corporate PFC Layer, and Application Code • Test the application in PowerBuilder • Deploy to the Web

45. Appeon 3.0 Feature Considerations Rich-Client GUI in Thin-Client Browser with Fastest 4GL/RAD Dev IDE • Client-side Integration for External Browser Application Support • Connectivity to external applications like Microsoft Outlook, Lotus Notes, Microsoft Word, Microsoft Excel, GIS Software like ESRI, MapInfo, MapPoint, OLE/DDE, etc. • System Function Types: File, Help, Printer, Registry • Secure ActiveX-based functionality • 90% DataWindow Result Set Compression • More language certification for Spanish, French, Hebrew, German, Greek, etc. • PowerCerv PowerTool Framework Replacement PBLs like Appeon Framework for PFC • JavaScript Runtime Debugger • JavaScript Runtime Debug Log • Automated batch scripts to initiate deployment wizard process • Add Connection Caches, Listeners, and Performance Properties into AEM • Pass parameters into the Appeon Web Application

46. AS AS AS AS WS WS WS/AS WS/AS Load Balancing and High Availability • Appeon Server Supports load balancing and high availability Clients Production Appeon Server Farm Production Web Server Farm A Development Test B C D

47. Frequently Asked Questions (FAQs) • Are both Internet Explorer and Netscape browsers supported? • Internet Explorer web browser has powerful functionality that together with Appeon's patent-pending technology, is able to make the PowerBuilder-style GUI possible on the Web. Since Internet Explorer uniquely provides this functionality and is currently used by 96% of Web browser users with that percentage continually going up along with the fact that even if IE is not the default web browser, it is usually available to the customers, Appeon has chosen to support Internet Explorer above. If customers are interested in investing substantially in this technology for other browsers, please contact Sybase Product Management.

48. Frequently Asked Questions (FAQs) • How can I work-around PowerBuilder Client/Server application local startup settings such as 1) database connection variables and 2) user preferences, since web browsers do not have access to the client PC file system for reading .INI/.TXT files through FileOpen() and FileRead() functionality or have access to the operating system for examining the Registry settings through RegistryGet() functionality? • 1) The database connection variables settings should be moved to the Appeon Server Connection Cache properties • 2) The user preferences should be moved into a user database table that includes the user login_id, the preference_type_id, and the preference_value that refer to a preference code/reference table that would have columns for preference_type_id and preference_description • 3) This functionality is already being built into the new Appeon Framework for PFC as well • 4) See the Appeon Migration Guide

49. Frequently Asked Questions (FAQs) • Can the Appeon Server run other components and business logic? Can the customer "reuse" custom NVOs to share them across other web applications? • There are no limitations on the Appeon Server that is purchased with Appeon, so the customer is free to deploy and reuse any number of PowerBuilder NVOs, EJBs, JSPs, Servlets, C, C++, and COM/ActiveX components to be used in any number of other N-Tier applications. However, performance should be a concern to consider if too many applications are placed on one server without clustering, etc.

50. Frequently Asked Questions (FAQs) • How can I work-around the PowerBuilder Drag N’ Drop feature that is unsupported? • Add command buttons with “Copy/Move >>" and "<< Copy/Move " that simply read through the DataWindow, looking for selected rows via DW.IsSelected(), and copy the rows to another DataWindow via DW.RowsCopy() or DW.RowsMove(), etc. See the Appeon Migration Guide.