IBM Tivoli Web Access for Information Management

160 IBM Tivoli Web Access for Information Management

3. Using Web and Desktop tables, select only the fields that you want to see on the browser

by entering ATTACH in the table name field. Normally, the attachment name and

description will be enough, but you might want to include the attach date and time along

with the user ID of whoever attached the file. Attachment index is used internally and

never needs to be shown in the HTML. The Web Access code still accesses and updates

these fields, even though they are not included in the Desktop table or visible in the HTML.

4. Using Web and Desktop panel layouts, choose a Panel Name in which you want to

include the ATTACH table by entering the

F line command.

5. Select the ATTACH table by entering

S and position it within the other groups of fields.

Change the field description for the ATTACH table if desired. Blank out or change the

usage to

U for inquiry.

6. Finish your Desktop Panel Field List Entry and you are taken to the Desktop Table Field

Usage Definition panel. Change the field description if desired. Blank out the

create

usage

field. Attaching files is not possible in create mode. Set the

update

and

display

usage with

the desired values (

U, D, or R).

7. End the panel, file the data view record, and create the HTML using the Web

Administration page.

Other considerations

Attachments can only be viewed under Web Access. They cannot be viewed by the

traditional 3270 Information Management user and should not be included in report format

tables (RFTs).

Web Access adds the date, time, and user ID of the user attaching a file. If you would like this

information to appear in the journalized history data, you need to update data attributes

BLQ&DATA, BLQ&TIMA, and BLQ&AUSR and set “cognize data” to YES and “journalize” to

ORDER. These attributes are shipped with these settings turned off in order to avoid

generating large volumes of history data.

Do not include the data attributes for the freeform text s-words in your data view.

50

Including

those data attributes will impact performance, since the attachment text will be retrieved with

the rest of the data in the record when your data view is used. The Web Access code will

access the attachment freeform text using data view BLQATTCH when needed. The

exception to this rule is to include them when you want an attachment to appear in-line in the

HTML when displaying a record, as exemplified by showing a JPG or GIF image (such as a

person's picture) on the summary panel of the people record display. Attachment freeform

text data attribute BLQ&AT01 is included in the list of data attributes in BLQVPEOP so that

the image can be shown without the user executing a Get attachment.

General considerations

When defining tables in a data view, consider the following:

򐂰 ATTACH is a reserved table name and causes Web Access to do attachment-specific

processing of the list processor data.

򐂰 SAVESRCH is a reserved table name for saved search data. It causes Web Access to do

saved search-specific processing.

򐂰 S-words with special meaning in display-mode task HTML:

– S0EF7—The existence of this field in a task causes the Web Administration page to

add the code necessary to print.

50

See Table B-1 on page 158 for the data attribute names used to store attachments in freeform text.

Appendix B. Hints and tips 161

– S0ED1—The existence of this field in a task causes history (journal) data to be

formatted using Show_History?().

– S12DE or S12DF—Causes Show_Approvers?() to be added to the HTML.

– S0CBC—In a change record, causes Show_Childern?() to be added.

򐂰 S-words with special meaning in update/create-mode task HTML:

– S1152—Causes Select_With_My_Classes?() to be added.

– S0CD0—In an activity in create mode, causes the field to be changed to a hidden

<input> display-only field for the parent RNID. In update or display mode, it turns into

an active link to the parent.

162 IBM Tivoli Web Access for Information Management