To edit a VPT shortcut created with the Shortcut wizard, simply right-click the new Viewpoint shortcut icon and choose the Open option from the drop down menu.
shcut_edit.bmp
In Notepad you can edit the entries and values of the shortcut, however the Shortcut Wizard (page 17) is easier to use and less prone to error.
Each Section of the VPT shortcut starts with a Section Heading enclosed in brackets ( [ ] ) and contains one or more Section Entries.
A Section Entry follows the format of Keyname = Value.
vpt layout.bmp
Data
The vpt file always starts with the [Data] section. This section specifies the name of the SEQUEL/ViewPoint object (view, report, table, script) to process.
[Data]
Function
The [Function] section is the second part of the vpt file. It specifies the Option (more precisely the command) that will be performed against the object named in the [Data] section. Each Option (Display, PC_File, AS/400_Print, etc.) has its own set of required and optional entries (keynames). Each Option and it's required and optional keynames are explained below.
[Function]
View = [[system/]library/]object Sets SEQUEL object to process.
Title = Results window title. Sets the name to appear in the title window for a view - only valid when used with DIS- PLAY or VIEW options.
Hidden = Y or N Hide the view results grid - useful if you only want to see graphs.
Option = DISPLAY or VIEW Display SEQUEL object results.
No other entries required.
Option = PC_FILE Creates a PC file on the PC or on the AS/
400.
Target = AS400 or PC Specify host or client for the file loca- tion
File = Prompt or directory/file- name
Prompt will prompt the user for a file name
when the VPT is run.
PC Syntax - c:\temp\filename.extension. 400 syntax - /ifs path/filename.extension. Multiple files are separated by a semico- lon. If graphs are defined via [GRAPH] paragraphs, the file names listed here will contain the results of GRAPH01, GRAPH02, etc. in sequence. If the number of filena- mes exceeds the number graph definitions, the final file name will contain the data results.
FileType = A valid file type e.g. *XLS, *HTM, *CSV
MaxRecords = # Maximum number of records to add to the file up to 999.
Zero value indicates all records should be processed.
Optional Values If file results are being created in the IFS on the 400, then those files can be emailed.
EmailAddress = Recipient Email address or recipients separated by semicolons.
EmailSubject = Subject value Subject line EmailMessage = Message value Message line EmailFileName = /ifs path/file-
name.ext
Filename(s) separated by semicolons of files located in the IFS.
Option = AS400_PRINT Sends the results to an AS400 printer. OutQ = Name, Prompt, Default Name is a valid AS400 output queue.
Prompt will prompt the user for the output
queue when the vpt is run.
Default will use the default output queue
for the user.
Option = PC_PRINT Prints the results on a PC printer. Printer = Name, Prompt, Default Name is the name of a PC printer.
Prompt will prompt the user for the PC
printer name when the vpt is run.
Default will use the PC's default printer. Optional Values
SizeToFit = Y or N Automatically adjust the font size to fit on the paper.
Orientation = P or L Print in portrait or landscape mode.
Option = AS400_FILE Creates a physical file on the AS/400. Library = AS/400 library name
File = Name, Prompt Name is a valid physical file name for the
results.
Prompt will prompt the user for a file name
when the vpt is run. Member = File member name
Optional Values
MaxRecords = # Maximum number of records to add to the file.
Option = EMAIL Email the results from the AS/400. EmailAddress = Recipient Email address of recipients separated by
semicolons.
Option = PC_FILE Creates a PC file on the PC or on the AS/
The following entries can be used with any of the Options above.
Variables
In the [Variables] section values can be specified that should be passed to run-time prompted requests (views).
[Variables]
Graph
The [Graph] section is usually created by saving window definitions after displaying data and creating a graph. This section contains the settings for the graph control to recreate the graph results. These three settings below control whether the Title, Labels, and/or Legend for the graph will be drawn from the view data or whether they will be the values saved into the .VPT file.
EmaiFileName = Filename.ext Filename of results to be created and emailed.
EmailFileType = File type value *XLS, *HTM, *CSV, etc.
Optional Values
EmailSubject = Subject value Subject line EmailMessage = Message value Message line
Option = DESIGN Open the object in it's designer. No other entries required
Option = JOBD Prompt to submit the request.
Jobd = Prompt, *NONE, Default Prompt will prompt the user for a valid job
description.
*NONE will not submit - run immediate. Default will use the jobd specified for the
user’s Sequel defaults.
QuietMode = 0 or N = 1
= 2 = 3 or Y
Show all messages as the vpt runs. Show warning and error messages only. Show error messages only.
Show no messages.
Logging = Y or N Specify Y to create the VPLOG.txt execution log. N is the default.
Variable Name = Value Variable Name is the variable defined in
the view or script.
Value is a number or character value to
pass to the variable.
[Graph]
Command
The [Command] section is generated by the Shortcut Wizard and is for information only. This is the complete command, with command line switches, that could be run from a DOS command line or the Windows Start=>Run option to produce the same results as the vpt shortcut.
[Command]