I want SEQUEL to run my view every day and send the results to my PC. How can I make sure the file has a unique name each day?
You can create a SEQUEL Script to run the EXECUTE command and create Excel output that is e-mailed to your PC. For example...
Working with dates, times, and time stamps When you start analyzing data, you begin to realize how much of it is time-sensitive. As a result, you may have questions about date and time formatting; how to create and manipulate dates, times, and time...
For sound business decisions, you need easy-to-use tools to review data, analyze data, retrieve data, and present it in meaningful ways. You need to see supporting data, make the right decisions, and make them reliably. Before you can do this, you...
I know that no SEQUEL or ViewPoint jobs can be running when I upgrade. How do I make sure no one is using the product?
There are three ways you can check for SEQUEL and ViewPoint jobs on the System i:
There are times you want to pass a variable to a SEQUEL view without having the user see or supply the value. For example, you may want to pass the job date or system time into the title of the view, report, or table. SEQUEL includes several...
When you create a SEQUEL script, you can combine multiple commands into a job stream. If multiple SEQUEL objects in the script prompt for variables, you can use the SETVAR parameter so that you are prompted only once for the variables that will be...
Here are some recent product enhancements to ABSTRACT and SEQUEL.
ABSTRACT is a set of integrated cross-referencing, documentation, and programming tools for the System i, that helps you create, work with, and analyze your software applications. We...
SEQUEL includes a report writer called the SEQUEL Host Report Writer. This writer produces reports using monospaced fonts typical of the System i (AS/400). The great advantage of such reports is that they make it easy to line up items such as...
Do you want to get up to speed on SEQUEL without leaving your office? SEQUEL Software now offers in-depth online training on SEQUEL ViewPoint!
These live, instructor-led sessions are two or three hours in length. Each class includes concept lectures...
