Author : Jerry Fottral
Publisher : System iNetwork
Page : 580 pages
File Size : 32,5 MB
Release : 2000
Category : Computers
ISBN : 9781583040706
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.
Author : Patrice Gapen
Publisher : 29th Street Press
Page : 0 pages
File Size : 40,30 MB
Release : 1996
Category : Database management
ISBN : 9781882419128
Using Query/400 is a textbook for any AS/400 user, from the traditional student to the professional user, an easy and fast tool for creating reports and files from AS/400 databases. You need no prior programming experience. Students will find this book most useful following an "Introduction to the AS/400" class. The book's emphasis is on hands-on AS/400 use. The fundamentals of Query/400 are presented moving from simple to complex. Topics include selecting and sequencing fields, generating new numeric and character fields, sorting within Query, joining database files, defining custom headings, creating new database files, and more. Each chapter reinforces the knowledge gained in previous chapters.
Author : Paul Conte
Publisher : System iNetwork
Page : 548 pages
File Size : 30,12 MB
Release : 2000
Category : Computers
ISBN : 9781882419708
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.
Author : Hernando Bedoya
Publisher : IBM Redbooks
Page : 228 pages
File Size : 10,49 MB
Release : 2017-05-11
Category : Computers
ISBN : 0738442488
Business Intelligence (BI) is a broad term that relates to applications that analyze data to understand and act on the key metrics that drive profitability in an enterprise. Key to analyzing that data is providing fast, easy access to it while delivering it in formats or tools that best fit the needs of the user. At the core of any BI solution are user query and reporting tools that provide intuitive access to data supporting a spectrum of users from executives to "power users," from spreadsheet aficionados to the external Internet consumer. IBM® DB2® Web Query for i offers a set of modernized tools for a more robust, extensible, and productive reporting solution than the popular IBM Query for System i® tool (also known as IBM Query/400). IBM DB2 Web Query for i preserves investments in the reports that are developed with Query/400 by offering a choice of importing definitions into the new technology or continuing to run existing Query/400 reports as is. But, it also offers significant productivity and performance enhancements by leveraging the latest in DB2 for i query optimization technology. The DB2 Web Query for i product is a web-based query and report writing product that offers enhanced capabilities over the IBM Query for iSeries product (also commonly known as Query/400). IBM DB2 Web Query for i includes Query for iSeries technology to assist customers in their transition to DB2 Web Query. It offers a more modernized, Java based solution for a more robust, extensible, and productive reporting solution. DB2 Web Query provides the ability to query or build reports against data that is stored in DB2 for i (or Microsoft SQL Server) databases through browser-based user interface technologies: Build reports with ease through the web-based, ribbon-like InfoAssist tool that leverages a common look and feel that can extend the number of personnel that can generate their own reports. Simplify the management of reports by significantly reducing the number of report definitions that are required through the use of parameter driven reports. Deliver data to users in many different formats, including directly into spreadsheets, or in boardroom-quality PDF format, or viewed from the browser in HTML. Leverage advanced reporting functions, such as matrix reporting, ranking, color coding, drill-down, and font customization to enhance the visualization of DB2 data. DB2 Web Query offers features to import Query/400 definitions and enhance their look and functions. By using it, you can add OLAP-like slicing and dicing to the reports or view reports in disconnected mode for users on the go. This IBM Redbooks® publication provides a broad understanding of what can be done with the DB2 Web Query product. This publication is a companion of DB2 Web Query Tutorials, SG24-8378, which has a group of self-explanatory tutorials to help you get up to speed quickly.
Author : Brian W. Kelly
Publisher :
Page : 0 pages
File Size : 31,82 MB
Release : 2002
Category :
ISBN : 9780972184243
Finally, there is a Pocket Query Guide for training IT and non-IT personnel for Query/400. Yes, it is in big pocket guide form and it is tutorial in nature! You'll be pleased with all the valuable examples, especially result fields, selection and output options. You won't want to put down the first comprehensive guide to Query/400 now that you have your hands on it. This book was overdue 20 years ago, when Query/36 was the offering of the day. As strange as it may seem, there has never been a Query book such as this...ever. Yet, there are tons of expensive Query classes. It is difficult in most companies to get someone to step up to the plate to learn Query. Moreover, OJT is a tough learning experience and an inexact science at best. How do you know if you're ever right? The biggest cost of Query work may be impossible to quantify. The inaccurate answers that are returned from important queries, done by well intentioned, but inexperienced knowledge workers, can be costly. Making important decisions on erroneous information, however, can be even more costly. Then there is the employee turnover issue. Just when they get good at Query, they're gone. There is always another person or a team of people to train. IT is continually training users on the same Query product. Training by any source is expensive. From IBM classes to expensive self-training systems, there is no cheap alternative. It is always expensive, but it doesn't always work. It's difficult to achieve the objectives. Moreover, history suggests that one thing about Query training is always true. In a year or two, you will be doing it again. Not anymore! There is no magic in the Pocket Guide, but everything you need is in there!In addition, it is easy to read. The objective is for the users to train themselves. The iSeries Pocket Query Guide, a little help from co-workers along the way, and a careful evaluation by IT is all you need. The Guide has an example for just about every type of Query you can imagine -- from major result fields to File Joins. You'll see how to do it with examples that you'll use repeatedly. Additionally, for each example, there is a detailed explanation as well as the theory you need to get a head start on becoming a Query/400 guru.
Author : Tim Martyn
Publisher : McGraw-Hill Companies
Page : 540 pages
File Size : 41,9 MB
Release : 1995
Category : Computers
ISBN :
This practical guide to SQL focuses on data retrieval and manipulation using the powerful AS/400 dialect. In a proven tutorial format, the authors cover a wide range of SQL material, including selecting data from a single table, using built-in functions, defining and manipulating data, and accessing multiple tables.
Author : Robert W. Janson
Publisher : Cengage Learning
Page : 308 pages
File Size : 47,88 MB
Release : 1994
Category : Computers
ISBN : 9780877092629
This book provides a thorough introduction to AS/400 hardware and software, offering rigorous, in-depth coverage of its major functions. The author highlights the truly integrated nature of the AS/400 and emphasizes related data management concepts.
Author : Adobe Creative Team
Publisher : Adobe Press
Page : 464 pages
File Size : 44,22 MB
Release : 2013-07-08
Category : Computers
ISBN : 013341602X
Creative professionals seeking the fastest, easiest, most comprehensive way to learn Adobe Dreamweaver CC choose Adobe Dreamweaver CC: Classroom in a Book from the Adobe Creative Team at Adobe Press. The 15 project-based lessons in this book show you step by step everything you need to know to work in Dreamweaver. You’ll learn to create a professional website without having to write code by hand. This completely revised Creative Cloud edition also covers HTML5, CSS3, and media queries for responsive web design. The book also shows how to create HTML-based headings, paragraphs, lists, and tables; insert graphics and Photoshop Smart Objects; add links to text and images; apply cascading styles sheets; and customize the Dreamweaver workspace. You’ll also learn to add interactive elements to your sites, such as HTML5-compatible video and animation, get guidance for working with code, and finally publish a finished site to the Web. The online companion files include all lesson files so you can work along with the book. “The Classroom in a Book series is by far the best training material on the market. Everything you need to master the software is included: clear explanations of each lesson, step-by-step instructions, and the project files for the students.” —Barbara Binder, Adobe Certified Instructor, Rocky Mountain Training Classroom in a Book®, the best-selling series of hands-on software training workbooks, helps you learn the features of Adobe software quickly and easily. Classroom in a Book offers what no other book or training program does—an official training series from Adobe Systems Incorporated, developed with the support of Adobe product experts. Purchasing this book gives you access to the downloadable lesson files you need to work through the projects in the book, and to electronic book updates covering new features that Adobe releases for Creative Cloud customers. For access, goto www.peachpit.com/redeem and redeem the unique code provided inside this book.
Author :
Publisher :
Page : 124 pages
File Size : 33,38 MB
Release : 1995-01-09
Category :
ISBN :
For more than 40 years, Computerworld has been the leading source of technology news and information for IT influencers worldwide. Computerworld's award-winning Web site (Computerworld.com), twice-monthly publication, focused conference series and custom research form the hub of the world's largest global IT media network.
Author :
Publisher :
Page : 84 pages
File Size : 22,57 MB
Release : 1998-04-27
Category :
ISBN :
For more than 20 years, Network World has been the premier provider of information, intelligence and insight for network and IT executives responsible for the digital nervous systems of large organizations. Readers are responsible for designing, implementing and managing the voice, data and video systems their companies use to support everything from business critical applications to employee collaboration and electronic commerce.
