Advanced Integrated RPG


Book Description

Written for experienced RPG programmers who want to take advantage of the latest technologies--such as Excel spreadsheets, Adobe files, and e-mail--from within their existing applications without buying costly software, this manual illustrates how to integrate RPG and Java in easy-to-understand code and with cost-effective options. Currently, there exists a very distinct line of expertise between IBM I programmers and Windows and Internet programmers, and this reference breaks through those obstacles to show common development tools for sharing information and building more compatible interfaces. Filling a very crucial gap, this resource shows programmers how to automatically e-mail reports using RPG and JavaMail, how to embed SQL and create text and XML files from within RPG, and how to migrate existing green-bar reports to Excel spreadsheets. An essential reference, this guide covers hard-to-find yet crucial information and introduces RPG programmers to modern environments.




SQL for IBM i


Book Description




21st Century Rpg - /Free, Ile, and Mvc


Book Description

This guide teaches programmers who have been left behind in the IBM i's evolution to code more productively and modernize their business applications. Shirey uses a casual, humorous teaching style to explain the concepts, along with plenty of code examples. Readers will gain confidence in areas that may be new to them and use the provided examples to practice what they've learned. The manual is structured so that whether they are using the latest IBM i technology or an older version, readers will learn methods to improve coding and applications, as well as become comfortable with writing programs using ILE RPG, free-format RPG, and Model-View-Controller (MVC).




Who Knew You Could Do That with RPG IV? Modern RPG for the Modern Programmer


Book Description

Application development is a key part of IBM® i businesses. The IBM i operating system is a modern, robust platform to create and develop applications. The RPG language has been around for a long time, but is still being transformed into a modern business language. This IBM Redbooks® publication is focused on helping the IBM i development community understand the modern RPG language. The world of application development has been rapidly changing over the past years. The good news is that IBM i has been changing right along with it, and has made significant changes to the RPG language. This book is intended to help developers understand what modern RPG looks like and how to move from older versions of RPG to a newer, modern version. Additionally, it covers the basics of Integrated Language Environment® (ILE), interfacing with many other languages, and the best tools for doing development on IBM i. Using modern tools, methodologies, and languages are key to continuing to stay relevant in today's world. Being able to find the right talent for your company is key to your continued success. Using the guidelines and principles in this book can help set you up to find that talent today and into the future. This publication is the result of work that was done by IBM, industry experts, business partners, and some of the original authors of the first edition of this book. This information is important not only for developers, but also business decision makers (CIO for example) to understand that the IBM i is not an 'old' system. IBM i has modern languages and tools. It is a matter of what you choose to do with the IBM i that defines its age.




IBM i Program Conversion: Getting Ready for 6.1 and Beyond


Book Description

IBM® delivered IBM i 6.1 in March 2008. With 6.1, IBM exploits the capabilities of the Machine Interface (MI) architecture to significantly improve programs. Programs can benefit from better performance, a range of new operating system and processor capabilities, and even stronger system integrity. To enable these improvements, all MI programs created for previous releases must be converted to run on 6.1 or a later release. MI programs include integrated language environment (ILE) and original program model (OPM) programs. To convert a program, its creation data, which is a subset of observability, must be available. MI programs retain creation data by default, so that most programs can be converted, going all the way back to programs that were originally created for System/38. Even if an option was chosen to remove creation data from external access, Licensed Internal Code (LIC) can still access the creation data if the target releases of the program and its constituent modules are V5R1 or later. Thus a program lacks sufficient creation data for conversion only if the program or at least one of its modules was created for IBM OS/400® V4R5 or an earlier release and creation data was explicitly removed. You can run the Analyze Object Conversion (ANZOBJCVN) command on V5R4 or V5R3 to help plan for your upgrade. The ANZOBJCVN command identifies programs that will not convert to run on 6.1 or later releases, if any, and estimates the times that are required for the program conversions. It also provides information about two other types of conversions: integrated file system names and spooled files. You can access the ANZOBJCVN command by loading and applying the appropriate PTFs that are listed in this paper. This IBM RedpaperTM publication is intended for system administrators and field technicians to help them understand and prepare for upgrading or migrating to 6.1 or a later release. It explains what the program conversion is and why programs are being created or recreated on 6.1 or a later release. It then provides detailed steps for using the ANZOBJCVN tool on V5R3 or V5R4 to prepare for object conversions. Finally, it discusses the program conversion methods for converting programs to run on 6.1 or a later release. Note: The first edition of this paper was entitled IBM i5/OS Program Conversion: Getting Ready for i5/OS V6R1, REDP-4293-00. The title of this second edition has been slightly modified to IBM i Program Conversion: Getting Ready for 6.1 and Beyond, REDP-4293-01, to reflect the new naming conventions for IBM i.




Developing Business Applications for the Web


Book Description

This book focuses on using common Web tools to develop business applications. Professional business programmers who are new to Web development will quickly acquire the relevant information they need, starting with HTML and CSS. The book goes beyond simple HTML and introduces other common Web technologies, including Java Server Pages (JSP), PHP, ASP.NET, and JavaScript. The book shows how those technologies interact with HTML and how developers can use them to develop and deploy business applications that users access via the Web. This book is written by business programmers and educators for business programmers. It is not just an introduction to HTML, but an introduction to the most common tools any business programmer needs to develop browser-based applications. Upon completion of the book, a business developer or student will have learned to develop and implement a completed browser-based business application.




Smarter Business: Dynamic Information with IBM InfoSphere Data Replication CDC


Book Description

To make better informed business decisions, better serve clients, and increase operational efficiencies, you must be aware of changes to key data as they occur. In addition, you must enable the immediate delivery of this information to the people and processes that need to act upon it. This ability to sense and respond to data changes is fundamental to dynamic warehousing, master data management, and many other key initiatives. A major challenge in providing this type of environment is determining how to tie all the independent systems together and process the immense data flow requirements. IBM® InfoSphere® Change Data Capture (InfoSphere CDC) can respond to that challenge, providing programming-free data integration, and eliminating redundant data transfer, to minimize the impact on production systems. In this IBM Redbooks® publication, we show you examples of how InfoSphere CDC can be used to implement integrated systems, to keep those systems updated immediately as changes occur, and to use your existing infrastructure and scale up as your workload grows. InfoSphere CDC can also enhance your investment in other software, such as IBM DataStage® and IBM QualityStage®, IBM InfoSphere Warehouse, and IBM InfoSphere Master Data Management Server, enabling real-time and event-driven processes. Enable the integration of your critical data and make it immediately available as your business needs it.







Subfiles in Free-Format RPG


Book Description

A comprehensive resource that can be used by RPG programmers as they advance from basic subfile usage to more advanced programming, this manual offers concepts, explanations, and practical examples that reflect current trends. With downloadable templates that include both the DDS and RPG IV code, this resource provides the techniques and styles-from basic single-page displays to powerful methods such as recursion, data queues, and embedded SQL-that enable RPG programmers to become subfile masters. With updated code that shows modern methods, such as ILE strategies and free-format RPG, this reference offers a bounty of practical examples and advanced techniques.