Transitioning: Informix 4GL to Enterprise Generation Language (EGL)
23 Jul 2005 web-based/4GL and Java™-based tools/languages but he ... 4GL language and concepts (one of the EGL language roots)
INFORMIX -4GL
Records 5 - 63 This INFORMIX-4GL Reference manual is a complete guide to the features and syntax of the INFORMIX-4GL language.
4GL Code Generation: A Systematic Review
The idea of 4GL is to make programming as simple as possible by the mean of programming in natural human language [2] [3]. 4GLs aim to.
1. Introduction The term Fourth Generation Language (4GL) is used
To some extent the name 4GL is misleading
Fresche Solutions
Speedware/4GL is a complete fourth-generation platform-independent procedural and non-procedural programming language. In conjunction with its CASE companion
Informix Dynamic 4GL
Chapter 6 “Extensions to the 4GL Language
IBM Informix 4GL Reference Manual Version 7.31
31 Jan 2002 The 4GL language approximates a superset of the Informix implementation of the industry-standard SQL language. Because the 4GL compiler does ...
SUGI 25: Notes from the Outer Limits of 4GL RDBMS/SQL: The SASr
Relational schema and 4th Generation Languages such as the Structured Query Language SQL
Querix-Lycia-The-rebirth-of-Informix-4GL.pdf
2nd most used language at the time on UNIX platforms after C. ? Simple
Fourth Generation Languages and End Users - DP Management
development) will not be by any 4GL but by good. "information resource management". Christoff[8] believes that the use of 4GLs will not help systems.
Transitioning:
Informix 4GL to Enterprise
Generation Language (EGL)
Chuck Ballard
Vlaunir Da Silva
Daniel M. Farrell
Alexander Koerner
Jonathan Sayles
The right balance of simplicity and
flexibilityEasier to build robust Web
applicationsHelping you solve your
business problemsFront cover
Transitioning: Informix 4GL to Enterprise
Generation Language (EGL)
July 2005International Technical Support OrganizationSG24-6673-00
© Copyright International Business Machines Corporation 2005. All rights reserved.Note to U.S. Government Users Restricted Rights -- Use, duplication or disclosure restricted by GSA ADP
Schedule Contract with IBM Corp.
First Edition (July 2005)
This edition applies to Version 8.2 of DB2 Universal Database , Version 10 of Informix Dynamic Server (IDS), Version 5.1 Cloudscape, Version 6.0.0.1 of the Rational Software Development Platform (SDP), Version 6.0 of WebSphere Application Server, Version 5.5 of the Apache Software Foundation's Tomcat application server, Version 0.6.1 of JasperReports (which comes bundled with the Rational SDP) and the April 8th 2005 edition of the 4GL to EGL conversion tool Note: Before using this information and the product it supports, read the information in "Notices" on page xv. © Copyright IBM Corp. 2005. All rights reserved.iiiContents
Notices . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xv
Trademarks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .xvi
Preface . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xvii
The team that wrote this redbook. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xvii
Become a published author . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xx
Comments welcome. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xx
Part 1. Introduction and overview. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1
Chapter 1. Introduction. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3
1.1 Contents abstract . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6
1.2 IBM Enterprise Generation Language (EGL) . . . . . . . . . . . . . . . . . . . . . . . 8
Chapter 2. IBM Informix 4GL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13
2.1 History of IBM Informix 4GL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14
2.1.1 Informix SQL (ISQL) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14
2.1.2 ISQL and IBM Informix 4GL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14
2.1.3 Time lines . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15
2.2 IBM Informix 4GL source code review . . . . . . . . . . . . . . . . . . . . . . . . . . . 15
2.2.1 4GL form files . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16
2.2.2 4GL program types . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18
2.2.3 4GL data entry screen form program . . . . . . . . . . . . . . . . . . . . . . . . 19
2.2.4 Thematic review of 4GL screen form program . . . . . . . . . . . . . . . . . 24
2.2.5 Code review: 4GL data entry screen form program . . . . . . . . . . . . . 25
2.2.6 Code review: lessons learned. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27
2.2.7 4GL report program. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27
2.2.8 Thematic review of the 4GL report program . . . . . . . . . . . . . . . . . . . 29
2.2.9 Code review: 4GL report program. . . . . . . . . . . . . . . . . . . . . . . . . . . 30
2.2.10 Code review: lessons learned. . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30
Chapter 3. Rational Software Development Platform . . . . . . . . . . . . . . . . 313.1 Top down IBM . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32
3.1.1 IBM and the Rational brand . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32
3.1.2 EGL integration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33
3.1.3 IBM EGL value proposition . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34
3.1.4 Who uses IBM EGL?. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 35
3.1.5 History of EGL. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 36
3.2 Summary of IBM EGL tooling . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 37
iv Transitioning: Informix 4GL to Enterprise Generation Language (EGL) Chapter 4. Installing and configuring RAD. . . . . . . . . . . . . . . . . . . . . . . . . 414.1 System requirements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 42
4.2 RAD 6.0 installation. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 43
4.2.1 Installing RAD from an electronic image. . . . . . . . . . . . . . . . . . . . . . 43
4.2.2 Install from the CD-ROM. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 46
4.3 RAD interim fix installation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 46
4.3.1 Installation prerequisites . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 46
4.3.2 Online interim fix installation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 46
4.3.3 Offline interim fix installation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 48
4.3.4 Offline multiple interim fix installation . . . . . . . . . . . . . . . . . . . . . . . . 50
4.4 4GL to EGL conversion tool installation . . . . . . . . . . . . . . . . . . . . . . . . . . 50
4.4.1 Online 4GL to EGL CT installation . . . . . . . . . . . . . . . . . . . . . . . . . . 51
4.4.2 Offline 4GL to EGL CT installation . . . . . . . . . . . . . . . . . . . . . . . . . . 51
4.4.3 Offline RPU installation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 53
4.5 IBM Informix JDBC™ driver installation . . . . . . . . . . . . . . . . . . . . . . . . . . 54
4.5.1 Installing IBM Informix JDBC driver in graphical mode. . . . . . . . . . . 55
4.5.2 Installing IBM Informix JDBC driver in console mode . . . . . . . . . . . . 55
4.5.3 Installing IBM Informix JDBC driver in silent mode . . . . . . . . . . . . . . 56
Chapter 5. Redbook 4GL reference application. . . . . . . . . . . . . . . . . . . . . 575.1 The Stores demo database. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 58
5.2 The 4GL forms in reference application . . . . . . . . . . . . . . . . . . . . . . . . . . 60
5.3 The 4GL modules in a reference application. . . . . . . . . . . . . . . . . . . . . . . 64
5.4 Remaining reference application files . . . . . . . . . . . . . . . . . . . . . . . . . . . . 92
Part 2. EGL basics and a simple EGL Web application. . . . . . . . . . . . . . . . . . . . . . . . . . . . 95
Chapter 6. Introduction to IBM EGL. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 976.1 IBM EGL Projects . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 98
6.2 IBM EGL packages, folders, and files . . . . . . . . . . . . . . . . . . . . . . . . . . . 102
6.3 EGL parts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 106
6.4 Other EGL language elements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 110
Chapter 7. EGL language concepts. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1117.1 Prerequisites for this chapter. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 112
7.2 Setup to run the code in this chapter. . . . . . . . . . . . . . . . . . . . . . . . . . . . 113
7.2.1 Creating a new EGL (non-Web) Project . . . . . . . . . . . . . . . . . . . . . 113
7.2.2 Creating EGL Packages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 117
7.2.3 Adding an EGL Data Parts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 122
7.2.4 Adding an EGL Program to our EGL Project . . . . . . . . . . . . . . . . . 130
7.2.5 Generating, compiling, and running our EGL Program. . . . . . . . . . 136
7.2.6 Configuring our program to include JDBC client libraries . . . . . . . . 139
7.3 Sample EGL character based data entry screen . . . . . . . . . . . . . . . . . . 146
7.3.1 Demonstration of sample character based program. . . . . . . . . . . . 147
Contents v7.3.2 Contents of the sample character based program . . . . . . . . . . . . . 149 Chapter 8. The EGL build environment. . . . . . . . . . . . . . . . . . . . . . . . . . . 1818.1 The code generation process: the big picture . . . . . . . . . . . . . . . . . . . . . 182
8.1.1 Source development . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 182
8.1.2 Generate . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 183
8.1.3 Build or compile. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 183
8.2 EGL build descriptor files . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 185
8.2.1 Build descriptor options. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 185
8.3 Project properties . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 189
8.3.1 Accessing project properties. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 189
8.3.2 EGL Build Path . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 191
8.3.3 EGL Default Build Descriptor . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 192
8.3.4 Java Build Path . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 193
8.4 Generate and build in the IDE. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 194
8.5 Summary. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 196
Chapter 9. Simple Web application setup. . . . . . . . . . . . . . . . . . . . . . . . . 1979.1 Prerequisites . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 198
9.2 How this chapter is organized . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 198
9.3 Setup tasks: Part 1 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 199
9.3.1 Launching Rational SDP. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 199
9.3.2 Default workspace. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 199
9.3.3 Dismissing the Welcome screen. . . . . . . . . . . . . . . . . . . . . . . . . . . 201
9.3.4 Rational SDP main screen . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 202
9.3.5 Instructing Rational SDP about our role . . . . . . . . . . . . . . . . . . . . . 204
9.3.6 Creating an IBM EGL Web Project . . . . . . . . . . . . . . . . . . . . . . . . . 210
9.3.7 Configuring application server: adding our EGL Web Project. . . . . 217
9.3.8 Setting the path to Informix JDBC client libraries on the application
server . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 222
9.3.9 Adding an authentication alias to the application server. . . . . . . . . 233
9.3.10 Adding a data source to the application server. . . . . . . . . . . . . . . 239
9.4 Checkpoint . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 255
9.5 Setup tasks part 2 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 256
9.5.1 Setting up the JDBC data source for use by the EGL compiler . . . 256
9.5.2 Creating Data Parts. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 264
9.5.3 A sub-task to create a database connection resource . . . . . . . . . . 267
9.5.4 Returning to the Data Parts creation task . . . . . . . . . . . . . . . . . . . . 278
9.5.5 Results of the Data Parts Wizard . . . . . . . . . . . . . . . . . . . . . . . . . . 282
9.5.6 EGL statements Library: Package, Import, and Use. . . . . . . . . . . . 289
9.5.7 Creating our own EGL Package and Library. . . . . . . . . . . . . . . . . . 294
9.6 Final checkpoint . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 307
9.7 Alternate means to create JDBC data source. . . . . . . . . . . . . . . . . . . . . 308
vi Transitioning: Informix 4GL to Enterprise Generation Language (EGL) Chapter 10. Simple Web application . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32310.1 Prerequisites . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 324
10.2 Demonstration of a simple business application . . . . . . . . . . . . . . . . . . 324
10.2.1 Display of our sample list page . . . . . . . . . . . . . . . . . . . . . . . . . . . 325
10.2.2 Display of our sample detail page. . . . . . . . . . . . . . . . . . . . . . . . . 325
10.3 Creating the Simple Web application: JSP page 1 . . . . . . . . . . . . . . . . 326
10.3.1 New Faces JSP file. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 327
10.3.2 Specifying a page template. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 330
10.3.3 Working static Faces JSP page . . . . . . . . . . . . . . . . . . . . . . . . . . 332
10.3.4 Working with properties. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 335
10.3.5 Viewing a served page . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 336
10.3.6 Viewing a served page with other Web browsers . . . . . . . . . . . . . 341
10.3.7 Managing the embedded Mozilla Web browser . . . . . . . . . . . . . . 342
10.3.8 Preparing to alter a page from static to dynamic content . . . . . . . 343
10.3.9 Creating Page Data variables . . . . . . . . . . . . . . . . . . . . . . . . . . . . 346
10.3.10 Placing Page Data variables on the page. . . . . . . . . . . . . . . . . . 349
10.3.11 Accessing the associated Page Handler. . . . . . . . . . . . . . . . . . . 354
10.3.12 Running the page with dynamic content . . . . . . . . . . . . . . . . . . . 356
10.3.13 Alternate or preferred syntax for the solution . . . . . . . . . . . . . . . 358
10.3.14 Adding a Link from list page to detail page . . . . . . . . . . . . . . . . . 360
10.3.15 Specifying parameters for data aware hyperlink. . . . . . . . . . . . . 363
10.3.16 Serving the list page with Links. . . . . . . . . . . . . . . . . . . . . . . . . . 364
10.4 Creating the Simple Web application: JSP page 2 . . . . . . . . . . . . . . . . 367
10.4.1 Allowing a writable page . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 375
10.4.2 Enhancing the Model portion of our existing code . . . . . . . . . . . . 378
10.4.3 Detailed code review of Model portion . . . . . . . . . . . . . . . . . . . . . 382
10.4.4 Modifying Page Handler of UpdateCustomer.jsp . . . . . . . . . . . . . 383
10.4.5 Detailed code review of Controller portion . . . . . . . . . . . . . . . . . . 386
10.4.6 Associating a visual page control with a Page Handler function. . 387
10.4.7 Testing and final results . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 389
10.4.8 Final modifications . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 391
10.5 Checkpoint . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 391
Part 3. Informix 4GL to EGL conversion. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 393
Chapter 11. The 4GL to EGL conversion process . . . . . . . . . . . . . . . . . . 39511.1 The conversion process: an overview. . . . . . . . . . . . . . . . . . . . . . . . . . 396
11.1.1 Conversion benefits . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 396
11.1.2 Conversion stages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 396
11.1.3 Conversion limitations. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 399
11.1.4 C interface support and limitations . . . . . . . . . . . . . . . . . . . . . . . . 399
11.1.5 Report support and limitations . . . . . . . . . . . . . . . . . . . . . . . . . . . 399
11.1.6 Screen forms support . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 400
Contents vii11.2 The conversion process in detail. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 401
quotesdbs_dbs3.pdfusesText_6[PDF] 4th 5th 6th and 14th amendments
[PDF] 4th 5th and 14th amendments
[PDF] 4th 8th and 14th amendments
[PDF] 4th amendment actual text
[PDF] 4th amendment and government surveillance
[PDF] 4th amendment and juveniles
[PDF] 4th amendment ap gov
[PDF] 4th amendment article
[PDF] 4th amendment case examples
[PDF] 4th amendment case scenarios
[PDF] 4th amendment cases 2017
[PDF] 4th amendment cases 2018
[PDF] 4th amendment cases 2020
[PDF] 4th amendment cases ap gov