Generate a report from your database using CL.

Written by Bruce Vining

Last month, in "Using the SQL Select Statement with RUNSQL," we reviewed how to query, or select, data from a SAMPLE database (also created in the referenced article). In last month's program, we simply displayed, using the CL command Send Program Message (SNDPGMMSG), the results of an SQL Select as shown below.

osTicket has paid support if you need it, but a robust user community is there to help the uninitiated.

Written by Chris Smith

In a recent episode of Help Desk, the Web comics cartoon series that parodies the computer industry, Alex (the cartoon's protagonist) is confronted by a caller who asks for a list of questions to which Alex knows he has answers. The reason? "It seems like every time I call, you can't help me," the anonymous voice says. "Whatever problem I have just so happens to be the one issue that is completely out of your hands." The caller's solution to this dilemma is to work the problem backward. "Why don't you give me a list of topics you know you have an answer to, and I'll pick one of them?"

Automate your job scheduling and eliminate sleepless nights.

Written by Tom Huntington

What keeps you up at night? Imagine being a data center manager and having to worry each night whether your team will run processes in the correct order, whether they might miss an event, or whether they'll forget that there is a special process to run.

The State of IBM i Security 2012

Too many powerful users? Unrestricted network access? Default passwords? Each year, PowerTech audits hundreds of IBM i servers and compiles the data in its annual State of IBM i Security study. Download the2012 study to learn where your system is vulnerable and how you can protect it.

Download your copy today.

Don't miss these great offerings in the MC Press White Paper Center:

Latest White Papers:

A Thirst for Efficiency: Trinks Enlists CCSS for Effective Systems Management

Baker College Makes IBM i Apps More Cool, Less Old School, with Profound UI

DMZ Gateways: Secret Weapons for Data Security

IBM i Message Management and Resource Monitoring

Lights Out IBM Automation

PCI DSS Compliance with Managed File Transfer

Protecting Your Data - How Much Security is Enough?

Security Considerations for the Cloud

Plus Choose From This Amazing Selection, Too

10 Top Job Scheduling Challenges for your IBM i and How to Solve Them

101 things you can Automate on your IBM i & 10 Tips for Peace of Mind

5 Shortcuts to Sensible Operational Security

A FREE HA/DR Jargon Buster

A Thirst for Efficiency: Trinks Enlists CCSS for Effective Systems Management

A Visual Guide To Automated MVC Reengineering for RPG Applications

A Visual Guide to Cost Effective Testing on the iSeries

Assess the Appropriateness of the iSeries/IBM i in My Business

Baker College Makes IBM i Apps More Cool, Less Old School, with Profound UI

Best-of-class Financial Systems Strategy: An Alternative to ERP Platforms

Best Practices in Data Protection: Encryption, Key Management and Tokenization

Best Practices in Managed File Transfer Solutions

Best Practices: The Fundamentals of Document Automation

Beyond FTP: Securing and Managing File Transfers

Bringing Mashups to Your Enterprise Business Applications

Business Continuity Today Ch.11: Is the Cloud Right for You?

Critical Elements for Business Continuity

Defending Against Data Breach: Developing the Right Strategy for Data Encryption

DMZ Gateways: Secret Weapons for Data Security

Driving IT Value from the Cloud - Creating a Five Phase Roadmap to a Hosted IBM i Cloud

Enter Our "On Demand Isn't Just for TV" Contest to WIN One of THREE Apple TV's!

Five Reasons Why Smaller Organizations Should Consider High Availability

FREE Chapter of IBM Business Analytics and Cloud Computing

Get the Facts on Information Availability: Essential Data Protection, Recovery and Resiliency for Banks

Getting the most from your SAP production reports

Getting the Most out of Your Audit Journal - Handouts

IBM i Message Management and Resource Monitoring

IBS and IBM Optimize ERP for Midmarket Distributors

Keeping your System i Applications Relevant in a Service-Oriented World

Key Strategies for ERP on IBM i and Infor and IBM

Less Stock, More Profit: Inventory Optimization

Lights Out IBM Automation

Make “Paperwork” Smarter

Managing Data and Healthcare Regulations Efficiently

Modern Monitoring Methods for Power Systems

Next Generation Disaster Recovery and Availability Technologies for IBM Power Systems

Oh no! Another Audit!

PCI Compliance for Power Systems Running IBM i

PCI DSS Compliance with Managed File Transfer

Protecting Your Data - How Much Security is Enough?

Research Study: New 4th Annual Report! The State of Resilience 2011

Revolutionizing System i Application Modernization

Seamless Solution for Discontinued IBM Domino Fax for i Customers

Security Considerations for the Cloud

Six Ways to Reduce PCI DSS Audit Scope by Tokenizing Cardholder Data

SOA What? Why SOA is Critical for iSeries RPG Shops

Supply Chain Synchronization: Recession-proof Strategies for Improving Efficiencies

System Moderization Survival Guide

The Eight Pillars of an Enterprise Application Application Architecture

The Hidden Cost of Compliance

The Power of Information Availability--What Every Senior Executive Should Know *

Using Microsoft .NET to Build Scalable Enterprise IBM i Applications

Using Software for Compliance…

Ways to Use IBM i Audit Journal

What Authorities Do Programmers Really Need?

Why Companies Fail PCI Audits - Handouts

You Don’t Trust Me Anymore!

*Some offers may be limited to U.S. and/or Canadian citizens only. Please see the site for details.

The MC Webcast, MC White Paper, MC Software, MC Case Study, MC Security, and MC Disaster Recovery Centers bring you the widest selection of IBM Power Systems white papers, software, webcasts and more. And just like on demand TV our partner solutions are waiting and ready to be delivered when you want, where you want. All you have to do is visit and start choosing from dozens upon dozens of offerings and we’ll send them right to you. We’re even giving away not one but THREE Apple TV’s to three very lucky people. Visit the MC Resource Centers today and select as many of the FREE offerings you would like. While there, enter the contest and you may just an Apple TV unit of your very own!

Have a White Paper you would like to list? click here or call (208) 726-6822 for information.