My Folder

My Folder contains items that have been placed in the current user’s personal folder. The current user or another user may have placed the items. You may access My Folder by typing the following URL:

http://systemname/webaccess/iWAMyFolder

My Folder may contain items with the following information:

Item description

Status

From

Date/Time

Size

A column labeled

Actions

lists the available actions for the items in the folder, which may include: Open Delete Rename Mail Mark Opened

In Figure 3-5, the My Folder icon on the left contains

unopened

items as indicated by the * character in the top right-hand corner of the folder. The My folder icon on the right contains all

opened

items.

Figure 3-5 My Folder with unopened items

Users may also be notified via e-mail when new folder items are placed in their personal folder. You configure this function by customizing My Folder. Figure 3-6 shows an example of configuring e-mail notification. You must also perform general Mail customization for this support to work. Refer to “Setting up Mail” on page 29.

Figure 3-6 My Folder e-mail notification

You can restrict My Folder by setting the My Folder policy to

Deny

for a user or group profile.

Placing output in multiple personal folders

iSeries Access for Web has the ability to specify the destination of output. You can specify to place this output in multiple personal folders. The following steps explain how to send a PDF file to multiple personal folders:

1. From the navigation bar, click Print-> Printer Output (see Figure 3-13 on page 31). 2. On the Printer Output page, select a spooled file and click PDF in the Action column. 3. On the PDF Output Settings page, locate the Destination field, click the drop-down list,

and select Personal folder.

4. Click Settings. Then you see the Personal Folder Settings page as shown in Figure 3-7.

5. Enter an item description.

6. Click Browse.... You may select individual users or groups. Press the Ctrl key to select multiple individual users or groups.

7. Click OK. The folder owner is updated with the selected folder owners. 8. On the Personal Folder Settings page, click OK.

9. On the PDF Output Settings page, click Run.

A message, similar to the example in Figure 3-8, appears indicating the output was converted and copied to the specified folders.

Figure 3-8 Convert Printer Output to PDF

3.2.2 Mail

Data and files can be sent to any e-mail address using iSeries Access for Web. E-mail can also be used to notify you when a command completes or an item is placed in your personal folder. The mail function is available from:

Print: “Mail as attachment” is the destination choice for the PDF action on a Printer Output

item. Use this option to mail a PDF representation of a spooled file to one or more e-mail addresses. When you run the PDF action, the browser window is not updated until the operation completes and the item is mailed.

Database: The “Mail as attachment” destination choice in Run SQL is used to send SQL

results to one or more e-mail addresses. “Mail as attachment” and “Personal folder” are good destination choices for long running SQL requests, since the request runs in the background and browser timeout errors are avoided. You can also configure saved SQL requests to prompt you for the e-mail addresses and message text every time the request is run.

Command: The “My email address” output option is used to send the command

completion message to your configured e-mail address. “My email address” and “My folder” are good output choices for long running commands, since the command runs in the background browser timeout errors are avoided. You can use “Submit Batch Job” with the “Browser” output option for long running requests. However, the completion message only contains information about submitting the job. It does not give any information about how the command completes. You should only use “Submit Batch Job” if you don't need the completion status or if you can verify the status some other way.

File: Browse Files and File Shares provide a Mail action for mailing files in the integrated

file system to one or more e-mail addresses. When you mail a file, the browser window is not updated until the file is sent.

My Folder: My Folder provides a Mail action for mailing a folder item to one or more e-mail

addresses. When you mail an item, the browser window is not updated until the item is

Note: There is no advantage to using “My email address” or “My folder” with “Submit

Batch Job”. These options already run the command in the background and the completion message from “Submit Batch Job” does not contain information about the completion status of the command.

sent. My folder also supports sending a notification message to an e-mail address whenever an item is placed your personal folder. You can configure this notification option using the Customization function.

You can submit a batch command and receive e-mail notification when it completes. You can access the e-mail via a PC, cell phone, or PDA. Administrators or users may also set the destination of a database request to

