[PDF] Transitioning: Informix 4GL to Enterprise Generation Language (EGL)





Previous PDF Next PDF



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.





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.

ibm.com/redbooks

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

flexibility

Easier to build robust Web

applications

Helping you solve your

business problems

Front cover

Transitioning: Informix 4GL to Enterprise

Generation Language (EGL)

July 2005International Technical Support Organization

SG24-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.iii

Contents

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

3.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. . . . . . . . . . . . . . . . . . . . . . . . . 41

4.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. . . . . . . . . . . . . . . . . . . . . 57

5.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. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 97

6.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. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 111

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

8.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. . . . . . . . . . . . . . . . . . . . . . . . . 197

9.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 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 323

10.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 . . . . . . . . . . . . . . . . . . 395

11.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] 4k resolution

[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