Using The Visual Basic DataGrid Control - MC Press Online

• ARCHIVE
  • Authors
  • Categories
  • Articles
• BOOKSTORE
  • Application Development
    • Cloud Computing
    • Rational
    • WebSphere
  • Certification
  • Database
    • Analytics
    • Data Governance
    • DB2
    • Informix
    • SQL
  • Management and Career
    • Career
    • Project Management
  • Operating Systems
    • AIX
    • IBM i
  • Programming
    • APIs
    • CL
    • EGL
    • HTML
    • Java
    • Scripting
    • PHP
    • RPG
  • System Administration
    • Disaster Recovery
    • Networking
    • Security
• BUYER'S GUIDE
  • Companies
  • Hardware
  • Services
  • Software
  • Submit Listing
    • Hardware
    • Services
    • Software
• EVENTS
  • Submit New Event
• FORUMS
  • Shooting the Breeze
  • Analysis
    • Commentary
    • News
  • App Software
    • Collaboration & Messaging
    • Customer Relationship Management
    • Document Management
    • ERP/Financial
    • General
    • IBM
    • Managed Services/SaaS
    • Microsoft
  • Career Center
    • General
    • Jobs Offered
    • Resumes
  • Database
    • Business Intelligence
    • DB2
    • General
    • Microsoft Access
    • MySQL
    • Oracle
  • Internet
    • Application Servers
    • Commerce
    • General
    • Portals
    • Protocols
    • Telephony
  • Networking
    • Emulation
    • General
    • Wireless/Mobile
  • Op Systems
    • IBM i (OS/400, i5/OS)
    • Linux/Open Source
    • Microsoft
    • Unix/AIX
  • Programming
    • APIs
    • Business Integration
    • C, C++, C#
    • Change Management
    • CL
    • COBOL
    • Dev Tools
    • General
    • Java
    • REXX
    • RPG
    • Scripting
    • SQL
    • Web Languages
    • Visual Basic
  • Security
    • Compliance/Privacy
    • General
    • IBM i (OS/400, i5/OS)
    • Microsoft
  • System Admin
    • General
    • High Availability/DR
    • Performance Monitoring & Tuning
  • Web Site
    • MC Press Book Downloads & Reviews
    • MC Press Videos
    • MC Showcase Buyer's Guide
  • Archive Threads Pre Jan-2001
    • Analysis
    • Application Software
    • Database
    • Hardware
    • Internet
    • Management
    • Networking
    • Operating Systems
    • Programming
      • IGA Catalogue
• Publications
  • MC Press Bookstore
    • Latest Offer
  • MC Resource Center
    • MC On-Demand Webcast Center
    • MC Trial Software Center
    • MC White Paper Center
  • MC RPG Developer
    • December 3, 2025
    • November 5, 2025
    • October 1, 2025
    • September 3, 2025
    • August 6, 2025
    • July 2, 2025
    • June 4, 2025
    • May 7, 2025
    • April 2, 2025
    • March 5, 2025
    • February 5, 2025
    • January 8, 2025
    • Archive
  • MC TNT Tips 'n Techniques
    • December 10, 2025
    • November 12, 2025
    • October 8, 2025
    • September 10, 2025
    • August 13, 2025
    • July 9, 2025
    • June 11, 2025
    • May 14, 2025
    • April 9, 2025
    • March 12, 2025
    • February 12, 2025
    • January 15, 2025
    • Archive
  • MC Systems Insight
    • November 19, 2025
    • October 15, 2025
    • September 17, 2025
    • August 20, 2025
    • July 16, 2025
    • June 18, 2025
    • May 21, 2025
    • April 16, 2025
    • March 19, 2025
    • February 19, 2025
    • January 22, 2025
    • December 18, 2024
    • Archive
• Resource Center
  • MC On-Demand Webcast
  • MC Trial Software
  • MC White Papers
