May 25, 2012 | Volume 9 Issue 21

ISSUE HIGHLIGHTS

TOP STORY: The CL Corner: More on the RUNSQL CL Command
FEATURED ARTICLE: Free Open-Source Help Desk Solution Running on IBM i Appeals to Users and Management
ADVERTORIAL: Partner TechTip: How Can You Sleep at Night Without It?
NEWS HIGHLIGHT: Halcyon Announces Advanced Job Scheduler V9.0 for IBM i
WHITE PAPER: The State of IBM i Security 2012
FORUM: Trouble with SQL2XLS
Manage Subscription | Contact Us

Sponsor - Business Computer Design
 

Give your Green Screens a Rich Web GUI with Presto - Deliver them as Mobile Web Apps too !

See why Presto is the fastest to give your green screens a rich Web GUI that can be accessed from browsers on PCs, Tablets & Smartphones. Managers and users will love the new modern look and ease of use of their apps, and you'll love how much more relevant your IBM i apps have become. View the 2 Minute Video - Try Presto for Free.

 


Read More >>

Feature Article - Programming
 
The CL Corner: More on the RUNSQL CL Command

Generate a report from your database using CL.

bruce_viningWritten 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.


Read More >>

Sponsor The MC Press Bookstore
 
The Essential Guide to Security. In this practical and highly readable guide--an update to her acclaimed IBM i & i5/OS Security & Compliance: A Practical Guide--security expert Carol Woodbury explains IBM i security and the way it functions within IBM i systems. Whether you’re new to IBM i or a seasoned veteran, this book contains the critical information and explanations you need to successfully maintain a secure system. Download a FREE chapter of this book today. >>
Read More >>

Feature Article - Application Software
 
Free Open-Source Help Desk Solution Running on IBM i Appeals to Users and Management

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

chris_smithWritten 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?"


Read More >>

Advertorial - Help/Systems
 
Partner TechTip: How Can You Sleep at Night Without It?

Automate your job scheduling and eliminate sleepless nights.

tom_huntingtonWritten 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.


Read More >>

MC White Paper Center
 
FEATURED WHITE PAPER

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.


Read More >>

In the News

Read More >>
Support MC Press - Visit Our Sponsors

 

Forums Sponsor

POPULAR FORUMS
  1. Rpg sql insert into qtemp table (2020 views)
  2. What is better, free code or traditional code ? (1748 views)
  3. cant ping workstation from system i (1417 views)
  4. was 7 nd server not starting (1250 views)
  5. SQL Error 802 Type 6 - Numeric Handling for Joins? (570 views)
  6. ODF Release April 28, 2012 (495 views)

Forums

 

 

Search Sponsor

 

Search


Read More >>
   MC-STORE.COM