03375nam 2200565Ia 450 991044970120332120200520144314.0(CKB)1000000000243575(SSID)ssj0000282039(PQKBManifestationID)11224974(PQKBTitleCode)TC0000282039(PQKBWorkID)10316634(PQKB)11519772(MiAaPQ)EBC3306514(CaSebORM)0738492132(Au-PeEL)EBL3306514(CaPaEBR)ebr10112515(OCoLC)137342158(EXLCZ)99100000000024357520050615d2005 uy 0engurcn|||||||||txtccrModernizing IBM eserver iSeries application data access[electronic resource] a roadmap cornerstone1st ed.Rochester, MN IBM, International Technical Support Organization2005xii, 262 p. illIBM redbooksThe "e" in "eserver" is printed as the symbol for electronic."SG24-6393-00."0-7384-9213-2 Includes bibliographical references (p. 255-257) and index.In 1978 IBM introduced the System/38 as part of its midrange platform hardware base. One of the many outstanding features of this system was the built-in Relational Database Management System (RDMS) support. The system included a utility for defining databases, screens, and reports. This utility used a form named Data Description Specifications (DDS) to define the database physical (PF) and logical (LF) files (base tables, views, and indexes). In 1988, IBM announced the AS/400. The OS/400 operating system also contained a built-in RDMS, however, IBM offered Structured Query Language (SQL) as an alternative to DDS for creating databases. In addition, SQL Data Manipulation Language (DML) statements were made available as an ad hoc query language tool. These statements could also be embedded and compiled within high level language (HLL) programs. SQL Data Definition Language (DDL) has become the industry standard for defining RDMS databases. Many customers are in the process of modernizing their database definition and the database access. This IBM Redbooks publication will help you understand how to reverse engineer a DDS-created database along, and provides you with tips and techniques for modernizing applications to use SQL as the database access method. Additional Resources on DB2 for i Modernization: DDS and SQL - The Winning Combination for DB2 for i Modernization Case Study:Modernizing a DB2 for i Application Moving from OPNQRYF to SQL Case Study:DB2 for i SQL Performance DB2 for i Modernization Workshop Modernizing Database Access - The Madness Behind the MethodsIBM redbooks.Database managementIBM computersElectronic books.Database management.IBM computers.005.75/85International Business Machines Corporation.International Technical Support Organization.MiAaPQMiAaPQMiAaPQBOOK9910449701203321Modernizing IBM eserver iSeries application data access1919034UNINA