Bøger udgivet af MC Press, LLC

This book brings Python, SQL, and Db2 application development together as never before, to show how these three technologies can successfully be used with each other. By reading this book, you will receive: An introduction to Db2An overview of SQL and how it is usedAn introduction to Python and the Python libraries/drivers available for Db2 application developmentA step-by-step guide for setting up a Python-Db2 development environment (on RedHat or Ubuntu Linux)In-depth information on how to structure and build Python applications that interact with Db2 (along with the link to a GitHub site that contains over 70 sample programs and 60 Jupyter Notebooks)Whether you're a Python developer who wants to build applications that work with Db2, or you're a Db2 user who wants to know how to build Python applications that interact with Db2 servers and databases, you'll find this book a must-read.

IBM has developed a world class certification program for professionals to establish standards that identify required levels of competency. This is the first study guide designed specifically for professionals who are preparing for test 345. With this guide, IBM now provides a quick and easy way to learn about IBM WebSphere Studio Application Developer and prepare for the IBM certification exam. This book will take you through the basics of using WebSphere Studio Application Developer from fundamental concepts through the actual development of a complete Web application. You will learn everything from an introduction to development, to debugging techniques, to implementing a complete application with HTML pages. Also included is information on JSPs, Servlets and back-end database access. Whether you need individual education or want to prepare for the certification testing, you will find this book to be an excellent resource.

WDSC: Step by Step carries on the Step by Step series tradition of providing an easy-to-understand yet thorough introduction to today''s most important technologies. In this book, you''ll discover the incredibly powerful WebSphere Development Studio Client (WDSC). Whether you plan to program only in RPG or plan to someday add Java and Web development to your RPG skill set, IBM has made it clear that WDSC is the tool you will be using. But WDSC isn''t just a replacement to SEU; it charts a new path for development based on IBM''s open-source Eclipse IDE. More than just an editor, WDSC is also a design studio, a compiler, an integration aid, and a test platform. It supports not only standard languages such as RPG and COBOL, but also Java, HTML, JavaServer Pages, and Cascading Style Sheets. The sheer scope of features available in WDSC makes learning it overwhelming for many programmers. This book demystifies WDSC, making it accessible and far easier to learn. By design, WDSC: Step by Step walks a programmer through a working, integrated example while highlighting those features used on a day-to-day basis. You''ll learn all of the key features of WDSC, including building a Web site, adding dynamic content, attaching it to an i5/iSeries program, and finally deploying it to a WebSphere Application Server. Not merely a WDSC reference, this book acts as an extended library session in which readers learn by doing and master enough techniques to continue learning on their own. No prior knowledge of Java, HTML, or Eclipse is required!

Become an Active Server Pages (ASP) aficionado with the Active Server Pages Primer: The iSeries Definitive Guide to Active Server Pages. This book takes an in-depth look at the ASP concept and how to make the most of it. You will go step-by-step through creating entire applications using ASP. Along the way, you will see correlations between the development process on the iSeries and the same process within an ASP. Once you have learned how easy it is to build ASP applications, you might wonder how you ever got along without them. Since HTML and ASP work hand-in-hand, this book provides an introduction to HTML and then gets you right into exploring the ASP concept. You will also learn how data access is achieved within an ASP, how to convert an iSeries application into an ASP application, how to use the specific VB Script statements that replace RPG op codes, and how an interactive application in RPG is converted into an ASP. You will learn to create a complete, fully functional, ASP "shopping cart" application. This example application reads, writes, and updates data on the iSeries from a Web-based order-entry system. You will examine techniques used to pass data among multiple Web pages within a multi-page ASP application. You will also create an ASP ad-hoc sales-reporting tool that uses data stored on the iSeries, and use Microsoft Office Web Components to incorporate charts and spreadsheets into your ASP. The book also takes a look at the changes Microsoft has implemented with ASP.NET, the next generation of ASP. Not only will you understand the concept of .NET, you will also learn exactly what is required to convert an ASP application into an ASP.NET application. Get the comprehensive guide that can take you all the way to Active Server Pages development. When you complete this book, you will know how to create ASP applications, how to use Microsoft Office Web Components to incorporate charts and spreadsheets into your ASP, how to convert interactive RPG applications into ASP applications, how to convert iSeries applications into ASP applications, how to convert ASP applications to ASP.NET applications, how to use the specific VB Script statements that replace RPG op codes, how to create a complete, fully functional, ASP "shopping cart" application, how to use new techniques to pass data among multiple Web pages within a multi-page ASP application, and how to create an ASP ad-hoc sales-reporting tool that uses data stored on the iSeries.