• VIDEOS
  • IBM Videos
    • Newest
    • Popular Videos
  • MC Press Author Presentations
    • Newest
    • Popular
  • MC Security
    • Newest
    • Popular
  • MC Video News Makers
    • Newest
    • Popular
  • TechTips
    • Newest
    • Popular

• MORE INFO
  • About MC Press
  • Contact Us
  • Online Media Kit
  • Site Map
  • Write for MC Press
  • Privacy Policy

Search ... Members Remember Me Forgot your password? Forgot your username? Sign Up

• Home
• Analytics & Cognitive

  Analytics & Cognitive Categories

  • Business Intelligence

  • DB2

  • Document Management

  • Watson

  • Analytics & Cognitive - Other

  Latest Analytics & Cognitive News

  • Analytics & Cognitive News Details 01 Dec 25

    What 1,700 chief data officers are saying about data and AI

  • Analytics & Cognitive News Details 17 Nov 25

    IBM Delivers New Quantum Processors, Software, and Algorithm Breakthroughs on Path to Advantage and Fault Tolerance

  • Analytics & Cognitive News Details 17 Nov 25

    IBM Study: Chief Data Officers Redefine Strategies as AI Ambitions Outpace Readiness

  • Analytics & Cognitive News Details 10 Nov 25

    When AI Models Begin to Notice Their Own Thoughts

  • Analytics & Cognitive News Details 03 Nov 25

    IBM Impact Accelerator Brings AI to the Frontlines of Supply Chains

  • Analytics & Cognitive News Details 03 Nov 25

    IBM Announces Defense-Focused AI Model to Accelerate Mission Planning and Decision Support

  • Analytics & Cognitive News Details 03 Nov 25

    IBM and Groq Partner to Accelerate Enterprise AI Deployment with Speed and Scale

  • Analytics & Cognitive News Details 03 Nov 25

    IBM Announces New AI Agents on Oracle Fusion Applications AI Agent Marketplace

  • Analytics & Cognitive News Details 07 Oct 25

    IBM Introduces the Spyre Accelerator for Commercial Availability

• Career

  Career Catgories

  • General

  Latest Career News

  • Career Details 03 Nov 2025

    IBM and Mission 44 Join Forces to Fast-Track AI Skills

  • Career Details 29 Jul 2024

    Kisco Awards two Fellowships and Announces Program Expansion

  • Career Details 09 Apr 2024

    Selection Process Open for Kisco’s IBM i Career Development Fellowship

  • Career Details 19 Sep 2023

    Tech Project Management - Project Definition, An Introduction

  • Career Details 15 Aug 2023

    Tech Project Management - The Different Kinds of Resources

  • Career Details 17 Oct 2022

    Tech Project Management - The The Different Kinds of Projects

  • Career Details 16 Aug 2022

    Tech Project Management - The Proposal Document

  • Career Details 07 Jun 2022

    Tech Project Management - Project Conception

  • Career Details 26 Apr 2022

    Tech Project Management - Planning Your Project

• Cloud

  Cloud Categories

  • Blockchain

  • High Availability / Disaster Recovery

  • Managed Services / SaaS / PaaS / IaaS

  • Cloud - Other

  Latest Cloud News

  • Cloud News Details 05 Mar 2025

    Shield Takes IBM i Monitoring Solution AAG to New Heights with Ansible

  • Cloud News Details 24 Feb 2025

    New IBM Study: Pioneering Telcos Ramp Up AI, Cloud and Security Investments for the Next Wave of Network Modernization

  • Cloud News Details 03 Dec 2024

    IBM and AWS Accelerate Partnership to Scale Responsible Generative AI

  • Cloud News Details 25 Sep 2024

    IBM and Microsoft Open Three New Experience Zones to Provide Global Clients with More Hands-on Access to Cloud and Generative AI Solutions

  • Cloud News Details 28 Aug 2024

    Cloud investments soar as AI advances

  • Cloud News Details 18 Aug 2024

    Serverless vs. microservices: Which architecture is best for your business?

  • Cloud News Details 06 Aug 2024

    Serverless use cases: How enterprises are using the technology to let developers innovate

  • Cloud News Details 16 Jul 2024

    How a US bank modernized its mainframe applications with IBM Consulting and Microsoft Azure

  • Cloud News Details 10 Jun 2024

    IBM awarded Customer Choice Vendor in the Gartner Peer Insights 2024 “Voice of the Customer: Cloud Database Management Systems” 

