PowerBuilder: Information from Answers.com Library Animal Life Business & Finance Cars & Vehicles Entertainment & Arts Food & Cooking Health History, Politics, Society Home & Garden Law & Legal Issues Literature & Language Miscellaneous Religion & Spirituality Science Sports Technology Travel & Places Q & A PowerBuilder Computer Desktop Encyclopedia: PowerBuilder Top Home > Library > Technology > Computer Encyclopedia A popular application development system from Sybase for Web, multitier and client/server development. It supports Java EE-branded application servers, such as Sybase EAServer, IBM WebSphere and BEA WebLogic, and DBMSs such as Sybase ASE, IBM DB2 and Oracle. PowerBuilder contains patented technology with its DataWindow capability and provides visual programming tools as well as a BASIC-like programming language called PowerScript. Included with PowerBuilder is InfoMaker, a report generation application. Download Computer Desktop Encyclopedia to your PC, iPhone or Android. Unanswered Questions New Answers Q&A Categories Coupons Guides Sign In | Sign Up Home Search Settings Top Contributors Help Center Home Answers Featured Videos: Top View more Technology videos Wikipedia on Answers.com: PowerBuilder Top Home > Library > Miscellaneous > Wikipedia PowerBuilder Developer(s) Sybase, a division of SAP Initial release July 1992 Stable release 12.5 [edit]  (12 August, 2011)fgh [±] Preview release Non [±] Written in C++ and C# Operating system Microsoft Windows Available in English, Japanese (Several languages supported for deployed applications) Type IDE License Commercial Website www.sybase.com/PowerBuilder PowerBuilder is an integrated development environment owned by Sybase, a division of SAP. It has been in use since 1991, peaking around 1998 with around 100,000 users.[1] While PowerBuilder's market share has diminished, many applications created with it are still in use. In 2010, Sybase released a major upgrade to PowerBuilder, intended to compete directly with Microsoft Visual Studio.[2] Sybase sells another programming language called PocketBuilder. It is based on PowerBuilder and used for creating applications that run on mobile devices such as cell phones or PDAs. Contents 1 Features 2 Usage 3 History 4 Summary of PowerBuilder features 4.1 RDBMS Interfaces 4.2 Integration with third-party software 4.3 Compilation and debugging 5 Criticism 6 Community 7 Some PowerBuilder Tools 8 References 9 External links Features PowerBuilder has a native data-handling object called a DataWindow, which can be used to create, edit, and display data from the database. This object gives the programmer a number of tools for specifying and controlling user interface appearance and behavior, and also provides simplified access to database content. To some extent, the DataWindow frees the programmer from considering the differences between Database Management Systems from different vendors. Usage PowerBuilder is used primarily for building business applications. PowerBuilder is used by some companies in the financial and telecoms sectors. However in recent years, PowerBuilder has seen substantial competition arise from Java development tools and from Visual Studio. There are a number of third-party tools that build upon and enhance the functionality of PowerBuilder, including Appeon for PowerBuilder, Visual Expert for PowerBuilder, and Enable Multilingual. History PowerBuilder was originally developed by PowerSoft in 1991. PowerSoft went public in 1993 and was acquired by Sybase for $904 million in Sybase stock in 1995.[3] The product languished for a long time for several reasons: Sybase's stock plummeted in 1996 after discovery of inflated sales reports, and many members of the original PowerSoft development team left Sybase. Competition from rival tools for building GUIs to databases, such as Microsoft Visual Basic, Microsoft Access and Delphi, reduced PowerBuilder's market share. PowerBuilder was slow to move to the Web: long after rivals began to support Web development, it continued to be based on two-tier (traditional client-server) technology. Two-tier approaches, while allowing more rapid development, are inherently less scalable than N-tier solutions (such as Web-based database solutions).[citation needed] In a two-tier solution, there must be one connection to the database for each concurrent user, whereas with N-tier solutions, which incorporate connection-pooling technology, a limited number of database connections - sometimes, just a single connection - are multiplexed among a much larger number of actual concurrent users. While two-tier applications continue to be used (appropriately) when the number of users is modest, they are inappropriate for, say, E-commerce scenarios. Also, deployment of two-tier solutions, including management of software updates, is significantly more complicated: Web-based solutions require only a browser on the user's machine, and the latest version of the application's Web pages will always be available. PowerBuilder 12, through compatibility with Web technologies such as ASP.NET, represents an attempt to regain market share. In order to move developers to newer versions, PowerBuilder 12 provides utilities that attempt to simplify migration [1]. Summary of PowerBuilder features Powerscript is an Object-Oriented programming language. Nearly all of the visual and non-visual objects support Inheritance, Polymorphism, and Encapsulation. The programmer may utilize a common code framework such as PowerBuilder Foundation Classes, also known as PFC, to inherit objects from and leverage pre-existing code.[4] The DataWindow is the key component (and selling point) of PowerBuilder. The DataWindow offers a visual SQL painter which supports outer joins, unions and subquery operations. It can convert SQL to Visual representation and back, so the developer can use native SQL if desired. DataWindow updates are automatic—it produces the proper SQL at runtime based on the DBMS to which the user is currently connected. This feature makes it easier for developers who are not experienced with SQL. The DataWindow also has the built-in ability to both retrieve data and update data via Stored Procedures. The user picks the Stored Procedure from a visual list. RDBMS Interfaces PowerBuilder offers native interfaces to all major databases, as well as ODBC and OLE-DB, in the Enterprise version. There are many connectivity options that allow performance monitoring and tuning, such as: Integrated Security Tracing of all SQL Isolation Level Password Expiration Dialog Blocking Factor Number of SQL statements to Cache Use Connection Pool Thread Safe Trace ODBC API Calls Due to the information about the database schema (such as primary key information) that are stored in PowerBuilder's data dictionary, the code required to implement data display and browsing is greatly simplified, because the dictionary information allows generation of the appropriate SQL behind the scenes. Here is a sample PowerBuilder update script: dw_1.AcceptText() dw_1.Update() PowerBuilder supports the following ways of interacting with a database: DataWindow: this is the simplest approach, relying on automatically generated SQL. "Embedded SQL" Embedded SQL supports SELECT, INSERT, UPDATE, DELETE and cursors. This option is used when the developer desires more control than is available with the DataWindow option. Example: UPDATE my_employee SET STATUS = 'A'; IF sqlca.sqlcode<>0 THEN ... "Dynamic SQL" This is a form of parameterized SQL, where the user builds a string that may optionally have bind variables. Dynamic SQL may be used to create cursors as well. Integration with third-party software PowerBuilder supports ActiveX and OCX controls, both visible and non-visible. It also can use OLE Automation as a client. However, PowerBuilder supports only late binding, not early binding. Therefore, when using OLE Automation, a dropdown of possible actions is not provided. PowerBuilder can also act as a DDE client or server, providing a further mechanism to interoperate with other applications. PowerBuilder can make Windows and third-party API calls, and, in general, works well with third-party libraries in DLL files, however it does not directly support callback functions. Compilation and debugging PowerBuilder offers a "/pbdebug" runtime switch, which creates a log file. This can help track down a bug "in the field", as the user simply emails this log file to the developer. It has another feature which can log all SQL statements to a file. It also has built-in performance profiling, an integrated debugger, context-sensitive help, and an active newsgroup to provide support. PowerBuilder applications are typically compiled to p-code, which is then interpreted by the PowerBuilder runtime. Although it can be compiled to machine code (called c-code), a typical business application does not run any faster. Only applications which do an unusually large amount of computations with little I/O are likely to benefit from compiling to machine code. Criticism Extensibility of the language was rather limited for older versions of PowerBuilder. The technologies provided to overcome this (ex. PowerBuilder Native Interface, or PBNI) are still[when?] rather tricky. To develop a solution that includes external C++ code may not only require a competent C++ developer, but also a PowerBuilder expert to guide the developer through the myriad of subtleties of the language and the PowerBuilder Virtual Machine. For PowerBuilder 12 [2], released in late 2010, Sybase states that this extensibility is less of an issue [3], because PowerBuilder .NET's APIs allow the use of "off the street XAML" including control templates and skins as well as its ability to use custom WPF controls with less effort than its historic use of External Function calls and “PBNI” to access external resources. Sybase has released regular updates to PowerBuilder at intervals of every 1.5 years or so. Moreover, in each of these releases, Sybase regularly incorporates modern development paradigms into the IDE, and provides the ability to develop for .NET. PowerBuilder 12.5 introduces even more .NET and WPF support [4]. The (classic) Powerscript language itself, which is still available for compatibility reasons, is known as "a language built around the DataWindow" amongst developers with PowerBuilder being the "IDE built around the DataWindow". Since PowerBuilder 12.0, the (now .NET-compliant) PowerScript language is fully compliant with the common language specification (CLS), and can be compared with C#, Java or VB.NET. The language now supports Arrays, Delegates, Parameterized Constructors, User-defined Enumerations and Generics. [5]. PowerBuilder 12.5 introduces support for Multithreading, the ability to consume RESTful (Representational State Transfer) Web Services and Batch Command Processing. For the "classic" PowerScript, various smaller enhancements were added,too. [6]. Community There is a variety of grass roots community groups and resources for PowerBuilder developers to share and convene. These include the International Sybase User Group [7] and what some call the very first technical journal devoted to an IDE, PowerBuilder Developer's Journal [8]. There are also blogs from TeamSybase [9] and evangelists [10] available. PowerBuilderTV [11] is series of webinars by and for the PowerBuilder community with webinars by PowerBuilder evangelists, developers and vendors. Some PowerBuilder Tools Appeon Mobile - Develop native mobile applications with PowerBuilder that runs on iOS (iPad and iPhone), Android (tablets and phones), and Windows Phone with support for the native mobile SDK. Appeon for PowerBuilder - Deploys existing or new PowerBuilder projects as Web applications that runs natively on either .NET or Java servers and OS. Visual Expert for PowerBuilder - Visual Expert helps in sharing the knowledge of your applications. It also automates impact analysis and checks code quality. Enable Multilingual - Enable makes PowerBuilder applications multilingual quickly and easily. Using Enable, developers can only need to make a few small changes to the original PowerBuilder code to go from monolingual to multilingual. ProDiff - ProDiff is designed to highlight the differences between versions of PowerBuilder development source code. Visual Guard for PowerBuilder - Visual Guard is an access control and application-level permissions tool. It helps you centralize view and control of users and their rights in PowerBuilder applications Customization Studio for PowerBuilder - Customization Studio allows end-users to modify the executable version of a PowerBuilder application without changing the source code. Framework for PowerBuilder - Free object oriented development framework for PowerBuilder, EAServer, and Appeon. References ^ "New features in PowerBuilder 12.0". Sybase. http://news.cnet.com/Sybase-fights-to-stay-in-tool-game/2100-1001_3-213108.html. ^ "Sybase PowerBuilder tool readied for Microsoft's .Net". Sybase. http://www.infoworld.com/d/developer-world/sybase-PowerBuilder-tool-readied-microsofts-net-965. ^ Lannigan, Patrick. Powersoft/PowerBuilder History. http://www.lannigan.org/powersoft_PowerBuilder_history.htm ^ PowerBuilder Foundation Class Help page, from Ecocion External links PowerBuilder's Official Website PowerBuilderTV - Webinars for PowerBuilder developers in English, Spanish and French ISUG - International Sybase User Group PowerBuilder Developers Journal PowerBuilder Community and TeamSybase Evangelist Blogs PowerBuilder Evangelist Hub PowerBuilder UI Components PowerBuilder Geeks (Discussion Group) PBDR.com - PowerBuilder news, tips and utilities History as told by one of the early users History of PB Detailed Technical History (Version by version changes) PBNI - Extending functionality French community of PowerBuilder IDC White Paper: Back to the Future with Application Development Productivity with PowerBuilder Visual Studio Isolated Shell PocketBuilder PB Migration Resources New Sybase PowerBuilder 12 requires little coding This entry is from Wikipedia, the leading user-contributed encyclopedia. It may not have been reviewed by professional editors (see full disclaimer) Donate to Wikimedia Related answers What are the challnges to convert PowerBuilder 12.5 classic to PowerBuilder 12.5 Net? Read answer... How long has the PowerBuilder program been in use? Read answer... Help us answer these Who invented PowerBuilder? What is PowerBuilder query evaluation plans? PowerBuilder enterprise 7.03 file import? Are there compatibility issues with PowerBuilder 11.5 applications running on ms sql server 2000? Post a question - any question - to the WikiAnswers community: 0;"> Copyrights: Cite Computer Desktop Encyclopedia THIS DEFINITION IS FOR PERSONAL USE ONLY.All other reproduction is strictly prohibited without permission from the publisher.© 1981-2014 The Computer Language Company Inc. All rights reserved. Read more Cite Wikipedia on Answers.com This article is licensed under the Creative Commons Attribution/Share-Alike License. It uses material from the Wikipedia article PowerBuilder. Read more Answer these When you open any object like DW window userobject etc in PowerBuilder at design time you want it to be opened maximize currently it is opened in half of screen and you always need to maximize it? » more Featured guides Wedding Registry Places Which Foods Are Rich In Iron? Sweet 16 Party Theme Ideas Decorative Garden Hose Reels What Is The P90X Workout? » More Mentioned in Powersoft (technology) PowerBuilder (technology) Erwin (technology) Sybase (technology) client/server development system (technology) aptitude tests (technology) Power foundation classes extension P (technology) salary survey jobs systems (technology) KnowledgeWare Inc. « Less » More » More Ads by Google Answers Properties Answers Wiki Answers Experts Coupons Guides Video Answers Local Answers ResellerRatings Surveys Blog Sitemap Company About Careers Terms of Use Privacy Policy Consumer Choice IP Issues Disclaimer Community Guidelines Reputation Roles Help Updates Email Watchlist RSS International sites English | Deutsch | Español | Français | Italiano | Tagalog Copyright © 2014 Answers Corporation facebook twitter youtube blog Sign in using: Answers members: Username Lost password? Password Remember me