Mail as Attachment

. A report runs in the background, and when it completes, the e-mail with the report as an attachment is sent to the specified user.

Setting up Mail

The following steps explains how to configure mail:

1. From the navigation bar, select Customize-> User Profiles or Group Profiles (see Figure 3-33 on page 45). This depends on what you want to configure for mail. 2. Select Mail from the Category. The Customize - Mail page is displayed as shown in

Figure 3-9.

Figure 3-9 Customize: Mail

3. Enter your SMTP mail server and e-mail address under the Setting heading. For both the SMTP mail server and e-mail address, select Apply setting to profile under Action. See Figure 3-10. Then click OK.

Sending output using e-mail

iSeries Access for Web can send output to multiple destination types. The destinations include Browser, Personal Folder, and Mail as Attachment. Mail as Attachment is only available when the Mail Policy is configured. The following steps explain how to use personal folders and e-mail using SQL output:

1. Click Database-> Run SQL (see Figure 3-20 on page 36).

2. On the Run SQL page, create an SQL statement in the box (see Figure 3-26 on page 41). 3. Go to the SQL Output section.

4. Select a type of output. You can’t preview with Personal Folder and Mail as Attachment. You can see additional types by clicking the drop-down list.

5. For the Destination, select Mail as Attachment by clicking the drop-down list: a. Click Settings. Figure 3-11 shows the Mail as Attachment Settings.

b. Enter the information requested. You can specify multiple e-mail addresses by separating each address with a comma.

Figure 3-11 Mail as Attachment Settings

c. Click OK.

6. The Run SQL Request page (Figure 3-12) opens. A notification message is sent to your e-mail inbox along with your SQL output.

Figure 3-12 Run SQL Request

3.2.3 Print

iSeries Access for Web provides access to your printers and printer output. You can access the print functions via the Print tab as shown in Figure 3-13.

Figure 3-13 Print tab

Each Print function is explained as follows:

Printer output:

http://systemname/webaccess/iWASpool

– List, preview, and manage printer output on your iSeries server. – Hold, release, or cause a spooled file to be printed next. – View, mail, or send printer output in PDF format.

– Preview SCS and AFP printer output in GIF, TIFF, PCL, and AFP formats. – View AFP output with the AFP viewer plug-in.

Printers

http://systemname/webaccess/iWAPrinters

– List and manage printers on your iSeries server. – View printer and status information.

– Vary on and vary off the printer device.

– View and answer messages waiting on the writer job.

– List, preview, and manage printer output for a printer from the printer list.

– Manage the writer job associated with the printer using hold, release, start, and stop functions.

Internet printers

http://systemname/webaccess/iWAInternetPrinters – List Internet printers on your iSeries server.

– View configuration information and status from internet printer list.

– Access and manage printer output from the internet printer list and the iSeries printer defined by the Internet printer.

Printer shares

http://systemname/webaccess/iWAPrinterShares

– List printer shares, with printer share information and status, on your iSeries server. – Access and manage printer output from the printer share list.

Output queues

http://systemname/webaccess/iWAOutputQueues

– List, manage, and view the status of output queues on your iSeries server. – Hold and release an output queue from the output queue list.

– List, preview, and manage printer output in an output queue from the output queue list. You can customize Print functions or restrict them by using the Customize tab. For additional information on Print, see iSeries Access for Web, SC41-5518.

Printer output in PDF format

iSeries Access for Web supports two different ways to transform a spooled file to the PDF format:

IBM Infoprint Server (5722-IP1)

TIFF transform

IBM Infoprint Server is a separately purchased product that gives iSeries Access for Web users the ability to create full text PDF files that deliver document fidelity, while preserving the ability to navigate through the text of the document. If you have IBM Infoprint Server installed, iSeries Access for Web automatically detects and uses it. If you do not have IBM Infoprint Server installed, the individual pages of the spooled file are converted into images. These images become the pages of the output PDF document. You cannot edit or search for content in any of these pages.

Printer shares

iSeries Access for Web has the ability to view printer shares. For additional assistance on configuration and setup, refer to the iSeries Information Center at:

http://publib.boulder.ibm.com/pubs/html/as400/v5r1/ic2924/index.htm

Internet printers

iSeries Access for Web has the ability to view Internet printers. To learn more about configuring and setting up these printers, see Printer Device Programing, SC41-5713.

Mailing PDF files

iSeries Access for Web provides the ability to mail print output in PDF format. You must first configure the mail function for the iSeries Access for Web user or group profile as outlined here:

1. Follow the steps in “Setting up Mail” on page 29.

2. Select the Print-> Printer output link from the navigation bar.

3. Select PDF from the Action Column in the Printer Output page, and change Destination to

Mail as Attachment. Figure 3-14 shows the PDF Output Settings that are available if IBM

Figure 3-14 PDF Output Settings

Figure 3-14 also shows the “Restore original printer output” check box. The option is only available if IBM Infoprint Server is installed. This option controls if the spooled file stays on the system after the spooled file is transformed to PDF. When the transformation is performed by Infoprint Server, the spooled file is actually sent to a writer job. If this option is not enabled, the spooled file is treated like it was sent to a physical printer device. If IBM Infoprint Server is not installed, the Host Print Transform converts the spooled file pages. The spooled file will still be located in the output queue.

Click Settings.

4. Figure 3-15 shows the Mail as Attachment Settings. Enter the required information and click OK.

Figure 3-15 Mail as Attachment Settings

5. Back on the PDF Output Settings page, click Run. Figure 3-16 shows a message that indicates the mail was sent successfully.

Figure 3-16 Mail sent successfully

3.2.4 Messages

iSeries Access for Web give you access to your messages via the Messages tab. The navigation bar in Figure 3-17 shows the Messages tab and related functions.

Figure 3-17 Message tab

Each of the Message functions is explained here:

Display messages

http://systemname/webaccess/iWAMessages

– Display, answer, and manage messages in the message queue for the logged on user.

Send messages

http://systemname/webaccess/iWASendMessage

– Send a message to users and message queues.

Operator messages

http://systemname/webaccess/iWAMessages/QSYS/QSYSOPR

– Display, answer, and manage messages in the system operator message queue.

Message queues

http://systemname/webaccess/iWAMessageQueues – List message queues on the iSeries server.

– Select, display, and manage messages in message queues.

You can customize or restrict Message functions by using the Customize tab. For additional information on Messages, see iSeries Access for Web, SC41-5518.

3.2.5 Jobs

iSeries Access for Web allows you to access the iSeries jobs you submitted. You may also access jobs working on your behalf. Figure 3-18 shows Jobs tab from the navigation bar.

The Jobs functions include:

Jobs

http://systemname/webaccess/iWAJobList?jobtype=user – List and manage user jobs on your iSeries server. – View job logs for active jobs.

– View printer output for completed jobs.

Server jobs

http://systemname/webaccess/iWAJobList?jobtype=server – List and manage server jobs on your iSeries server. – View job logs for server jobs.

You can customize or restrict Job functions by using the Customize tab. For additional information on Jobs, see iSeries Access for Web, SC41-5518.

3.2.6 5250

iSeries Access for Web provides the ability to start an interactive session on the iSeries server. This function can be accessed via the 5250 tab. Figure 3-19 shows 5250 tab from the navigation bar.

Figure 3-19 5250 tab

For more information, see Chapter 4, “The iSeries Access for Web V5R2 5250 interface” on page 79. The 5250 tab includes the following functions:

Active sessions

http://systemname/webaccess/iWAActiveSessions – List active 5250 user interface sessions.

Configured sessions

http://systemname/webaccess/iWAConfiguredSessions – List configured 5250 user interface sessions.

Start session

http://systemname/webaccess/iWAStartSession – Start a 5250 user interface session.

3.2.7 Database

iSeries Access for Web provides access to database tables on the iSeries server. you can access this function via the Database tab. Figure 3-20 shows the Database tab and its related functions.

Figure 3-20 Database tab

The Database functions include:

Tables

http://systemname/webaccess/iWADbTables

– View a list of database tables on your iSeries server.

– Perform actions on these tables without knowledge of SQL and its syntax. – View the contents of a table in a paged list using the Quick view action. – Add and update records in a table using the Insert and Update actions.

– Create your own customized SQL request for a table using the Run SQL action. – Create your own customized copy data request for a table using the Copy data to table

action.

My requests

http://systemname/webaccess/iWADbRequests – View a list of previously saved requests. – Run or edit requests from this list.

– Manage lists using the Copy, Delete, and Rename actions – Create and manage shortcuts to requests.

Run SQL

http://systemname/webaccess/iWARunSQL

– E-mail and personal folder options are available as output destinations. – Run SQL statements dynamically.

– View output as a paged list or in a popular file format, like Microsoft Excel or Lotus 1-2-3. (The output format depends on how you have your browser configured and whether the browser can locate a plug-in for the output type you choose.)

– Customize how data is returned by setting options specific to the output type. – Build SELECT statements using an SQL wizard.

– Save requests for repeated use.

Copy data to table

http://systemname/webaccess/iWADbUpLoad

– Copy existing data files from your PC to a database table on your iSeries server. These data files can be in many popular file formats, including Microsoft Excel and Lotus 1-2-3.

– Replace the contents of a table or add data to an existing table.

– Create a new database table based on the contents of a workstation file. – Save requests for repeated use.

Import request

http://systemname/webaccess/iWADbImport

– Import Client Access Data Transfer upload and download requests into iSeries Access for Web copy data and SQL requests.

– Imported requests are automatically converted to iSeries Access for Web format. – Run and edit converted requests on your iSeries server just like other copy data and

SQL requests.

You can customize or restrict Database functions by using the Customize tab. For additional information on the Database functions, see iSeries Access for Web, SC41-5518.

Database management

iSeries Access for Web has the ability to manage database requests. Administrators may manage requests for a group of users, share requests, and restrict access. Figure 3-21 shows an example of My Requests. You can perform several actions on a request, including:

Run Copy Delete Rename Create shortcut Edit

Administrators can restrict access to request actions using customized policies. The Access column lists who has access to the request or shortcut. For requests, this value is always the user profile used to create the request. For shortcuts, the user creating the shortcut chooses who has access to the shortcut. One or more user profiles or group profiles can be chosen. A special value of *PUBLIC indicates all users have access to the shortcut.

The following scenario shows how an administrator can use a combination of customization and shortcuts to manage database request access:

1. Use policies to allow the database administrator access to all database request actions. 2. Use policies to deny users, in the *PUBLIC group, access to all database request actions

other than “Run”.

3. Create the following three database requests: – “Past due accounts”

– “Low inventory” – “New orders”

4. Create the following three shortcuts:

– To “Past due accounts” and give access to the ACCOUNTING group. – To “Low inventory” and give access to the PURCHASING group. – To “New orders” and give access to the SHIPPING group.

In this example, only the database administrator is allowed to create and modify requests. Other users are only allowed to run requests. The requests a user is allowed to run are limited to the requests the administrator decides the user should be able to access.

Database connections

The following sections show you how to define the database connection using the Native JDBC Driver and the Toolbox JDBC Driver.

Using the Native JDBC Driver

iSeries Access for Web contains the ability to use the Native JDBC Driver in place of the predefined Toolbox Driver. The following steps describe this process:

1. From the iSeries Access for Web Main page, click Customize-> User profiles or Group

profiles (see Figure 3-33 on page 45).

2. Click Edit from the Action column for the user profile or group profile you want to edit.

In document iseries Access for Web V5R2 and WebSphere Host Publisher V4.0 (Page 40-61)