• IT Infrastructure

  IT Infrastructure Categories

  • Operating Systems

  • System Administration

  • IT Infrastructure - Other

  Latest IT Infrastructure News

  • IT Infrastructure News Details 29 Sep 2025

    HashiCorp’s big bet: Infrastructure for the agentic era

  • IT Infrastructure News Details 28 Aug 2025

    DSI Revolutionizes IBM Power Backups: Unveils iDSI750 – World's First VTL Built on Power Systems

  • IT Infrastructure News Details 31 Aug 2025

    IBM and AMD Join Forces to Build the Future of Computing

  • IT Infrastructure News Details 08 Jul 2025

    Maximize IBM Power11 with IBM Technology Lifecycle Services

  • IT Infrastructure News Details 08 Jul 2025

    IBM Power11 Raises the Bar for Enterprise IT

  • IT Infrastructure News Details 30 Apr 2024

    IBM Transforms the Storage Ownership Experience with IBM Storage Assurance

  • IT Infrastructure News Details 07 Feb 2024

    New IBM LinuxONE 4 Express to Offer Cost Savings and Client Value through a Cyber Resilient Hybrid Cloud and AI Platform

  • IT Infrastructure News Details 13 Nov 2023

    How the semiconductor industry is leveraging high-performance computing to drive innovation

  • IT Infrastructure News Details 09 Nov 2023

    Why serverless technology is the next big movement

• News

  News Categories

  • Analytics & Cognitive News

  • Cloud News

  • Commerce News

  • Industry News

  • IT Infrastructure News

  • Mobile News

  • Programming News

  • Security News

  Latest News

  • Analytics & Cognitive News Details 01 Dec 2025

    What 1,700 chief data officers are saying about data and AI

  • Analytics & Cognitive News Details 17 Nov 2025

    IBM Delivers New Quantum Processors, Software, and Algorithm Breakthroughs on Path to Advantage and Fault Tolerance

  • Analytics & Cognitive News Details 17 Nov 2025

    IBM Study: Chief Data Officers Redefine Strategies as AI Ambitions Outpace Readiness

  • Analytics & Cognitive News Details 10 Nov 2025

    When AI Models Begin to Notice Their Own Thoughts

  • Security News Details 10 Nov 2025

    Is Rising AI adoption Across the US Workforce Creating Shadow AI Risks?

  • Analytics & Cognitive News Details 03 Nov 2025

    IBM Impact Accelerator Brings AI to the Frontlines of Supply Chains

  • Analytics & Cognitive News Details 03 Nov 2025

    IBM Announces Defense-Focused AI Model to Accelerate Mission Planning and Decision Support

  • Analytics & Cognitive News Details 03 Nov 2025

    IBM and Groq Partner to Accelerate Enterprise AI Deployment with Speed and Scale

  • Analytics & Cognitive News Details 03 Nov 2025

    IBM Announces New AI Agents on Oracle Fusion Applications AI Agent Marketplace

