All my SEQUEL reports are printing duplex. How do I change that?
You can turn off duplex printing by changing the SEQUEL/SQLPRT1 printer file. Use the following Change Print File (CHGPRTF) command:

CHGPRTF FILE(SEQUEL/SQLPRT1) DUPLEX(*NO)

I want to use Robot/ALERT to send e-mail messages, but my System i is not configured as an e-mail server. Is there a way around this?
Your System i doesn’t have to be an e-mail server for Robot/ALERT to send e-mail messages. If you use Robot/GUIDE for Automated Vendor setup, you simply specify the domain name or IP address of your SMTP e-mail server in the Outbound TCP/IP Host field. If you are using a two-way e-mail connection, specify the domain name or IP address of your POP3 e-mail server in the Inbound TCP/IP Host field.

Users are raving about Robot/SCHEDULE’s new job monitors

Robot/SCHEDULE Job Monitors are designed to help you identify job schedule problems. You specify the jobs you want to monitor for the following Job Monitor events:

* A job that runs too long

* A job that completes too fast to have run properly

* A job that starts later than its scheduled time

The Robot/SCHEDULE 10 job monitors help you monitor critical jobs for specific events such as jobs that run too long, complete too quickly, or start later than scheduled. (Click on the thumbnail above to enlarge.)

In 2008, U.S. Daylight Saving Time begins on March 9 and ends on November 2. Whether you change the time manually or have the system change the time automatically, the most important thing to keep in mind is that Robot/SCHEDULE must be inactive when the time change is made.

Two ways to set up the time change
Basically, there are two ways to accomplish the time change in Robot/SCHEDULE.

1. Create a CL program to end Robot/SCHEDULE, change the time, and restart Robot/SCHEDULE. (You can set up a Robot/SCHEDULE job to call this program.) This approach is explained in the Help/FACTS “Using Robot/SCHEDULE to automate Daylight Saving Time change.”

Expands job monitoring, comparisons, and more!

Help/Systems, the world’s leader in automated operations and business intelligence software for the IBM System i, announces the release of Robot/SPACE 3.0, the newest version of its software that automatically monitors and manages IBM System i disk space. Robot/SPACE eliminates disk storage crises by notifying users of potential trouble and provides tools for quickly finding disk storage problems.

Robot/SPACE job monitoring has been expanded to allow users to monitor the storage allocated by their QTEMP libraries and spooled files for active jobs on their system. All three job monitors can track detail information for every threshold exception, and can be configured using Robot/GUIDE.

Give developers and administrators access without losing control of security

How much authority do your developers and administrators need on your production systems? Does each programmer need *ALLOBJ authority? Have you ever failed a security audit because of too many user profiles with too much special authority? When end users call your Help Desk for help with authority problems, does the Help Desk ask for the end user’s password and then sign on to test the authority issue?

Can multiple people use profile exchange to exchange to the same alternate user profile?
Yes, they can. When multiple users exchange to the same profile, it can be a little harder to investigate which user made a specific change while using the profile. You need to refer to the Robot/SECURITY Activity List to determine which user was using Profile Exchange at that time to determine who was responsible for the change.

SEQUEL ViewPoint provides grid control features that let you format your view results. You can:

• Choose contrasting colors for even/odd result rows
• Format different aspects of your results (such as headings, rows, and selection area) distinctively, including font attributes (style, size, weight, and color) and foreground/background colors.
• Use conditional formatting to highlight exceptions
• Use the Fast Group-and-Sum function for non-summarized data

Let’s look at how you might use some of these capabilities. Two sample order files, ORDHEAD and ORDLINE, are shipped with SEQUEL. Using these files, you can create a very simple SEQUEL view with the following statement:

I am planning an operating system (OS) upgrade. How do I find out what I need to do for Help/Systems products?
Call us before you update your OS to a new level. Some product versions may not be compatible with the upgraded OS. Each product needs to be reviewed to see if it needs updates before you update the OS.

What is the easiest way to set up a Report Set in Robot/REPORTS?
Use Robot/GUIDE. Robot/GUIDE ensures you don’t make typos when defining comparison information and prevents you from missing steps in the setup procedure.

Send jobs Host-to-Host or Node-to-Node with Robot/NETWORK 10.0

If you haven’t discovered Robot/NETWORK packets, you are in for a treat. You can use Robot/NETWORK packets to centrally control and maintain:

* Robot/SCHEDULE job setups

* Robot/CONSOLE message sets, message tables, and message groups

* Robot/REPORTS report sets

Once you start using packets, you no longer have to sign on to multiple systems and create the same objects over and over. Not only do packets save you time, but they also reduce errors caused by repetition. You create an object once and use it many times.

Here’s how to cut through the clutter in QAUDJRN and learn more

You hear the same complaints again and again: The security audit journal, QAUDJRN, contains too many entries. It’s too hard to make sense of all the details. Do you really care that you have 1592 program adopt entries one day, and only 450 the next? Do you need to copy the journal receiver to a database file every day? What exactly do all the different entry types mean?