iSeries Access for Web V5R2 and WebSphere Host Publisher V4.0

Chapter 3. Using iSeries Access for Web 35

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.

36 iSeries Access for Web V5R2 and WebSphere Host Publisher V4.0

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.