• Programming

  Programming Categories

  • APIs

  • RPG

  • Scripting

  • SQL

  • Web Languages

  • Programming - Other

  Latest Programming News

  • Programming News Details 10 Dec 24

    2024 Call for Code Global Challenge Winners Improve Equitable Access to Essential Needs with Solutions Using IBM watsonx

  • Programming News Details 15 May 24

    Profound Logic Enhances Legacy System Futurization with Introduction of Python to its Open-Source Transformation Services

  • Programming News Details 05 Dec 23

    RPG API Express Version 3.5.0: Lightning-Fast JSON Composition and More!

  • Programming News Details 12 Oct 23

    ASNA Visual RPG 5.0 has retired

  • Programming News Details 04 Aug 23

    Fresche Solutions Launches Subscription-Based Licensing for IBM i Flagship Products

  • Programming News Details 04 Aug 23

    Froala V4.1: Empowering React, Angular, and Vue Developers with the Ultimate Rich Text Editor

  • Programming News Details 14 Dec 22

    IBM and David Clark Cause Aim to Reduce Food Waste; Name AI-Powered Gardening App Winner of 5th Annual Call for Code

  • Programming News Details 19 Sep 22

    The Reasons Why Legacy IBM i Applications Hinder Your Workforce Potential

  • Programming News Details 26 Apr 22

    IBM and Red Hat to Help Modernize U.S. Department of Education's G5 Grants Management System

• Security

  Security Categories

  • Compliance / Privacy

  • IBM i (OS/400, i5/OS)

  • Security - Other

  Latest Security News

  • Security News Details 10 Nov 2025

    Is Rising AI adoption Across the US Workforce Creating Shadow AI Risks?

  • Security News Details 07 Oct 2025

    IBM and Anthropic Partner to Advance Enterprise Software Development with Proven Security and Governance

  • Security News Details 29 Sep 2025

    HashiCorp Previews the Future of Agentic Infrastructure Automation with Project infragraph

  • Security News Details 27 Jan 2025

    IBM and Palo Alto Networks Find Platformization is Key to Reduce Cybersecurity Complexity

  • Security News Details 29 Jan 2025

    Telefónica Tech and IBM Sign a Collaboration Agreement for Quantum-Safe Technology

  • Security News Details 04 Feb 2025

    Easily secure your IBM Cloud PowerVS Workloads with IBM Cloud Security and Compliance Center Workload Protection

  • Security News Details 03 Dec 2024

    IBM and Janes collaborate to help national security and defense organizations unlock the power of data with trusted AI

  • Security News Details 04 Nov 2024

    Addressing the cybersecurity skills gap with higher education

  • Security News Details 05 Aug 2024

    IBM Introduces New Generative AI-Powered Cybersecurity Assistant for Threat Detection and Response Services

• MORE
  • Commentary
  • Commerce
  • Internet of Things
  • Mobile
  • Social

1. You are here:  
2. Home
3. Programming
4. Programming - Other
5. Visual Basic
6. Using the Visual Basic DataGrid Control

Details MC Press Contributing Author 31 October 2000 Visual Basic

• Previous Article Hang a Left at Calendarville and Head to the AS/400 Meeting Scheduler
• Next Article Full Frontal Access

Typography

• Smaller Small Medium Big Bigger
• Default Helvetica Segoe Georgia Times
• Reading Mode

Share This

User Rating: 3 / 5

Please Rate Vote 1 Vote 2 Vote 3 Vote 4 Vote 5

Version 6.0 of Microsoft Visual Basic (VB) shipped with several enhancements designed to facilitate database programming using OLE DB and ODBC data access methods. GUI controls—such as DataGrid, DataList, and DataCombo—were also added to allow programmers to quickly prototype data-oriented applications. These controls were designed to take advantage of the ActiveX Data Object (ADO) component library. ADO implements a simplified, access pattern-neutral interface to OLE DB, Microsoft’s universal database connector layer. Many vendors implement OLE DB “providers,” or drivers, written to the OLE DB spec so that databases, including the AS/400’s, may be accessed with ADO. With the new controls and ADO, it is possible to use VB to create simple, functional database apps with little or no code. Understanding how these controls work is the key to writing more sophisticated applications with ADO and OLE DB in all Windows environments.

