Select a Product
Select the product you have a question about from the drop-down menu.
How do I set the return address on a scheduled e-mail request to display as ‘Customer Service’ instead of the system administrator that submitted the job?
For both the ESNDMAIL and ESNDFILE command you use the OVRUSROPT parameter to specify the override user you want to use as the sender.
Can I receive a return receipt for my sent mail?
You can configure ESEND to request a return receipt, but you only receive one if your recipient’s e mail server supports this feature. To request a receipt, enter the command ESNDUSR, select the RECEIPT option from the user defaults list, set it to *YES, and press Enter. All of your e-mails will now request a return receipt.
How do I create or change the return address for my e-mail?
Enter the command ESNDADR and press Enter. If your return address exists, you can select it from the list and edit it. Otherwise, enter your name and e-mail address to create a new entry.
How do I create a source file to use as my own e-mail or FTP list?
Use the following command:
CRTSRCPF FILE(LIBRARY/FILENAME) MBR(XXX) TEXT('My own list')
You can use SEU, or another editor, to add values to the file. Do not split addresses between lines.
How do I hide the user and password information in the previous command?
You can’t—you must use the Maintain Server Profiles feature and create an FTP Server Profile. This profile contains all the information required to use FTP, including the username and password. Only the server profile is referenced in the RECIPIENT parameter.
ESNDMAIL RECIPIENT(SVR_PROF) ATTLIST((* *DFT '/tmp/file.xls'))
How do I send a document using FTP?
The RECIPIENT parameter of the ESNDMAIL or ESNDFILE command specifies the IP address, plus a file path, the file name, and a valid user and password on the remote system.
ESNDMAIL RECIPIENT('ftp:111.222.333.444/path/filename(user/pwd)')
ATTLIST((* *DFT '/tmp/file.xls'))
What is the correct syntax to send multiple spooled files in a single e-mail?
When you use the ESNDMAIL command to send multiple attachments, the ATTLIST parameter lists all of the spooled files to send. Each attachment is defined by the spooled file name plus the job number, user, and name.
ESNDMAIL RECIPIENT('user@helpsystems.com')
ATTLIST((* *DFT *N QPRINT 383929/user/QPRTJOB 000012 1)
(* *DFT *N CUSTLISTPR 383929/user/QPRTJOB 000021 1)
(* *DFT *N QSYSPRT 383929/user/QPRTJOB 000028 1))
How do I send a file from the IFS?
Use the ESNDMAIL command and specify the IFS file in the ATTLIST parameter:
ESNDMAIL RECIPIENT('USER@HELPSYSTEMS.COM') ATTLIST((* *DFT '/tmp/file.xls'))
What is the difference between the ESNDMAIL command and the ESNDFILE command?
The main difference is that the ESNDMAIL command allows multiple attachments and the ESNDFILE command allows only one attachment.
How do I verify that the required ESEND jobs are running?
Enter the command WRKACTJOB JOB(QMSF) and press Enter. There should be three QMSF jobs listed. Next, enter the command WRKACTJOB JOB(QTSMTP*) and press Enter. There should be four jobs listed.
Some of the messages I send show up as multiple garbled e-mails. What is causing this?
By default the mail server framework splits large e-mails into several MIME encoded files. To prevent this, enter the following command:
CHGPOPA MSGSPLIT(*NOMAX)
The time for my sent e-mail is incorrect. How do I fix this?
ESEND uses system values to display the date and time for sent messages. For V5R2 and earlier, display the system value QUTCOFFSET and verify that the local time offset from the Universal Time/Greenwich Mean Time is set correctly. For V5R3 and higher, display the system value QTIMZON for time zone.
For example, the Chicago area uses an offset of -500 for Central Daylight Time (CDT) and -600 for Central Standard Time (CST).
Can I send faxes using ESEND?
Yes, ESEND supports the IBM SNDFAX command. Use ‘ftp:nnnnnnnnnn’ for the RECIPIENT parameter, where ‘nnnnnnnnnn’ is the fax number.
Can I use both e-mail and FTP addresses at the same time?
Yes.
Can I create a default signature for all e-mails?
Yes. Just enter the following command and press Enter:
ESNDSGN USER(*SYSTEM)
You can enter up to six lines of information. This information becomes the “base” value for all user signatures.
Can I embed attachments into the body of an e-mail?
Yes. There are two ways to do this using the ESNDMAIL command. You can embed the attachment at the end of the body text, or you can insert the attachment at a location you specify in the message text. For complete information about embedding attachments, refer to the ESEND User Guide.
How many attachments can I send with ESEND?
With ESEND, you can send up to 300 attachments per message, with a maximum message size of 16MB.
What is the MOD function, and what would I use it for?
MOD (modulus) returns the remainder of a division of the first operand by the second. It is very useful to extract part of a numeric field, and used in conjunction with subtraction and division, the MOD operation is like a numeric equivalent to the substring function. This example shows how to use MOD to extract parts of a MMDDYY numeric date.
122506 MOD 100 = 06
122506 MOD 10000 = 2506
122506 - (122506 MOD 10000) = 120000
122506 MOD 10000 - 122506 MOD 100 = 2500
What firewall ports need to be opened so I can use ViewPoint from home?
ViewPoint makes requests to IBM System i Access host servers. These servers "listen" on System i TCP ports for incoming requests. In order for ViewPoint to operate across the Internet, these port accesses to the System i must be allowed through the firewall:
|
Service Name
|
Host Server
|
Port
|
SSL Port
|
|
as-svrmap
|
*SVRMAP
|
449
|
|
|
as-central
|
*CENTRAL
|
8470
|
9470
|
|
as-database
|
*DATABASE
|
8471
|
9471
|
|
as-dtaq
|
*DTAQ
|
8472
|
9472
|
|
as-rmtcmd
|
*RMTCMD
|
8475
|
9475
|
|
as-signon
|
*SIGNON
|
8476
|
9476
|
I used the New Report Wizard to create a report, but I forgot to add a page break. Do I have to redo the report?
No. On the report design screen, locate the format line that represents the field you wish to break on (usually one of your Order By fields). Use your mouse and right-click the yellow block at the far left of the line. Select 'Properties' from the menu. In the Report Line Properties dialog, Check the 'Skip After' box, and place a '1' in the field next to that. Press the OK button. A 'Skip After 1' equals a page break.
How do I add a prompt value from my view in the LDA?
Add an integrity test to the variable definition to write the prompted value to the local data area. Use - sst(*LDA,aaa, bbb) - where aaa is the starting position and bbb is the length of the substring. Values in the LDA can be retrieved by high level programs, a calculation in the Report Writer, or with the DTAARA function in a view.
Before I upgrade, how do I check who is using SEQUEL or SEQUEL ViewPoint?
There are two options for this:
- Issue the command ASCSUPPORT/WAQZ for a list of ViewPoint jobs This list will also include other Client Access/QZRCSRVS jobs.
- Run the view SEQUEL/SQUSERS for a complete list of SEQUEL and SEQUEL ViewPoint jobs on the system. This same information is available in the ViewPoint Administrator using the Active Sequel Users option.
How do I to create a PC file from my view and save it on an NT server in our network?
After you display the results, and if you have the server mapped to a drive, you can simply use File > Save As to select the PC file type and browse to the mapped drive to create the file. If you want to automate the process, or you do not want to display the results first, you need to create a script and use the EXECUTE command to create and FTP the results to the server. For example:
EXECUTE VIEW(VIEW/LIB) PCFMT(*XLS) RECIPIENT('ftp:111.222.333.444/dir/filename.xls(userid/pwd)')
You must specify the address, folder (dir), and file name. You also need a valid user ID and password on the remote system.
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 Change Print File (CHGPRTF) command like so: CHGPRTF FILE(SEQUEL/SQLPRT1) DUPLEX(*NO)
How can I remove non-alpha characters from a string?
Two functions together can be used to convert non-alpha characters to blanks, then to remove the blanks from the string. Given a field called X that has a value of - "a!b@c#d$e" - first use TRANSLATE to replace the non-alpha characters with blanks like so:
TRANSLATE(X," ","!@#$")
This results in - "a b c d e".
The second function - STRIPX - is used to remove multiple occurrences of a character from a string. In this case, the blanks created by the TRANSLATE function are removed.
Add STRIPX to the calculation above:
STRIPX(TRANSLATE(X," ","!@#$")," ")
To achieve the final result of "abcde"
I am trying to Join 2 files using a derived field and ViewPoint shows me an error - 'File xxx is not referenced in the JOIN specification'. How do I avoid the error so I can run the view?
First, press the OK button to close the error message. Then, on the menu select Options > ViewPoint Options > Design Tab. Un-check both 'Ensure files are joined' and 'Enable auto joining' in the File Join Options section. This will allow the view to run with the derived join.
How do I make a Script run when I open a Dashboard?
There are two options for making a Script run in a Dashboard: Automatically or by pressing a button. For each you have to add an Action Button to your Dashboard.
1. Create a new Dashboard or open an existing Dashboard in design mode.
2. Select Insert > Action Button from the menu.
3. In the Action Button dialog, press the Sequel Object button and navigate to your script.
4. Check the 'Autorun' box so the script will run when the Dashboard is opened. If un-checked, you will have to press your new Action Button to run the script.
How do I send the output from two views to a single file on the
System i?
First, the output from both views needs to 'map' correctly. Meaning, each must generate the same number and type of data columns.
A simple two-line script is used to create, and add data to, a single file:
10 EXECUTE VIEW(lib/view1) OUTFILE(lib/file1)
20 EXECUTE VIEW(lib/view2) OUTFILE(lib/file1) MBROPT(*ADD)
What do I change to allow a new user to design views?
This is controlled by a user-specific default option - 'Allow ViewPoint Design Mode'. You can use the ViewPoint Administrator - Set Sequel Defaults feature, or prompt the command SEQUEL/SETDFT for a given user to set this default.
The name of a data library has changed. How do I change all my views to use the new library name?
An easy way to do a find and replace of a library within many views is to use the SEQUEL command DSPVIEWD. Follow these steps:
1. CHGCMDDFT CMD(SEQUEL/CRTVIEW) NEWDFT('replace(*yes)')
2. DSPVIEWD LIB/*ALL TYPE(*SRC) OUTPUT(*OUTFILE) OUTFILE(QTEMP/QXLSRC) OUTMBR(ALLVIEWS)
3. A source file will be created that can be edited. Issue the command:
STRSEU QTEMP/QXLSRC ALLVIEWS
Use option 2 to edit, and then use F14-Find/Change to change the old name to the new name.
4. Compile and run the program. All the views will be recreated.
5. CHGCMDDFT CMD(SEQUEL/CRTVIEW) NEWDFT('replace(*no)')
How can I create my own reports on the Administrator files for a list of users and the libraries/files they have access to?
You can use the Administrator to quickly view or modify the exclusion settings. To create your own lists and reports, use the file is SQLEXCL in library SEQUEL. Here is a sample view:
SELECT usrprf, fldnme, filnme, libnme
FROM sequel/sqlxcl
ORDER BY usrprf
My table only generates 15 columns. How do I make more?
Open your table in design mode. Right click on your category and select 'Edit Category from the menu. Change the 'Maximum number of column groups' to the number you desire. 2048 is the limit.
When I connect to my System i, how do I control the libraries that are displayed?
You need to create a 'Custom List' of libraries and then select your custom list to display.
1. On the ViewPoint Explorer menu, select Options > ViewPoint Options > General Tab.
2. Press the 'Edit Custom Library List for XXXX' button.
3. Highlight a library in the System Libraries list and press the Add button to move to your Custom List. Press OK when finished.
4. Right-click your System i icon in the ViewPoint Explorer display and select *CUSTOM from the menu to see your custom list of libraries.
How do I create a sequence number in my view results?
Simply add this derived field - accum(1) - to your view like so:
SELECT ACCUM(1) NAME(seq) LEN(3,0), cusno, cname
FROM sequelex/custmast
I frequently get errors when I try to convert a numeric field to a date using CVTDATE, because the field may be blank. Is there a better way than substituting a date such as 1/1/1940?
The Valid_Date function is very useful in this situation.
A calculation like this:
CASE WHEN valid_date(invdte,"*ymd")=1 THEN char(cvtdate(invdte,ymd1)) ELSE " " END
will return a blank if the date in not valid.
'*YMD' is only one of many formats supported by the Valid_Date function.
How can I end all ViewPoint jobs?
Run the Script VPCLEANUP in SEQUEL to immediately end all ViewPoint jobs.
Does ABSTRACT work with RPG II?
Yes. It can cross-reference program-to-file-to-field relationships. ABSTRACT does not analyze some of the source code unique to System/36 applications (such as procedures and OCL), so the list excludes program-to-program relations.
Does ABSTRACT work with ILE RPG?
Yes.
Does ABSTRACT handle program-described files (program-described input specs)?
Yes, ABSTRACT analyzes program-described files and fields.
How can I rename the old product library APLUS to the new product library ABSTRACT?
The easiest way is to rename the library (the ABSTRACT library cannot be on any library list). After you rename the library, the commands will not work because they will have the wrong product library. Run the ABSTRACT installation to update the product and fix the product library for all the commands.
What is “service data” and how does it affect ABSTRACT?
Every source-based object has information attached to it that tells you where the source is located for the compiled object. You can view service data using the operating system command DSPOBJD and specifying the DETAIL parameter as *SERVICE.
ABSTRACT needs an automated method of matching a program object with its source. So, ABSTRACT “looks” at the service data on the object and finds the corresponding source code. Sometimes, the service data is incorrect if the source code was moved after the object was compiled.
It is important to analyze your service data situation before doing any cross-reference loading in ABSTRACT. One of the best ways to analyze the data is to run the ABSTRACT Exceptions report for any program object libraries you intend to load. Anytime the source code cannot be located (the service data is pointing to an incorrect source file), the source file and member names are underlined in the report. See the ABSTRACT User Guide for more information.
Why does ABSTRACT include unwanted libraries in the WRKLIBX list after LOADXREF?
Unwanted libraries appear only if the HLL program service data points to the unwanted library. To find the references to these unwanted libraries, you can execute the LOADXREF command and specify to load all of the objects. Doing a load on all of the objects creates a job log that references the unwanted libraries with a DOC0098 message, as shown in the following example:
DOC0098 - Message . . . . : Processing source for TESTLIB/SRCFILE MBR(SRCMBR).
When I’m running a library through ABSTRACT containing programs, data, and source code, how do I make ABSTRACT examine just that library? It seems to want to pull in references to objects outside of the library.
Specify TYPE(*SRCF). The *SRCF parameter ignores external relationships with objects in other libraries.
How can users load their custom object relations into ABSTRACT cross-reference files?
Objects in APLUS are arranged in a parent-child relationship. If a menu calls a program, the menu object is the parent and the program is the child. These relationships are stored in a series of physical files in the APLUS library:
- Object relations with a sequence number (such as menu numbers, or source sequence numbers) are stored in OBJREF.
- Object relationships with no sequence number (such as program-file relationships from DSPPGMREF) are stored in PGMREF.
- An object does not need to have a record in both files in order to be included on any of the ABSTRACT list displays. Contact Tech Support for a document that contains specific details about how to populate the fields in these files.
- How can I load Robot/SCHEDULE information into the Cross Reference?
- Use the LOADJOBSCD command with the Product ID of *ROBOT.
How is iSeries Navigator related to ABSTRACT?
The IBM iSeries Navigator development team works closely with Help/Systems to ensure an integrated solution through their plug-in support. ABSTRACT is a perfect fit for the iSeries Navigator hierarchy, allowing you easily to track and manage the objects on your system.
Do I need Client Access to use iSeries Navigator and ABSTRACT?
If you are a current Client Access Express or iSeries Access for Windows user, iSeries Navigator is included with the software. Starting with V4R2, iSeries Navigator is free with the operating system. You can install it on your PC through the NetServer path for your System i. Even if you want to use the WDSc client, the Navigator client is required.
How can I disable Visio Flowcharting in the iNav plugin?
Edit the PC registry (Start>Run>Regedit). Go to HKEY_CURRENT_USER\Software\Advanced Systems Concepts\Abstract. Right-click on Abstract node and choose New>String Value. Name it “Flowchart” and change the value to “Builtin”.
I noticed a node called “iSeries Explorer” is installed. What is its purpose?
We included the iSeries Explorer because there was no efficient way in iSeries Navigator to obtain a real-time list of system libraries and objects. The alternative—to go into the IFS and get the list by opening QSYS.LIB—is very slow. With the iSeries Explorer, you can bring up libraries that are not loaded in the cross-reference and interact with them. A good example is the File Analysis function. You can use this function with any file, whether or not the file is loaded in the cross‑reference. The iSeries Explorer is also a handy way of loading libraries into the cross-reference. In WDSc, the Remote Systems Explorer eliminates the need for the iSeries Explorer node.
Need Help? Talk to Us |