Link your IBM i system to the modern business server world! This book presents easier and more flexible ways to get data into your IBM i system, along with rather surprising methods to export and present the vital business data it contains. You'll learn how to automate file transfers, seamlessly connect PC applications with your RPG programs, and much more. Input operations will become more flexible and user-proof, with self-correcting import processes and direct file transfers that require a minimum of user intervention. Also learn novel ways to present information: your DB2 data will look great on program-generated spreadsheets and browser-based, interactive charts. All the solutions presented are based on existing open-source tools or were created from scratch by the author. The full source code, plus sample programs that are easy to understand and adapt, are provided with the book. Readers can integrate these input/output methods into their own applications, providing flexible, integrated, and modern solutions--all from RPG ILE programs, without having to increase the application landscape complexity with new servers and programming languages.

Geared toward IT management and business executives seeking to excel in business intelligence initiatives, this practical guide explores creating business alignment strategies that help prioritize business requirements, build organizational and cultural strategies, increase IT efficiency, and promote user adoption. Business intelligence, together with business analytics and performance management, eliminates information overload by organizing the massive amounts of information available in the modern enterprise. Addressing the challenges of business intelligence operations, this resource supports the goal of better business decision making and identifying unrealized opportunities. Each chapter includes a checklist of recommended approaches and a strategy overview template.

Cozzi on everything RPG! What more could you want? In this fourth edition of The Modern RPG IV Language , internationally recognized RPG expert Bob Cozzi takes his classic best seller to a whole new level. At close to 700 pages, this edition covers all of the new functions and facilities available in V5R4 RPG IV while keeping the straightforward, no-nonsense style that has kept this book on the best-seller list for almost 20 years. This new edition is guaranteed to keep Bob Cozzi as the leading expert on RPG, and his book the one turned to by countless developers worldwide. This new edition of The Modern RPG IV Language is packed with new information including new, never-before published information on coding free-format RPG IV. Chapter 12 delves into free-format in detail as he discusses MOVE alternatives, date and time conversions, data structures, and more. And to give you even more exposure to free-format, he has converted many of the examples throughout the book to free-format code. Add to that XML, CGI, and subprocedure information, and you have a book that no "modern" RPG programmer can be without. Even with all the new material, the basic concept of the book remains the same. As with previous editions, The Modern RPG IV Language, 4th Edition takes you through RPG IV, from its foundation to its most advanced techniques. At the core of this book are its chapters on built-in functions and op codes. In these chapters, Cozzi details each built-in function and op code with syntax tables that give you all the information you need at a glance plus examples to help you as you code. This is much more than just a book on rules, however. Bob includes more than 400 charts and tables to show how those rules apply and provides more than 500 real-life code examples of functions and operations. You''ll turn to this book again and again as you program in RPG IV. It is the quintessential reference for every RPG programmer. What''s New in This Edition? > Free-format syntax, including an entire chapter focused on this highly popular subject > Free-format examples throughout the book > Expanded information on subprocedures XML support, including new BIFs and op codes > Web programming with RPG, including CGI APIs and URL encoding > Updated and revised content throughout the book to cover i5/OS V5R4 Within the pages of this book, you will find: The basics of RPG IV, including data types, indicators, constants, and directives Detail on all of the specification types A complete discussion of expressions and how they should be used Every built-in function Every op code Options for organizing your program with source files, modules, and storage A discussion on modern operation code optimization An explanation of structured programming and how to apply it effectively in RPG Instructions on how to code inter-module communications Everything you need to know about procedures An entire chapter on the alternate syntax options now available--most notably Free-Format

Application Program Interfaces (APIs) are powerful, built-in tools used to solve business problems. Many System i programmers, however, do not have a working knowledge of the APIs available within i5/OS. Worse still, programmers who are familiar with the use of APIs may not be taking full advantage of the APIs and processing techniques available to them. In this book, author and noted IBM API expert Bruce Vining is your guide to making sense, and effectively mastering, the wide variety of APIs available with System i. Each chapter is full of real business-world examples that you can modify and use in your own environment. In recent years, the business programmer has had to integrate applications--often from different operating systems and programming platforms--using different languages to integrate business rules and requirements. APIs allow you to gain access to the underlying structure of an application. With this book you will soon realize that APIs are among the most powerful tools in your toolbox. New for this edition: New chapters covering topics such as exit point concepts, Integrated File System, date and time, cryptographic services, TCP/IP, and more Sorting, character data conversion, and user application information APIs are covered in depth Fully updated code on previous APIs to bring them up to newer standards Updates to API changes since the previous edition Modernized RPG code to demonstrate current coding style An Appendix with COBOL examples and implementation including API equivalents for RPG support of memory management, bit testing, edit words, and more Check Your Knowledge tasks at the conclusion of each chapter with solutions provided in RPG and COBOL Write client and server applications that enable your System i to communicate with other systems, such as PCs, using sockets

Thorough and updated coverage of database design and SQL for DB2 are the focus of this guide for the relational database-management system used on IBM i computer systems. Suitable for classroom instruction or self-study, this book explains the most widely used database language and the way that language is implemented on a variety of computer platforms. Topics covered include database concepts, SQL inquiries, web applications, and database security, and the material is reinforced by numerous illustrations, examples, and exercises.

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.

Written especially for programmers adopting a free-format style, this manual explores the role of functions in writing RPG IV programs. Demonstrating the potential of functions, many topics are explored such as details about existing RPG IV built-in functions, writing new functions, using ILE concepts to use C functions, and utilizing IBM API''s functions. Explaining how to write small programs, either as sub-procedures or modules, and how to gather those parts together to make programs that are easy to write and maintain, this is a natural next step for programmers familiar with a free-format style of coding.

Focusing exclusively on the Remote System Explorer (RSE) within the popular WebSphere Development Studio Client (WDSC), this comprehensive study contains both technical and practical tutorials. Allowing developers to use modern techniques within several programs, this survey covers topics such as getting started, terminology, installation, managing i5/OS objects and members, editing, compiling, and debugging. Each chapter features key views, actions, keyboard shortcuts, and troubleshooting tips. Illustrated with countless examples and detailed screen shots, this reference makes the RSE accessible for any developer.

A practical guide for today's chief data officers to define and manage data governance programs The relatively new role of chief data officer (CDO) has been created to address the issue of managing a company's data as a strategic asset, but the problem is that there is no universally accepted "playbook" for this role. Magnifying the challenge is the rapidly increasing volume and complexity of data, as well as regulatory compliance as it relates to data. In this book, Sunil Soares provides a practical guide for today's chief data officers to manage data as an asset while delivering the trusted data required to power business initiatives, from the tactical to the transformative. The guide describes the relationship between the CDO and the data governance team, whose task is the formulation of policy to optimize, secure, and leverage information as an enterprise asset by aligning the objectives of multiple functions. Soares provides unique insight into the role of the CDO and presents a blueprint for implementing data governance successfully within the context of the position. With practical advice CDOs need, this book helps establish new data governance practices or mature existing practices.

Designed to provide software engineers, students, and IT professionals with an understanding of the fundamentals of project management in the technology/IT field, this book serves as a practical introduction to the subject. Updated with information on how Fundamentals of Project Management integrates with and complements Project Management Institute's Project Management Body of Knowledge, this collection explains fundamental methodologies and techniques while also discussing new technology, tools, and virtual work environments. Examples and case studies are based on technology projects, and there are sample documents ranging from initial RFP to closing reports and different meeting agendas, status reports, cost analysis, and technical specifications. The book includes 60 templates to lead technology professionals through the six phases of the project life cycle: planning, design, development, integration, deployment, and postdeployment. A chapter on using social media is also included.