The new data access controls of VB 6.0 belong to a class of controls known as “data aware,” or “data bound,” controls. These controls can be bound to rows and columns of a relational database source, greatly reducing the programming legwork required to manipulate the data. In essence, you predefine the relationships between the data source and the controls that will display and manipulate the data. Thereafter, any changes to the underlying data source are automatically reflected in the control’s display. Likewise, any user changes to editable elements of the control can be made to the underlying data. Perhaps the most anticipated and useful of the VB 6.0 controls is the DataGrid.

Introducing the DataGrid

The DataGrid control combines a data display function (such as the VB Label control) and a data navigation function (such as the VB Adodc control) into a single control. DataGrid sports a highly functional spreadsheet-style user interface. It has many special features for formatting, displaying, updating, and manipulating the data displayed in its rows and columns. As an example for this article, I have used DataGrid and an extremely small amount of code to access an AS/400 file named ORDERS (the file, contained in a *SAVF object, and example code can be downloaded from the MC Web site at www.midrangecomputing.com/mc). You can use ADO objects to open the database

connection and file and to connect those objects to the DataGrid, which will navigate and display the contents of the file.

Before diving into the example, note that the DataGrid and all data-aware controls are fully documented in the Help system that comes with VB 6.0. That documentation is also available on the Web at http:// msdn.microsoft.com/library/devprods/vs6/ vbasic/vbcon98/vbcondataawarecontrols.htm. The example code was developed with Visual Studio on Windows NT 4.0 Workstation with Windows NT Service Pack 3.

