| You'll need your User ID and case sensitive password that you received from the Innovation Challenge team
when you completed Part 1. If you did not receive your ID, or if you need it resent,
please contact us. Each team member receives a unique user ID so
that you can each gain the learning experience with System i. We only need one entry from one of the team members
to successfully complete this task for your team, per the instructions to follow – but take advantage of this opportunity
for each student to explore the environment. The first step is to access the system.
The object of this section of the Challenge is for you to sign on to our System i and perform a few tasks.
By following the instructions below, we will lead you through exactly what you need to do to complete this
section successfully. You'll see how easy it is to access the system and get some work done.
In this section of the Challenge, you will use Access for the Web to create a table, populate the table, and generate HTML and XML files from the table. You will also have the opportunity to explore more of the system through this web interface.
The first step is to access the system. The URL is http://rhea.sealinc.org:2052/webaccess/WAHome.
You will be prompted for your unique User ID and case sensitive password that you were provided earlier.
Your task is to create a table of information about vacation travelers. The table name should be TRAVELER and it should contain
the following fields:
- LastName – Char(30)
- FirstName – Char(30)
- Middle Initial – Char(1)
- Address1 – Char(50)
- Address2 – Char(50)
- City – Char(50)
- State/Province – Char(15)
- Country – Char(50)
- Postalcode – Char(10)
- email – Char(100)
- Phone – Char(13)
This table can be created with SQL. You will have to qualify the table name with your group ID, which is the name of your group's library. (Hint: Run SQL is an option under Database.)
The next step is to populate the table. While that can be done with SQL INSERT statements,
it might be easier to create a file containing the data and "Copy data to table".
For this exercise, the table should contain at least 4 entries.
After the table is populated, we want to generate a file that contains a report of the data in PDF format and a file that contains the data in XML. (Two hints: SQL is a good way to generate a report,
and the Integrated File System (IFS) is a good place to put this type of data.)
(Additional hint: Your team has a directory in IFS.)
The last step is to send those report files to the Innovation Challenge team. (One more hint: "Browse files" option.)
There are many other options available through Access for the Web, you might want to spend some
time exploring those options. There is even a "green screen" terminal interface for the truly adventurous.
|
