Mastering AS/400 Control Language


Book Description

The AS/400 Control Language (CL) is a set of commands that provide the primary interface between users and the system. Collectively, CL has more than a thousand commands, each of which is designed to perform a specific system, operational, or programming task. This book is a complete tutorial and easy-to-use reference for the AS/400 control language, together with AS/400: SYSTEM, UTILITIES, DATABASE AND PROGRAMMING by Lin & Stewart, it forms a complete tutorial and reference package for the AS/400.* covers CL commands, CL programming fundamentals, CL programming elements, calling programs and processing files, and advanced topics, such as sending messages and debugging programs.




Mastering the AS/400


Book Description

Annotation A hands-on approach to learning library-object structure, utilities and database management capabilities, application development tools, and OS/400 Control Language (CL), for the AS/400 computer. Twelve lessons, based largely on lab exercises, teach students how to communicate with the system, and use its many features, including CL, Query/400, logical files, DFU, SQL, and SDA. Annotation copyrighted by Book News, Inc., Portland, OR.




Control Language Programming for IBM I


Book Description

Covering the basics of Control Language (CL) programming as well as the latest CL features--including new structured-programming capabilities, file-processing enhancements, and the Integrated Language Environment--this resource is geared towards students learning CL. The book guides readers towards a professional grasp of CL techniques, introducing complex processes and concepts through review questions, hands-on exercises, and programming assignments that reinforce each chapter's contents. In addition to 25 chapters that cover CL from start to finish, a comprehensive appendix with condensed references to the most commonly used CL commands is also included along with two additional appendixes that cover the essentials of programming tools and debugging.




SQL/400 Developer's Guide


Book Description

IBM and the rest of the computer industry are putting most of their DBMS development efforts into SQL. This reference provides the SQL/400 skills that a successful applications developer needs and shows how to create comprehensive, complex, and professional SQL/400 databases.




Mastering VBA for Microsoft Office 2016


Book Description

Enhance productivity in any Office application with zero programming experience Mastering VBA for Microsoft Office 2016 helps you extend the capabilities of the entire Office suite using Visual Basic for Applications (VBA). Even if you have no programming experience , you'll be automating routine computing processes quickly using the simple, yet powerful VBA programming language. Clear, systematic tutorials walk beginners through the basics, while intermediate and advanced content guides more experienced users toward efficient solutions. This comprehensive guide starts at the beginning to get you acquainted with VBA so you can start recording macros right away. You'll then build upon that foundation to utilize the full capabilities of the language as you use loops and functions, message boxes, input boxes, and dialog boxes to design your own Office automation program. Add-ins, embedded macros, content controls, and more give you advanced tools to enhance productivity, and all instruction is backed by real-world practice projects in Word, Excel, Outlook, and PowerPoint. Productivity is the name of the game, and automating certain computing tasks is an easy solution with significant impact for any business. This book shows you how, with step-by-step guidance and expert insight. Expand Office 2016 functionality with macros Learn how to work with VBA and the entire Office suite Create effective code, even with no programing experience Understand ActiveX, XML-based files, the developer tab, and more VBA is designed to be understandable and accessible to beginners, but powerful enough to create specialized business applications. If you're ready to begin exploring the possibilities, Mastering VBA for Microsoft Office 2016 gets you started right away.




Mastering IBM I


Book Description

A comprehensive introduction to IBM i—the operating system that runs on IBM's midrange computer systems (System i, iSeries, AS/400)—and its facilities, this in-depth resource uses step-by-step exercises, review questions, and chapter labs to teach new programmers the latest system concepts and tools. Reflecting system changes that have occurred since 2000, topics include Rational Developer for Power (RDP), RDP Screen Designer and Report Designer, IBM i Access for Windows, IBM i Access for Web, IBM DB2 Web Query for i, and Remote System Explorer (RSE).




Mastering Microsoft Visual Basic 2010


Book Description

The new edition of the ultimate comprehensive guide to Microsoft Visual Basic Where most VB books start with beginner level topics, Mastering Visual Basic 2010 vaults you right into intermediate and advanced coverage. From the core of the language and user interface design to developing data-driven applications, this detailed book brings you thoroughly up to speed and features numerous example programs you can use to start building your own apps right away. Covers Visual Basic 2010, part of Microsoft's Visual Studio integrated development environment (IDE), which includes C#, C++, Visual Web Developer, and ASP.NET, along with Visual Basic Explains topics in the thorough, step-by-step style of all books in the Mastering series, providing you ample instruction, tips, and techniques Helps you build your own applications by supplying sample code you can use to start development Includes review exercises in each chapter to reinforce concepts as you learn All the books in the Sybex Mastering series feature comprehensive and expert coverage of topics you can put to immediate use. Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.




Mastering Microsoft Windows 7 Administration


Book Description

A comprehensive guide for IT administrators deploying Windows 7 Using a task-focused approach and clear, no-nonsense instructions, this book delivers all the information you'll need to deploy and manage Windows 7 efficiently and securely. Learn how to install, configure, run, and troubleshoot Windows 7; explore advanced networking, security, and other advanced topics. Delivers the information IT administrators need to deploy and manage Windows 7 successfully Explains topics in the thorough, step-by-step style of all books in the Mastering series, providing you ample instruction, tips, and techniques Covers how to install, configure, run, and troubleshoot Windows 7 and also explores advanced networking, security, and more Uses a task-based approach, so you have plenty of real-world examples and exercises to help you understand concepts All the books in the Sybex Mastering series feature comprehensive and expert coverage of topics you can put to immediate use.







Understanding AS/400 System Operations


Book Description

Tis guide is intended for students learning computer operations and administration on the AS/400 computer system. Offering a unique approach to learning AS/400 operations with extensive hands-on labs, self-tests, and review questions, this book uses real-world situations to enable users to be productive with AS/400 operations. This book also covers the requirements of the two IBM AS/400 certification exams: AS/400 Associate System Operator Certification (test 052) and AS/400 Professional System Operator Certification (test 053). The primary goal of this book is to teach users how to perform day-to-day operations on an AS/400 computer system, including IPL, starting and stopping the system, backup and recovery, and system cleanup. Procedures covered include creating and maintaining user environments, device configuration and management, security implementation, work and data management, and TCP/IP configuration. Console operations discussed include jobs, message handling, and working with spool files and peripheral devices. Functions of Operations Navigator are covered, and Electronic Customer Support (ECS) and PTF upgrades are also introduced.