Also Visual Studio Service Pack 3 (available at http://msdn.microsoft.com/vbasic/ downloads/ updates.asp) and Client Access service pack SF62608 (available here at www.as400.ibm.com/clientaccess/casp.htm) were installed.

For the example, start with a new Standard EXE project with VB’s Project Wizard (select New Project from the File menu). If it is not already there, use the Components Wizard (also found in the Project menu) to add the Microsoft DataGrid Control to the control palette, as shown in Figure 1. If you already have VB 5.0 on your development machine, be careful not to confuse the DataGrid control with the Data Bound Grid control.

Drag and drop a DataGrid component onto the prototype form. At this point, the DataGrid looks like an empty spreadsheet with two cells. You could simply hook it up to an instance of the Adodc control and set Adodc’s properties for the connection and file (and not have to write a single line of code!). Instead, as an exercise, I’ll have you add the code to open the connection to the data and hook it up to the DataGrid. First, however, you need to add a reference to the ADO component library. From the VB Project menu, select the References option. Select the Microsoft ActiveX Data Objects Library from the list of available references. On the View menu, select Code. Add the following code:

Private Sub Form_Load()

Dim Connection As New ADODB.Connection

Dim Records As New ADODB.Recordset

‘ important against as400

Connection.CursorLocation = adUseClient

Connection.Open “Provider=IBMDA400;" _

+ "Data Source=ASH”

Records.Open “ORDERS”, Connection, _

adOpenStatic, adLockOptimistic, _

adCmdTable

Set DataGrid1.DataSource = RecordsEnd Sub

The Form_Load subroutine is called from the VB runtime engine just before the form is displayed. The code uses two ADO objects: Connection (to open the database connection) and Recordset (to open the file), respectively. The Connection.Open method call specifies the IBM Client Access OLE DB provider and your AS/400. The Records.Open method call specifies the file to open (via the ORDERS and adCmdTable parameters), the open connection to use (the Connection parameter), and the locking/access (the adOpenStatic and adLockOptimistic parameters). Finally, you set the DataSource property of DataGrid1 (the default name of the DataGrid dropped into the prototype form) to the Records object.

Click the Start button, and the DataGrid will display the contents of the ORDERS file. Notice that the scrollbars control the display and, via the Recordset object, access the records of the file.

Figure 2 shows the DataGrid in action. Note that the DataGrid has many properties that affect the display of the data. By clicking on the button at the beginning of each row, you select that row as the current row. Your VB program can thus reference the user’s selected row at runtime via the DataGrid’s Bookmark property. By default, the cells of the DataGrid are editable, allowing the user to change the data in the underlying source if the

OLE DB provider permits. There are simply too many interesting DataGrid features to list here; see the references section at the end of this article for more information.

Because of the intuitive binding between the ADO Recordset and the DataGrid control, it is very easy to change the amount of data displayed by simply changing the query. For example, change the Records.Open method call just listed with the following code:

Records.Open "select "+_

"NAME, ADDR1, CITY, STATE"+_

"from ORDERS", adOpenStatic_

adLockOptimistic, adCmdText

The previous simple file access format is then replaced with an SQL query, as specified by the adCmdText parameter. This query reduces the amount of fields shown for each row in the DataGrid.

Complex-bound Controls and the AS/400

The DataGrid control is known as a complex-bound control, another subclass of data- bound controls. Complex-bound controls can be bound to entire rows of a data source, whereas simple-bound controls, such as Label or TextBox, can be bound only to a single field. Complex-bound controls are highly integrated with the underlying OLE DB data access engine so that they can efficiently and flexibly access the rows of the data sources they are bound to. Controls like the DataGrid, therefore, are best used with databases that have a fully functional OLE DB provider. In particular, OLE DB driver functionality, such as row references (known as bookmarks) and multirecord locking, is critical. Unfortunately, the OLE DB providers for DB2/400 support neither of these features. Note the following code from the DataGrid example:

‘ important against as400

Connection.CursorLocation = adUseClient

This code sets the CursorLocation property of the database connection. It tells the OLE DB provider whether to use client-side or server-side “cursors,” also known as record pointers, for the connection. Remove this line of code and you will see “not bookmarkable” or similar errors. Native DB2/400 and Client Access do not support OLE DB’s server-side cursor semantics, so this line of code is required to indicate the use of client-side cursors. The intent of server-side cursors is to optimize the connection when you might want only a few records and to allow the contents of the Recordset to be efficiently updateable. The effect of this limitation is that the entire contents of the file or query are fetched from the server when the Recordset object is opened, resulting in very poor performance. For large files, this causes a significant delay in the DataGrid example. Of course, one way to prevent this is to use an SQL statement with very narrow selection criteria to restrict the number of records retrieved from the file to a small subset of the records in the file.

It should be mentioned that Client Access also supports a non-SQL, record-oriented access methodology, but it requires secondary, IBM-supplied Component Object Model (COM) objects, making it a less portable solution. Note also that the Recordset Open method in these examples specifies the adOpenStatic parameter, setting a static cursor type for the Recordset’s CursorType property. Data returned in such a method call is static; you can’t use the ADO methods provided to add, update, or delete records in the Recordset and expect those changes to be reflected on the server. The only way to make changes to a file via SQL with IBM’s OLE DB provider is through SQL language statements. All known SQL-enabled OLE DB providers for the AS/400 suffer from the cursor location limitation; however, HiT Software’s AS/400 OLE DB provider does allow a dynamic cursor type. Thus, in the DataGrid example program, you could change the data in the cells, but, unless

you are using the HiT OLE DB provider and dynamic cursors, the changes won’t be made to the file. (Visit Hit Software’s Web site at www.hit.com for a free trial download of its OLE DB provider.)

It can be tricky to effectively use VB 6.0’s DataGrid control with the current OLE DB providers for the AS/400, but, with an understanding of how the underlying OLE DB provider is being exercised, you can pick the right problems to solve with this elegant control.

REFERENCES AND RELATED MATERIALS

• Client Access Service Pack SF62608 download: www.as400.ibm.com/clientaccess/casp.htm

• HiT Software: www.hit.com

• IBM Client Access OLE DB Support: www.as400.ibm.com/clientaccess/oledb Figure 1: The Visual Basic Components Wizard lets you add DataGrid.

Figure 2: The example program reads the ORDERS file and displays its contents in the DataGrid.

BLOG COMMENTS POWERED BY DISQUS

• Previous Article Hang a Left at Calendarville and Head to the AS/400 Meeting Scheduler
• Next Article Full Frontal Access

LATEST COMMENTS

MC Press Online Follow

• Latest Discussions
• Top Commenters

Buyer's Guide Search

All Categories Services Companies Hardware Software Advanced Search

Popular Products

Nexus Portal41,275IPCharge37,165IPCharge37,165Barcode40035,836WebSmart ILE and PHP35,296Presto35,136Catapult33,959Catapult33,959EDI Software - EZConnect iSeries EDI/XML Software Solutions23,603EDI Software - EZConnect iSeries EDI/XML Software Solutions23,603Show more...

Buyer's Guide Menu

• Directory
• All Categories
• All Listings
• Browse By Tag
• Recently Added
• Recently Updated
• Most Favored
• Featured
• Popular
• Most Rated
• Top Rated
• Most Reviewed
• Advanced Search

Support MC Press Online

$0.00 Raised: $

• $12.00
• $24.00
• $36.00
• $48.00

Contribute Now!

Book Reviews

• Book Review: Extract, Transform, and Load with SSIS

  Do your business apps access different data sources? This book shows you how to make that task easier

• Book Review: 21st Century RPG: /Free, ILE, and MVC

  David Shirey’s first book is an educational and entertaining read for “modern” and “old” RPG programmers alike

• Book Review: Developing Business Applications for the Web--With HTML, CSS, JSP, PHP, ASP.NET, and JavaScript

  If you are ready to get into Web application development, take this book along as your guide

• Book Review: DB2 10.5 Fundamentals for LUW: Certification Study Guide (Exam 615)

  DBAs who use the book will find it very helpful first in their test study and later as a reference book.

• Book Review: DB2 11 for z/OS Database Administration—Certification Study Guide

  This is a well-written DB2 11 book that could easily stand on its own as a reference manual, not just a certification guide.

• Book Review: Free-Format RPG IV, Third Edition

  Jim Martin comes through for us again.

• Book Review: IBM i Security Administration and Compliance, Second Edition

• Book Review: Programming in ILE RPG, Fifth Edition

  This book really hits the mark and is a must-read for all RPG developers.

• Book Review: DB2 10.1/10.5 for Linux, UNIX, and Windows Database Administration: Certification Guide

• Book Review: Subfiles in Free-Format RPG

  Whether you're a newbie or a seasoned pro, this book has something for you.

• Book Review: Evolve Your RPG Coding: Move from OPM to ILE ... and Beyond

  This book provides an amazingly comprehensive introduction to the concepts while at the same time delivering enough technical detail to make you productive very quickly.

• Book Review: Database Design and SQL for DB2

• Book Review: The Chief Data Officer Handbook for Data Governance

  When implemented appropriately, data governance is a powerful framework.

• Book Review: DB2 10 for z/OS: The Smarter, Faster Way to Upgrade

  Trying to figure out whether to upgrade? Read on.

• Book Review: 5 Keys to Business Analytics Program Success

• Book Review: DB2 11: The Ultimate Database for Cloud, Analytics, and Mobile

• Book Review: Flexible Input, Dazzling Output with IBM i

  Today, it's all about input and output. Getting data into the IBM i from non-traditional sources and then displaying it back out again in varied formats. But where can you go to learn all that you need to know about this critical skill?

• Book Review: Advanced Guide to PHP on IBM i

  Enterprise-level PHP skills and techniques have been adapted for IBM i developers in Kevin Schroeder's new book.

• Book Review: Java for RPG Programmers

  If you've been putting off learning Java, you have no excuse anymore!

• Book Review: DB2 10.1 Fundamentals: Certification Study Guide

  Too valuable to be classified as merely excellent certification material, this book should also rightly take its place on DB2 DBA bookshelves as a solid day-to-day DB2 reference.

• Book Review: DB2 10 for Z/OS Database Administration: Certification Study Guide

  Whether you're trying to get certified or you just need a great reference book, this is the book for you.

• Book Review: Developing Web 2.0 Applications with EGL for IBM i

  It's everything you need to know, from the bottom up.

• Book Review: Advanced Integrated RPG

  Isn't it about time somebody told us how to integrate RPG and Java?

• Book Review: Managing Without Walls

  If you manage remote or satellite teams, this book is a must-read!

• Book Review: Managing Without Walls

  If you manage remote or satellite teams, this book is a must-read!

• Book Review: The Remote System Explorer

  This book speaks directly to the thousands of IBM i programmers who develop in RPG, COBOL, CL, and DDS every day.

• Book Review: IBM System i APIs at Work, Second Edition

  API expert Bruce Vining delivers the only comprehensive guide to APIs.

• Book Review: Functions in Free-Format RPG IV

  This one short volume manages to essentially be both a general introduction and a detailed reference.

• Book Review: DB2 11: The Database for Big Data and Analytics

• Book Review: IBM Mainframe Security: Beyond the Basics

  Beginners will have a strong foundation after reading this book. Experienced professionals will reference it frequently.

• Book Review: IBM InfoSphere: A Platform for Big Data Governance and Process Data Governance

  Find out how IBM is addressing the challenges of big data.

• Book Review: Fundamentals of Technology Project Management

  Projects can be overwhelming, but taken in small, deliberate steps, all projects are achievable.

• Book Review: Customer Experience Analytics

  Use CEA as a strategic weapon to stay ahead of your competitors.

• Book Review: Big Data Analytics: Disruptive Technologies for Changing the Game

  The disciplines of data analytics are evolving to meet the new challenges of big data.

• Book Review: IBM i Security: Administration and Compliance

  If you have any interest in IBM i security, whether as an administrator, a programmer, or an auditor, then this book is the perfect resource.

• Book Review: DB2 9.7 for Linux, UNIX, and Windows Database Administration (Exam 541)

  This book, written by the creator of the certification exam, reveals exactly what you'll need to know to prep for the test.

• Book Review: Selling Information Governance to the Business

  Who governs the information that runs your company?

• Book Review: You Want to Do WHAT with PHP?

  If you're serious about programming in PHP, get a book that treats you that way.

• Book Review: The IBM i Programmer's Guide to PHP

  Both a primer and a reference, this book is a must-have for anyone who wants to program in PHP.

• Book Review: JavaScript for the Business Developer

  There's no faster, easier way to become proficient in JavaScript.

• Book Review: SOA for the Business Developer

  If you want to know how SOA works in the real world, this is your book.

• Book Review: DB2 9 Fundamentals

  Whether you want to obtain an IBM certified DB2 professional certification or simply become well-rounded in the fundamental concepts of DB2 and general database theory, this is your book.

• Book Review: The Modern RPG IV Language, Fourth Edition

  This book isn't a training manual; it's a reference book.

Resource Center

• How to Modernize Fast and Within Budget (Quick Guide)

• Why Migrate When You Can Modernize?

  Business users want new applications now. Market and regulatory pressures require faster application updates and delivery into production. Your IBM i developers may be approaching retirement, and you see no sure way to fill their positions with experienced developers. In addition, you may be caught between maintaining your existing applications and the uncertainty of moving to something new.

• Resource Center

  The MC Resource Centers bring you the widest selection of white papers, trial software, and on-demand webcasts for you to choose from. >> Review the list of White Papers, Trial Software or On-Demand Webcast at the MC Press Resource Center. >> Add the items to yru Cart and complet he checkout process and submit

• IBM i Transformation Risks Every Business Leader Should Know

  Join us for this hour-long webcast that will explore:

• What to Do When Your AS/400 Talent Retires

  IT managers hoping to find new IBM i talent are discovering that the pool of experienced RPG programmers and operators or administrators with intimate knowledge of the operating system and the applications that run on it is small. This begs the question: How will you manage the platform that supports such a big part of your business? This guide offers strategies and software suggestions to help you plan IT staffing and resources and smooth the transition after your AS/400 talent retires. Read on to learn: