IBM CD Showcase/OS2_CD_ROM.iso/smce0001/wplace/prod/help/wphelpe.hlp

OS/2 Help File | 1993-06-12 | 81.1 KB | 3,063 lines

ΓòÉΓòÉΓòÉ 1. Ultimedia Workplace/2 Notices ΓòÉΓòÉΓòÉ

References in this help to IBM products, programs, or services do not imply
that IBM intends to make these available in all countries in which IBM
operates.

Any reference to an IBM licensed program in this help is not intended to state
or imply that only IBM's licensed program may be used.  Any functionally
equivalent product, program, or service that does not infringe on IBM's
intellectual property rights may be used instead of the IBM product, program,
or service.

Evaluation and verification of operation in conjunction with other products,
except those expressly designated by IBM, is the user's responsibility.

IBM may have patents or pending patent applications covering subject matter in
this help.  The furnishing of this help does not give you any license to these
patents.

Trademarks.

The following terms are trademarks or registered trademarks of the IBM
Corporation in the United States and/or other countries:

Audio Visual Connection (AVC)
DATABASE 2
DB2/2
IBM
OS/2
Storyboard
Ultimedia

The following terms are trademarks or registered trademarks of other companies.

dBASE    Borland International

DVI      Intel Corporation

Oracle   Oracle Corporation

TARGA    Truevision, Inc.

Windows  Microsoft Corporation


ΓòÉΓòÉΓòÉ 2. Glossary ΓòÉΓòÉΓòÉ

Double-click on a term for its definition.

bitmap
bounding box
browser
clipboard
Clipdata
column
database
Desktop
extended attributes
extended data
field
field value
file
file extension
file name
file type
folder
frame
join
key
Light Table folder
Lt Query object
LT Query Result object
LT Query Sequencer folder
LT Reference object
media field
object
path
pop-up menu
query
row
Safe
schema
standard data
table
thumbnail
title


ΓòÉΓòÉΓòÉ 3. Workplace/2 Help ΓòÉΓòÉΓòÉ

To help you efficiently organize and manage your multimedia (image, audio,
video, story, and text) files, the Ultimedia Workplace/2 application provides
extensions to the OS/2 Desktop, and programs to use them. Special features
include:

o Miniature picture views (thumbnails) of multimedia file contents making it
  easier to identify, organize, and select multimedia files.

o Media browsers to display or play a multimedia file.

o LT Reference objects allowing access to objects in different locations
  (saving disk space) and allowing you to manage multimedia files offline.

o Light Table folders for organizing multimedia objects, and through which
  objects get their thumbnails.  Light Table folders also provide a way of
  storing and viewing text information about the multimedia objects it
  contains, via extended data.

o Extended data:

   - The ability to add descriptive information to multimedia objects in a
     Light Table folder, and to make queries on that information.
   - The ability to join multimedia objects to existing information in
     databases, and to make queries on that information.

o The Clipdata object through which you can copy and paste image data using the
  OS/2 or Windows system clipboard.

o The Safe folder is used for backing up and recovering files.

Related information:

o Getting Started
o Light Table Folder Help
o Multimedia objects
o Query Editor
o Query Result Viewer
o Safe Help
o Clipdata Help
o Ultimedia Workplace/2 Notices


ΓòÉΓòÉΓòÉ 4. Getting Started ΓòÉΓòÉΓòÉ

The heart of Ultimedia Workplace/2 is the Light Table folder, a folder with
special properties for managing multimedia files.

Create Light Table folders for managing your multimedia objects

o Use the Light Table folder template to create your Light Table folders and
  name them.

o Drag your multimedia objects into the folders.

o Double-click on their thumbnail frames to run their browsers to view their
  contents or listen to them.

Set up your multimedia file information system.

o Open each Light Table folder's settings notebook to define in its schema what
  kind of information you want to keep about the objects in the folder.
  Consider what information you want to:

   - create and maintain for the objects, and store in their extended
     attributes.
   - Use from related databases.

o Use a folder's details view to enter, display, or change the information you
  are maintaining in their extended attributes.

Use the multimedia file information you have.

Create queries to look up information you have about your multimedia files.

o Use the LT Query Sequencer template to create LT Query Sequencer folders to
  manage your queries.

o If desired, use the LT Query template to place additional LT Query objects
  into the LT Query Sequencer folder.

o Use the Query Editor to specify your query information and instructions into
  the LT Query objects you place into LT Query Sequencer folders.

o If desired, use the LT Query Result template to place additional LT Query
  Result objects into the LT Sequencer folder where you want to capture the
  results of your queries.

o Run queries from the LT Query Sequencer folders.

o Use the Query Result Viewer to browse the results of your queries.

Use the Query Result Viewer to directly view and modify your databases.

Use the Safe folder to simplify backup and recovery.

o Use the Safe folder's settings notebook to define the backup drive.

o Drag and drop files and folders to be backed up onto the Safe folder.

o Use Safe to run the backup program.

o You can also use Safe to restore objects it previously backed up.

Use the Clipdata object to pass image files through the Windows and OS/2
clipboards.

o Use the Clipdata template to create Clipdata objects to pass image files
  through the system clipboard.

o Use the Clipdata template to create Clipdata objects to convert image files
  to the common bitmap format.

Help is available for all Workplace/2 objects, menu choices, and windows.  For
an explanation of how to get Help, select Using Help from the Help menu.

Related information:

o Creating Light Table folders
o Defining Light Table folder schema
o Using Light Table folder schema to manage multimedia files
o Multimedia objects
o Creating queries against Light Table folders
o Creating multiple step queries
o Query Result Viewer
o Using Safe to back up files
o Using Safe to restore files
o Clipdata Help


ΓòÉΓòÉΓòÉ 5. Multimedia objects ΓòÉΓòÉΓòÉ

Ultimedia Workplace/2 provides support for a special type of data object,
multimedia objects. You can have multimedia objects for audio, image, video,
story, or text files.  Ultimedia Workplace/2 determines an object's file type
by looking at its file's extension when it is placed in a Light Table folder.
If Workplace/2 does not recognize the file extension it assumes the object
represents a text file.

Based on a multimedia object's file type, Workplace/2 associates a browser with
its thumbnail so you can view or listen to it by double-clicking on the
thumbnail's frame. The thumbnail pictorially shows the type of media, and if it
is an image file it shows the actual image within the thumbnail's frame.
Workplace/2 displays the object's thumbnail in the Light Table folder's Icon
View.

Each multimedia object can have additional information associated to it through
its extended data.  You can see an object's extended data through its Light
Table folder's details view.

These special characteristics of multimedia objects are only enabled through
Light Table folders.

Related information:

o Multimedia file extended data
o Thumbnails
o Media Browsers
o Table of multimedia file types and extensions


ΓòÉΓòÉΓòÉ 5.1. Thumbnails ΓòÉΓòÉΓòÉ

Ultimedia Workplace/2 creates and stores special icons, called thumbnails, for
each multimedia object stored in a Light Table folder.

Thumbnails make it easier to identify, organize, and select multimedia data.
They pictorially represent multimedia files; they are surrounded by frames
resembling slide frames.  You can see thumbnails in a Light Table folder's icon
view, and its details view.

Image thumbnails are actual miniaturized pictures of the file's contents.
Audio, video, story, and text file thumbnails show what media a file is by
displaying a special graphic for each type.  The system decides what media type
a file is based on its file extension.

See the Table of multimedia file types and extensions to see what file
extensions Workplace/2 automatically interprets as specific media types.  When
the system does not recognize a file extension it assumes the file is a text
file.

If a thumbnail graphic is incorrect you should change the object's file type on
the Type tab of its settings notebook.

Related information:

Table of multimedia file types, and extensions


ΓòÉΓòÉΓòÉ 5.2. Table of Multimedia File Types and Extensions ΓòÉΓòÉΓòÉ

Ultimedia Workplace/2 determines what a multimedia object's file type is by its
file's extension.  The file type also determines a file's thumbnail icon and
its browser.

The table below displays, by file type, the associated extensions.


 File Type  File         Format
            Extension

 LT Audio   ._AD, ._AU   AVC

            .WAV         Wave

            .MID         MIDI

 LT Image   ._IM, ._ID   Ultimedia
                         Builder/2

            ._IM, .!IM   AVC

            .BMP         Bitmap

            .ICO         Icon

            .PCX         PCX

            .TGA         Targa

            .TIF         TIFF

            .DIB         DIB

 LT Story   ._ST         Ultimedia
                         Builder/2

            ._ST, .!ST   AVC

 LT Text    .TXT         ASCII text

            .C

            .DOC

            .H

 LT Video   .AVS, .DVI   DVI

            .AVI         Ultimedia
                         Video


ΓòÉΓòÉΓòÉ 5.3. Multimedia Object Extended Data ΓòÉΓòÉΓòÉ

Through a Light Table folder's schema you can define information you want for
the objects stored in the folder.  Called extended data, this information is
stored in each object's extended attributes, in a database, or both.

o In OS/2, every object has a reserved area for information called extended
  attributes.  It is this area that Ultimedia Workplace/2 uses to store some or
  all of a multimedia object's extended data.

o Ultimedia Workplace/2 also provides access to databases.

o A Light Table folder's schema defines the characteristics of the data in its
  extended attributes.  If a Light Table folder is joined to a database, its
  schema includes information about the database and how it is related to the
  Light Table folder.

o You can view, enter, or modify extended data through a Light Table folder's
  details view.

Database terminology is associated with extended data:  the term column or
field refers to a unit of information, and row or record can refer to the
collection of fields related to one item. A database file can be called a
database or a table.

Related information:

o Using Light Table Folder Schema to Manage Multimedia Files
o Editing Extended Data
o Displaying Extended Data


ΓòÉΓòÉΓòÉ <hidden> Create LT Reference ΓòÉΓòÉΓòÉ

Use the Create LT Reference option to create a new multimedia object that
represents another multimedia object.

To create an LT Reference of a multimedia object:

 1. Display the pop-up menu for the multimedia object.

 2. Select Create LT reference  A notebook is displayed.

 3. Use a notebook tab to select the target location for your LT Reference
    object.

 4. Use the OK push button to create the LT Reference.

Related information.

LT Reference Help


ΓòÉΓòÉΓòÉ <hidden> Opened ΓòÉΓòÉΓòÉ

You can use the Opened tab to select objects that are currently open.

 1. Make a selection.
 2. Click on the OK push button.

Use the Cancel push button if you decide not to change the current settings. .*


ΓòÉΓòÉΓòÉ <hidden> Related ΓòÉΓòÉΓòÉ

You can use the Related tab to select related objects (near the current tree
position.)

 1. Make a selection.  (Expand or collapse the view by selecting the plus or
    minus sign next to a folder; then select the folder object you want.)

 2. Select the OK button.

Use the Cancel button if you decide not to change the current settings. .*


ΓòÉΓòÉΓòÉ <hidden> Desktop ΓòÉΓòÉΓòÉ

You can use the Desktop tab to select an object on the Desktop.

 1. Make a selection.  (Expand the collapsed view of the contents of a folder
    by selecting the plus sign next to the folder; then select the folder
    object you want.)

 2. Select the OK button.

Use the Cancel button if you decide not to change the current settings. .*


ΓòÉΓòÉΓòÉ <hidden> Drives ΓòÉΓòÉΓòÉ

You can use the Drives tab to select an object or place an object in a
particular drive, or in a folder on a drive object.

 1. Select a drive icon, or expand the collapsed view of the contents of the
    drive by selecting the plus sign next to the drive object; then select the
    folder you want.

 2. Select the OK button.

Use the Cancel button if you decide not to change the current settings.


ΓòÉΓòÉΓòÉ <hidden> Path ΓòÉΓòÉΓòÉ

You can use the Path tab to provide the full path name of a particular drive
and directory.

 1. Type the full path name.

 2. Select the OK button.

Use the Cancel button if you decide not to change the current settings.


ΓòÉΓòÉΓòÉ <hidden> Create Object(s) ΓòÉΓòÉΓòÉ

This window may appear when you are creating objects. Initially the Create
button is already depressed because the objects are being created.

The Object field lists the target locations for the objects you are creating.
Use the Pause push button to pause the create process before the next object is
created. Use Resume to continue the create process.

Note:  If you do not want to create all of the remaining objects, you can use
Pause, then deselect those that you do not want to create, and then use Resume
to continue.

Use the Cancel button to stop the create process.


ΓòÉΓòÉΓòÉ 6. LT Reference Help ΓòÉΓòÉΓòÉ

An LT Reference object allows you to store a file in one location and access it
from another location.  If you make a change to the file, its LT Reference
reflects that change.  For multimedia files:

o An LT Reference retains its original object's thumbnail.

o An LT Reference retains its original object's multimedia file type.

o An LT Reference placed on removable media such as diskette can re-establish
  the link to its source when it is brought online.

o An LT Reference on hard disk can re-establish its link to its offline source
  file when the source is brought online.

o An LT Reference has extended data which conforms to the schema of its Light
  Table folder, retaining what information it can from its original file.

  For example, if a multimedia object sits in folder A and its LT Reference is
  placed in folder B which has different schema, the LT Reference's extended
  data fits the schema definition for folder B.  If folder B's schema has any
  columns with the same name as folder A's schema, the extended data values for
  those columns are transferred to the extended data for the LT Reference.  You
  can enter additional data to the LT Reference's extended data through its
  folder's details view.

Use of LT References saves disk space while providing flexibility.  You can
organize your multimedia files, referring to them in different ways, while
storing each file in just one place.

Related information

o Create LT Reference


ΓòÉΓòÉΓòÉ <hidden> Settings notebook - Reference Tab ΓòÉΓòÉΓòÉ

Use the Reference tab to view information about the LT Reference's source
object and to add descriptive text about it.

o Type a description of the source object in the Subject field.

o View in the Physical Name and Physical Info fields the original file object's
  physical path and file name, and information about what disk it is on.

You can use the Undo button to undo any changes you type in the Subject field.

For a detailed explanation of each field, select from the list below:

o Subject
o Physical Name fields
o Physical Info fields


ΓòÉΓòÉΓòÉ <hidden> Subject ΓòÉΓòÉΓòÉ

Type a brief summary about the contents of the source object in the Subject
field.  You can type as many as 40 characters.


ΓòÉΓòÉΓòÉ <hidden> Physical Name fields ΓòÉΓòÉΓòÉ

The Physical Name box shows where the source object is located.  The drive,
path and file name of the source object are shown in the Path and Name fields.

For example, assume this LT Reference was created from a file named DAWN._IM
which was in a folder (directory) named MORNING, on the Desktop (in the DESKTOP
directory on drive C.)  That information was placed in the Physical name box
as:

Path: C:\DESKTOP\MORNING
Name: DAWN._IM


ΓòÉΓòÉΓòÉ <hidden> Physical Info ΓòÉΓòÉΓòÉ

The Physical Info box shows information about where the source object is
located.

The physical disk's name is shown in the Volume ID field, its serial number in
the Serial Number field if that is appropriate, and the Server Id if that is
appropriate.


ΓòÉΓòÉΓòÉ <hidden> Reference ΓòÉΓòÉΓòÉ

Use the Reference menu item to find the original object from which this LT
Reference was created.


ΓòÉΓòÉΓòÉ <hidden> Reference - Locate ΓòÉΓòÉΓòÉ

Use the Locate menu item to find the original object from which this LT
Reference was created.


ΓòÉΓòÉΓòÉ 7. Light Table Folder Help ΓòÉΓòÉΓòÉ

The Light Table folder is designed to hold multimedia objects such as image
files, video files, audio files, story files, and text files.

A Light Table folder has all the same characteristics as a regular folder; for
example, it can be opened, moved, copied and rearranged.  In addition it has
special characteristics to help you organize your multimedia-related objects:

o A special kind of icon called a thumbnail which displays its multimedia
  object graphically and associates it with a browser enabling you to view or
  listen to it.

o Database capabilities:

   - A way to define descriptive information fields for the multimedia objects
     it contains.
   - A way to view these fields, and to enter, change, or delete their values.

o Media Fields:  a type of field pointing to a multimedia object in the same or
  another folder.  When you view a Light Table's information fields you can
  also see the thumbnail images other files it refers to.

For further information select topics from the list below.

o Creating Light Table folders
o Using Light Table folder schema to manage multimedia files
o Thumbnails
o Media Browsers
o Multimedia object extended data
o Media Fields


ΓòÉΓòÉΓòÉ 7.1. Creating Light Table folders ΓòÉΓòÉΓòÉ

Create Light Table folders when you want to group together multimedia files
with something in common, or when you want to group together objects related to
a multimedia task.  For example, you might create a Light Table folder to hold
all of the multimedia objects used for a particular presentation.

To create a Light Table folder:

 1. Open the Templates folder.

 2. Move the mouse pointer over the Light Table template.

 3. Hold mouse button 2 and drag the template to the Desktop or any other
    folder.

 4. Release mouse button 2.

After creating a Light Table folder you should define its schema through the
Schema Tab of the Light Table folder's settings notebook.

Related information:

o Using Light Table folder Schema to manage multimedia files


ΓòÉΓòÉΓòÉ <hidden> Schema Tab - Page 1 ΓòÉΓòÉΓòÉ

Use Schema Tab, page 1 to define the location for the extended data for the
objects contained in this Light Table folder and to define the characteristics
of that data.

Light Table schema definitions are like field definitions for a file, or column
definitions for a database table.  The Light Table folder's Settings notebook,
Schema Tab, page 1, provides access to the schema definitions.

o Use the Extended Attributes field and EA Edit button to invoke the Schema
  Editor with which you can add, modify, or delete schema column definitions
  for data to be stored in each file's extended attributes.

o Use the fields in Database and the DB Edit button to indicate the type of
  database, and to invoke the Schema Editor to review schema column definitions
  associated with the database you are linking to the Light Table folder.  You
  may be able to modify the database schema from this program.

o Use the Save button to validate any changes made to the extended attributes
  or the database schema, and to save them.

o Use the Undo button to change the settings back to how they were before you
  opened schema tab, page 1.

Related information:

o Defining Light Table folder Schema
o Multimedia Object Extended Data


ΓòÉΓòÉΓòÉ <hidden> dBASE format - Open ΓòÉΓòÉΓòÉ

Through this window you identify the dBASE format database you want to access.

To open a dBASE format file:

 1. Select the arrow to the right of the Drive list to display all the drives
    on your system.
 2. Select a drive from the Drive list.
 3. Select a directory from the Directory list.
 4. Select a file name from the File list or type in a file name.
 5. Select the OK push button to display the file.

For a detailed explanation of each field, select from the list below:

o Open filename
o Type of file
o Drive
o File
o Directory
o OK button
o Cancel button


ΓòÉΓòÉΓòÉ <hidden> Oracle, DB2/2, or OS/2 Database - Open ΓòÉΓòÉΓòÉ

To display a folder's schema coming from a database, fill out the requested
information in this window, then select the OK button.

For a detailed explanation of each field, select from the list below:

o Database Name
o Table Name
o Userid
o Password
o Server
o OK button
o Cancel button


ΓòÉΓòÉΓòÉ <hidden> Schema Editor ΓòÉΓòÉΓòÉ

Use the Schema Editor window to identify where to add a schema field, or to
select a schema field you want to modify, or delete.

To add a field:

o If no fields yet exist, select the Add button.
o If fields already exist, select the item after which you want to add the new
  field, then select the Add button.
o Type in the requested information and select the Apply button.

To modify a field:

 1. Select the field you want to modify
 2. Select the Modify button.
 3. Change the information as necessary.

Repeat these steps for each field you want to modify.

To delete a field:

 1. Select the field you want to delete
 2. Select the Delete button.

Repeat these steps for each field you want to delete.

After all changes are made, select the OK button to return to the settings
notebook, Schema Tab, page 1.

Related information.

Schema Editor - Add/Modify Dialog


ΓòÉΓòÉΓòÉ <hidden> Schema Editor - Add/Modify Dialog ΓòÉΓòÉΓòÉ

To define schema fields and their attributes:

 1. Type the field name in the Name field.

    A field name must start with a letter.  The maximum length of a field name
    for fields stored in extended attributes is 10 characters.  Database field
    name limits follow the rules of the specific database manager.

 2. Select the field type. Click on the down arrow at the right of the Type
    field to list the available choices and click on the appropriate choice.

 3. Type the field's Size as the maximum number of characters a value needs.

    For fields stored in extended attributes, the maximum length of a character
    field is 256 characters.  The maximum length for a numberic field is 20
    characters.

    For database fields, the size limits follow the rules of the specific
    database manager.

 4. Specify if the field is a Media Field.

    Single-click on the arrow to the right of the field to list the choices.

   o If the field should not display a thumbnail in the details view, select
     No.

   o If the field contains the title of a multimedia object within the Light
     Table folder and you want to display the object's thumbnail in the details
     view, select Object Name

   o If the field contains the filename of an object and you want to display
     its thumbnail in the details view, select Filename.

 5. Use the Apply button to save the definition.

You can use the Cancel button to cancel the definition and return to the Schema
Editor window.

Related information:

Media Fields


ΓòÉΓòÉΓòÉ <hidden> Schema Tab - Page 2 ΓòÉΓòÉΓòÉ

Use Schema Tab, page 2 to select which conversion rules apply when you move or
copy a multimedia object from one Light Table folder to another, or when you
create an LT Reference in another Light Table folder. When appropriate, the
object's extended data also transfers to the new location.

Extended data in a column transfers without conversion if:

o The column's field name is the same in both folders.
o The column's field type is the same in both folders.
o The field size in the target folder is not smaller than the field size in the
  source folder.
o If from a database, the database type for the columns in both folders is the
  same.

If the field names are the same, but the type or size are different, the value
may be converted.  If the names are not the same, no value is transferred.

To select the conversion rules that apply to this Light Table folder:

o Click on each rule you want to apply to all fields that are converted.
  Conversion rules include:

   Convert Character to Numeric
       Numeric text characters convert to a numeric field.
       (If this option is not selected, by default no data transfers.)

   Convert Numeric to Character
       The numeric value of the field converts to characters.
       (If this option is not selected, by default no data transfers.)

   Convert Numeric to Numeric
       If the target field is large enough, numeric data in one form (e.g.
       decimal) is converted to another form (e.g. binary).
       (If this option is not selected, by default  numeric data transfers only
       if the schema definitions in the source and target folders is the same.)

   Truncate
       For character fields where the source field length is longer than the
       target field length, the characters transfer, left to right, until the
       target field is full.
       (If  Truncate is not selected, by default the target field is left blank
       (no data transfers)).

  Note:  If no rules are selected, no conversion is done.  Data transfers
  between fields only if the fields' schema definitions are the same.

o Select the Undo button to change the settings back to what was defined before
  you opened schema tab, page 1.

o Select the Default button to change the settings back to a default of NO
  CONVERSION.  Data transfers from one Light Table folder to another only if
  the fields' schema definitions are the same.


ΓòÉΓòÉΓòÉ 8. Using Light Table Folder Schema To Manage Multimedia Files ΓòÉΓòÉΓòÉ

Light Table folders let you to keep textual information about the objects
stored in it.

You define the characteristics of this information in a Light Table folder's
schema which you access though the Schema tab of its settings notebook. The
schema describes the field characteristics of data that is attached to the
multimedia objects in their extended attributes, or of data that is stored in
an existing database, or data in both places.

To link to a database, a Light Table folder's schema defines a join field.  The
join field is a database column whose values match the titles of the Light
Table folder's objects, the objects' filenames, or the contents of a column in
the Light Table folder's files' extended attributes.

The supported databases include:

o OS/2 Database Manager
o DATABASE 2 OS/2 (DB2/2)
o Oracle
o databases using dBASE format files

To prepare a Light Table folder's information:

 1. Define its schema through the Schema tab of its settings notebook.
 2. Store the multimedia objects in the Light Table folder.
 3. Use the Light Table folder's details view to enter each multimedia object's
    extended data.

Related information.

o Defining Light Table folder Schema
o Displaying extended data
o Editing extended data
o Multimedia extended data


ΓòÉΓòÉΓòÉ 8.1. Defining Light Table Folder Schema ΓòÉΓòÉΓòÉ

A Light Table folder's schema describes the characteristics of the information
you want to keep for the multimedia objects stored in the folder. You either
store this information for each object in its extended attributes, or you link
to the information in an external database, or you use information in both
locations.

To define a Light Table folder's schema:

 1. Click mouse button 2 on the Light Table folder.

 2. Click on the arrow to the right of Open on the folder's pop-up menu.

 3. Select Settings from the menu.

 4. Select the Schema tab of the settings notebook.

   o To define the information you want to store in the files' extended
     attributes:

       a. Click on the down arrow to the right of the Extended Attributes field
          and select Extended Attributes.
       b. Click on EA Edit.  The Schema Editor window appears.
       c. Add, change, or delete fields as described in Schema Editor and
          Schema Editor - Add/Modify Dialog.

   o To use information from a database:

       a. Click on the down arrow to the right of the Database field and select
          the type of database you want to associate with the folder's files.
       b. Click on DB Edit
       c. Fill out the information needed to access the desired database.

          The database fields display in the Schema Editor window.  If you have
          the authority from the database to make changes, any changes you make
          are made to the database itself.
       d. Return to Schema page 1 by double-clicking on the window's title bar
          icon.
       e. To identify the Light Table folder field which contains the data
          which matches values in a column in the database, click on the down
          arrow to the right of the Folder Join Field and select the
          appropriate field name.
       f. To identify the database column which contains the data that matches
          the Light Table folder join field, click on the down arrow to the
          right of the Database Join Field and select the appropriate field
          name.
       g. Click on the Save button to save your schema choices.

Related information:

o Displaying extended data
o Editing extended data


ΓòÉΓòÉΓòÉ 8.2. Media Fields ΓòÉΓòÉΓòÉ

A Media Field is a type of data field in an object's extended data that
displays a thumbnail of a related multimedia object instead of text. For
example, a Light Table folder containing pictures of your company's employees
can show in its details view the pictures of the employees' managers.

You define a field as a media field when you define a Light Table folder's
schema.  As you define each field you have the option to say it is a media
field.

To be a media field, the value of the field must point to the file name or
object title of a multimedia object. In the example above, each row in the
Light Table would include a media field which specifies the title of the
manager's multimedia object.

Related information:

o Using Light Table folder schema to manage multimedia files
o Defining Light Table folder schema


ΓòÉΓòÉΓòÉ 8.3. Displaying Extended Data ΓòÉΓòÉΓòÉ

To display a Light Table folder's extended data:

 1. Click on the title bar icon of the Light Table folder.

 2. Click on the arrow to the right of Open.

 3. Select Details View.

    A window opens which by default displays the standard data and extended
    data associated with the objects in the Light Table folder.

 4. To see the extended data, scroll to the right.

Related information:

o Changing which information details view displays
o Editing extended data


ΓòÉΓòÉΓòÉ 8.4. Editing Extended Data ΓòÉΓòÉΓòÉ

Depending on your schema definitions, you can enter or change the following
types of data displayed in a Light Table folder's details view:

o The Title field of the OS/2 standard data
o Any extended data stored in the extended attributes
o Any extended data stored in the joined database, if you have write access to
  the database.

To edit an object's extended data:

 1. Click on the title bar icon of the object's Light Table folder.

 2. Click on the arrow to the right of Open.

 3. Select Details View.

 4. Use the scroll bars to display the extended data column and row you want to
    edit.

 5. Move the mouse pointer over the field you want to edit and press Alt and
    mouse button 1 together.

 6. Type the new information.

 7. Move the mouse pointer away from the field you just typed, and press mouse
    button 1.  The field is updated.


ΓòÉΓòÉΓòÉ 8.5. Changing Which Information the Details View Displays ΓòÉΓòÉΓòÉ

By default a Light Table folder's details view displays all of the data
associated with the its objects:

o Standard data
o Extended data stored in extended attributes
o Extended data stored in the joined database

To change which information the details view displays:

 1. Click on the Light Table folder's title bar icon.

 2. Click on the arrow to the right of Open.

 3. Select Settings.

 4. Select the View tab.

 5. Select page 3 of the View tab (click twice on the page-right arrow.)

 6. To select or deselect fields, click on field names listed under Details to
    display.  (Selected fields show in reverse highlighting on this page.  The
    selected fields are the fields that display in the details view.)

 7. When finished, double-click on the notebook's title bar icon to close the
    notebook.


ΓòÉΓòÉΓòÉ 9. Creating Queries against Light Table Folders ΓòÉΓòÉΓòÉ

Using Structured Query Language (SQL) queries you can quickly search through a
Light Table folder to find specific multimedia files based on information you
have stored in the files' extended data.

Ultimedia Workplace/2 provides three query tools in the Templates folder for
constructing queries.

o Use the LT Query Sequencer template to create an LT Query Sequencer folder.
  Use this folder to store the LT Query objects that contain your query
  instructions; use it to run your query, and to store the results of your
  query in LT Query Result objects.

o Use the LT Query template to create the LT Query object which you store in an
  LT Query Sequencer folder.  You put your query instructions in this object.

o Use the LT Query Result template to create an LT Query Result object where
  the query program stores the results of your query.

Steps to create and run a simple query against a Light Table folder

 1. Create an LT Query Sequencer folder.

 2. Open the LT Query Sequencer folder.  For convenience it already contains an
    empty LT Query object and an empty LT Query Result object.

 3. Start the Query Editor by opening the LT Query object

    a. Select Light Table folder as the type of query
    b. Select the folder you want to query
    c. Type in your SQL statement.
    d. Click on the OK button to close the Query Editor.

 4. Click on the title bar icon of the LT Query Sequencer folder to display its
    menu.

 5. Select the Run Query menu option. When finished, the query's results are
    stored in the LT Query Result object which opens automatically for your
    viewing.

For information on more sophisticated queries joining Light Table folders and
database files in multiple steps, see the Query chapter in the Ultimedia
Workplace/2 User's Guide.

Related topics

o LT Query Sequencer Help
o LT Query File Help
o LT Query Result File Help
o Query Result Viewer Help
o A brief review of SQL
o Creating Multiple Step Queries


ΓòÉΓòÉΓòÉ 10. Creating Multiple Step Queries ΓòÉΓòÉΓòÉ

You can create sophisticated queries joining together Light Tables folders and
database files.  You query each Light Table folder or database in a separate
step.  There must be a Light Table folder schema column or database field in
each succeeding step that can be matched to a Light Table folder schema column
or database field in the previous step.

To create and run a multiple step query:

 1. Create an LT Query Sequencer folder.

 2. Open the LT Query Sequencer folder.  It contains an empty LT Query object
    and an empty LT Query Result object.  You can use this LT Query object for
    the first step of the query.

 3. Use the LT Query template to put an additional LT Query object in this
    folder for each additional step.

 4. Start the Query Editor by opening the first LT Query object.

    a. Select Light Table folder or the type of database to be queried in this
       step.
    b. Select the folder or database you want to query in this step. If this
       step queries a database, supply the additional requested information.
    c. Type in your SQL statement(s).
    d. Type the Join Fields that link to the Previous and/or Next queries in
       the sequence.
    e. Close the Query Editor.

    Repeat this procedure for each step in the query.

 5. Click on the title bar icon of the LT Query Sequencer folder to display its
    menu.

 6. Select the Run Query menu option. When finished, the query's results are
    stored in the LT Query Result object which opens automatically for your
    viewing.

Notes:

o You can place an LT Query Sequencer folder in place of an LT Query object for
  any step in the query.  Only one level of nesting is supported.

o You can insert an LT Query Result object between any of the query steps.
  After you run the query each LT Query Result object contains the results of
  the query to that point in the sequence.

Related information:

o Creating Queries against Light Table Folders
o SQL Statements
o Join Fields
o A Brief Review of SQL


ΓòÉΓòÉΓòÉ 11. LT Query Sequencer Help ΓòÉΓòÉΓòÉ

The LT Query Sequencer folder provides a staging area for building the
components of a Light Table folder or database query. It also provides the
means for validating the query information, and for running the query.

The LT Query Sequencer can contain three types of objects:

o LT Query files which contain the query instructions.
o LT Query Result files which contain the results of a query in database form.
o other LT Query Sequencer folders.  Only one level of nesting is allowed.

To create an LT Query Sequencer folder:

 1. Drag the LT Query Sequencer folder template from the Templates folder
    either to the Desktop or to another LT Query Sequencer folder.

 2. Open the new LT Query Sequencer folder.  Notice it already contains an LT
    Query file and an LT Query Result file.  These are empty.

Related information:

Creating Queries against Light Table folders.


ΓòÉΓòÉΓòÉ <hidden> Run Query ΓòÉΓòÉΓòÉ

After placing the query instructions in the LT Query objects in the LT Query
Sequencer folder, select the Run query menu option to run those instructions.

Related Information

Check Query


ΓòÉΓòÉΓòÉ <hidden> Query Status ΓòÉΓòÉΓòÉ

The Query Status window displays the status of your query.  You can use the
Cancel button at any time to stop execution of the query.


ΓòÉΓòÉΓòÉ <hidden> Check Query ΓòÉΓòÉΓòÉ

Before running a query, you can use the Check query menu option to validate the
contents of the LT Query objects and the LT Query Sequencer folder.

For example, the program checks for:

o validity of the sequence in this folder of the LT Query and LT Query Result
  files, and the LT Query Sequencer folders.
o the existence of the Light Table folders to be queried.
o the absence or presence of join fields.

The program does not check for the presence of or the validity of your SQL
statement(s), nor for the presence of the columns specified in those
statement(s).


ΓòÉΓòÉΓòÉ <hidden> Check Query ΓòÉΓòÉΓòÉ

The Check Query window displays any errors detected by the Check Query program.
If there is more than one error, each error is described on a different line.

If no error is detected you can run the query from this window using the Run
push button.

You can use the Cancel push button to exit this window.


ΓòÉΓòÉΓòÉ <hidden> Cancel Query ΓòÉΓòÉΓòÉ

You can use the Cancel query menu option to stop a query that is in process.


ΓòÉΓòÉΓòÉ 12. LT Query File Help ΓòÉΓòÉΓòÉ

Each LT Query object is a file containing the information and SQL instructions
needed for a single query against a Light Table folder or a database.

LT Query objects are stored in LT Query Sequencer folders which have the
ability to run their query instructions.  When an LT Query Sequencer folder is
created, it automatically contains an empty LT Query object.  You can also
create an LT Query object by dragging an LT Query template from the Templates
folder into an LT Query Sequencer folder.

To place query specifications in an LT Query object, double-click on it. This
starts the Query Editor which prompts you for the needed information.

Related information:

Creating Queries against Light Table folders.


ΓòÉΓòÉΓòÉ 13. Query Editor ΓòÉΓòÉΓòÉ

Query Editor is the program through which you provide the information needed to
query Light Table folders and databases.  Query Editor is associated with LT
Query objects.

To start the Query Editor:

o Open an LT Query object, OR,

o Double-click on the Query Editor icon in the Ultimedia Tools

The Query Editor prompts you for information about the Light Table folder or
database you want to query and for the Structured Query Language (SQL)
statement(s) for making the query.

Related information:

o Creating Queries against Light Table folders
o Lt Query Object Help
o A Brief Review of SQL


ΓòÉΓòÉΓòÉ <hidden> Query Editor - Open ΓòÉΓòÉΓòÉ

Use this window to identify the LT Query file you want to view.

To open the LT Query file:

 1. Select the arrow to the right of the Drive list to display all the drives
    on your system.
 2. Select a drive from the Drive list.
 3. Select a directory from the Directory list.
 4. Type LT Query as the File type.
 5. Select a file name from the File list or type in a file name.
 6. Select the OK push button to display the file.

For a detailed explanation of each field, select from the list below:

o Open filename
o Type of file
o Drive
o File
o Directory
o OK button
o Cancel button


ΓòÉΓòÉΓòÉ <hidden> Open filename ΓòÉΓòÉΓòÉ

Type the name of the LT Query file you want to open in the Open filename field
and select the OK push button.


ΓòÉΓòÉΓòÉ <hidden> Type of file ΓòÉΓòÉΓòÉ

Select the arrow to the right of the Type of file field to display the
available file types.  Select the file type of LT Query or type LT Query in the
field.


ΓòÉΓòÉΓòÉ <hidden> Query Editor - Database Selection ΓòÉΓòÉΓòÉ

Use this window to indicate whether you want to query a Light Table folder or
one of the supported databases.  A sequence of queries in one LT Sequencer
folder can only be against one type of database.

To indicate the type of query:

 1. Select Light Table folder or the type of database.
 2. Use the OK button to continue.

You can use the Cancel button to close the Query Editor.


ΓòÉΓòÉΓòÉ <hidden> Query Editor - Light Table Folder ΓòÉΓòÉΓòÉ

To provide the information needed to run a Light Table folder query:

 1. Click on the Select button and select a Light Table folder from the
    resulting notebook.
 2. Type your Structured Query Language (SQL) statements into the SQL
    statements box.
 3. If this is a multiple step query, type the Join Fields that link to the
    Previous and/or Next queries in the sequence.

For a detailed explanation of each field, select from the list below.

o Light Table Folder Name
o SQL Statements
o Join Fields
o OK button
o Cancel button

Related information:

o Creating Queries against Light Table folders.
o Creating Multiple Step Queries
o A Brief Review of SQL


ΓòÉΓòÉΓòÉ <hidden> Light Table Folder Name ΓòÉΓòÉΓòÉ

To identify the Light Table folder you are querying:

 1. Use the Select button to display a selections notebook.
 2. Select a Light Table folder from the resulting notebook pages and use the
    OK push button to return the selection to the Folder Name field.


ΓòÉΓòÉΓòÉ <hidden> SQL Statements ΓòÉΓòÉΓòÉ

To enter your Structured Query Language (SQL) statement(s):

Type them into the SQL Statements box.

 1. Type a SELECT clause; include the column names you want to see; you can use
    an * to see all of the columns.
 2. Type the FROM LTFOLDER clause.
 3. Use the WHERE clause to filter out unwanted records. (Optional)

Example:

SELECT EMPNO, EMPNAME, DEPT, MGR
FROM LTFOLDER
WHERE DEPT=102

Related information:

A Brief Review of SQL.


ΓòÉΓòÉΓòÉ <hidden> Join Fields ΓòÉΓòÉΓòÉ

Only use the Join fields if the query is part of a multiple step query.

o If this is the first query in the sequence, in the Next join field  type the
  name of the column whose data is to be matched against the Previous join
  field specified in the next query.

o If this is the last query in the sequence, in the Previous join field  type
  the name of the column whose data is to be matched to the Next join field
  specified in the previous query.

o If this is an intermediate query in a sequence of three or more queries,
  enter column names in both the Previous and Next join fields as just
  described.

In all cases, the column specified in the Previous join field should contain
unique values. In other words, any value can be in only one record in the Light
Table folder or database being queried.

Related information:

Creating Multiple Step Queries


ΓòÉΓòÉΓòÉ <hidden> OK Button ΓòÉΓòÉΓòÉ

After typing all the needed information, select the OK button to close the
window.


ΓòÉΓòÉΓòÉ <hidden> Cancel Button ΓòÉΓòÉΓòÉ

Select the Cancel button to close the LT Query object without accepting any
changes made to it since it was opened.


ΓòÉΓòÉΓòÉ <hidden> dBASE Format ΓòÉΓòÉΓòÉ

To provide the information needed to run a database query:

 1. Type your Structured Query Language (SQL) statements into the SQL
    statements box.
 2. If this is a multiple step query, type the Join Fields that link to the
    Previous and/or Next queries in the sequence.

For a detailed explanation of each field, select from the list below.

o SQL Statements
o Join Fields
o OK button
o Cancel button


ΓòÉΓòÉΓòÉ <hidden> SQL Statements ΓòÉΓòÉΓòÉ

To enter your Structured Query Language (SQL) statement(s):

Type them into the SQL Statements box.

 1. Type a SELECT clause; include the column names you want to see; you can use
    to * to see all of the columns.
 2. Type a FROM clause including the table name and its full path.
 3. Use the WHERE clause to filter out unwanted records. (Optional)

Example:

SELECT EMPNO, EMPNAME, DEPT, MGR
FROM D:\PAYROLL\EMP.DATA
WHERE DEPT=102

Related information:

A Brief Review of SQL.


ΓòÉΓòÉΓòÉ <hidden> Query Editor - Database Information ΓòÉΓòÉΓòÉ

To provide the information needed for a database query:

 1. Type the database or table name in the Database Name field.
 2. Type your Userid for access to the database.
 3. Type the Password for access to the database.
 4. If appropriate, type the Server name.
 5. Type your SQL statements in the SQL Statements box.
 6. If this is a multiple step query, type the Join Fields that link to the
    Previous and/or Next queries in the sequence.

For a detailed explanation of each field, select from the list below.

o Database Name
o Userid
o Password
o Server
o SQL Statements
o Join Fields
o OK button
o Cancel button


ΓòÉΓòÉΓòÉ <hidden> Database Name ΓòÉΓòÉΓòÉ

To select the name of the database you are querying:

 1. Click on the down arrow to display the list of available databases.
 2. Select a database from the list.


ΓòÉΓòÉΓòÉ <hidden> Userid ΓòÉΓòÉΓòÉ

For access to your database, type your userid in this field.


ΓòÉΓòÉΓòÉ <hidden> Password ΓòÉΓòÉΓòÉ

For access to your database, type the password associated with your userid. For
security, an asterisk (*) displays for each character typed.


ΓòÉΓòÉΓòÉ <hidden> Server ΓòÉΓòÉΓòÉ

Type the Server name for the Oracle database.


ΓòÉΓòÉΓòÉ <hidden> SQL Statements ΓòÉΓòÉΓòÉ

Type your Structured Query Language (SQL) statement(s) into the SQL statements
box.

 1. Type a SELECT clause; include the column names you want to see.
 2. Type a FROM clause including the Table name and its full path.
 3. Use the WHERE clause to filter out unwanted records. (Optional)

Example:

SELECT EMPNO, EMPNAME, DEPT, MGR
FROM EMP_DATA
WHERE DEPT=102

Related information:

A Brief Review of SQL.


ΓòÉΓòÉΓòÉ 14. A Brief Review of SQL ΓòÉΓòÉΓòÉ

Structured Query Language (SQL) is an English-like language used to manage
information in relational databases.  In Workplace/2 you can use a subset of
SQL to retrieve information from Light Table folder extended data and from
dBASE format, DB2/2, OS/2 Database Manager, and Oracle databases.

A database is a table with horizontal rows and vertical columns.  One row
contains information, organized in fixed sized fields, about one entity.  Stack
more than one row on top of each other and look vertically at the stack.
Together the fields form a column.  Each column has a name for the information
contained in its fields.

For example, a table of information about employees has one row for each
employee.  The columns define the kind of information stored for the employees:
employee number, name, department, salary, etc.

Through SQL statements you describe which rows and which columns of information
you want to view based on the values of the fields where the rows and columns
intersect.

The SQL statements used in Workplace/2 use the SELECT command whose general
form is:

SELECT column-name[, column-name ...]
FROM table-name
[WHERE column-name operator characters/numbers]

   (Left and right brackets ([ ]) denote optional entries.)

After SELECT  list the column name(s) you want, separated by commas if there is
more than one, or use an asterisk (*) to select all of the columns.

After FROM  specify the table (database) in terms of its name and, if needed,
physical location (drive and path) on the system.

There can be multiple WHERE clauses, or none. After each WHERE  specify the
condition the data must meet to be selected based on the value of a field.  For
example, WHERE DEPT=S12, or WHERE HOURS>40. The most-used operators are:

     =     (equal to)
     <>    (not equal to)
     >     (greater than)
     >=    (greater than or equal to)
     <     (less than)
     <=    (less than or equal to)

 Here is an example of how a set of SQL instructions could look in the SQL
 statements box in the LT Query Editor:

  select  empname, dept, ext
  from d:\dbf\emp.data
  where dept='S12'


ΓòÉΓòÉΓòÉ 15. LT Query Result Help ΓòÉΓòÉΓòÉ

An LT Query Result object holds the results, in table form, of a query.

If you open an LT Query Result object, the Query Result Viewer displays the
results of the query.

Related information:

Query Result Viewer


ΓòÉΓòÉΓòÉ 16. Query Result Viewer ΓòÉΓòÉΓòÉ

The Query Result Viewer lets you to browse the results of queries you have run
against Light Table folders or dBASE format, OS/2 Database Manager, DB2/2, or
Oracle databases. The Query Result Viewer automatically starts when you open a
Query Result file.

You can also use the Query Result Viewer to view and change database tables by
opening the Query Result Viewer icon in the Ultimedia Tools folder, or by using
the Open menu item from its File pulldown.  Normal security and access rules
apply.

Related information:

 o Query Result Viewer Functions
 o LT Query Result Help


ΓòÉΓòÉΓòÉ 17. Query Result Viewer Functions ΓòÉΓòÉΓòÉ

The Query Result Viewer has two functions.

 o You can use the Query Result Viewer to look at the results of queries. The
   Query Result Viewer is linked directly to the LT Query Result object which
   displays the results of a query in a table.

   The LT Query Result Object automatically runs the Query Result Viewer for
   you when a query is complete.  You can also can start the viewer by opening
   (double-clicking on) an LT Query Result object that has been updated as a
   result of a query.

   You can manipulate what you are viewing through options provided on the
   program's action bar, and you can choose to convert the results into new
   multimedia objects in a new Light Table folder.

 o You can use the Query Result Viewer to access external databases.

   Once you are viewing query results, you can use the Query Result Viewer for
   this purpose, or you can open the Query Result Viewer program object in the
   Ultimedia Tools folder. Subject to the restrictions of your database system,
   you can even make changes to the database by adding, modifying, or deleting
   records.


ΓòÉΓòÉΓòÉ <hidden> Query Result Viewer - File menu ΓòÉΓòÉΓòÉ

Use the choices on the File menu to open a dBASE format, OS/2 Database Manager,
IBM DATABASE 2 OS/2, or Oracle database file for viewing, or to save the viewed
file.

Related information:

 o Open
 o Save


ΓòÉΓòÉΓòÉ <hidden> Open. ΓòÉΓòÉΓòÉ

Use the Query Result Viewer's Open menu option in place of your database
program to view and update your database files.

Select the Open option to open an existing database file for viewing, then
select the database file type:

 o dBASE format
 o IBM DATABASE 2 OS/2 (DB2/2)
 o OS/2 Database Manager
 o Oracle


ΓòÉΓòÉΓòÉ <hidden> Open - dBASE format ΓòÉΓòÉΓòÉ

Select the dBASE format menu option to open a dBASE format file.


ΓòÉΓòÉΓòÉ <hidden> Open - DB2/2 or OS/2 Database Manager ΓòÉΓòÉΓòÉ

Select the DB2/2 or OS/2 Database Manager) menu option to open a DB2/2 or OS/2
Database Manager file.


ΓòÉΓòÉΓòÉ <hidden> Open - Oracle ΓòÉΓòÉΓòÉ

Select the Oracle menu option to open an Oracle file.


ΓòÉΓòÉΓòÉ <hidden> dBASE format - Open ΓòÉΓòÉΓòÉ

Use the Open window to identify the dBASE format table you want to access.

To open a dBASE format file:

  1. Select the arrow to the right of the Drive list to display all the drives
     on your system.
  2. Select a drive from the Drive list.
  3. Select a directory from the Directory list.
  4. Select a file name from the File list or type in a file name in the Open
     Filename field.
  5. Select the OK push button to display the file.

 For a detailed explanation of each field, select from the list below:

 o Open filename
 o Type of file
 o Drive
 o File
 o Directory
 o OK button
 o Cancel button


ΓòÉΓòÉΓòÉ <hidden> Open filename ΓòÉΓòÉΓòÉ

Type the name of the database file you want to open in the Open filename field
and select the OK push button.


ΓòÉΓòÉΓòÉ <hidden> Type of file ΓòÉΓòÉΓòÉ

Click on the arrow to the right of the Type of file field to display the
available file types.


ΓòÉΓòÉΓòÉ <hidden> Drive ΓòÉΓòÉΓòÉ

The Drive list displays the drives on your system.  Select the drive that
contains the file you want to view.


ΓòÉΓòÉΓòÉ <hidden> File ΓòÉΓòÉΓòÉ

The File list displays all of the files in the directory you selected from the
directory list.  Select the file you want to open.


ΓòÉΓòÉΓòÉ <hidden> Directory ΓòÉΓòÉΓòÉ

The Directory list displays the directories on the selected drive. Select a
directory to display the list of files from that directory in the File list
box.


ΓòÉΓòÉΓòÉ <hidden> OK button ΓòÉΓòÉΓòÉ

Select the OK push button to display the file you want to view.


ΓòÉΓòÉΓòÉ <hidden> Cancel button ΓòÉΓòÉΓòÉ

Select the Cancel push button if you decide not to open a file.


ΓòÉΓòÉΓòÉ <hidden> Oracle, DB2/2, or OS/2 Database Manager - Open ΓòÉΓòÉΓòÉ

To open a database file or table:

  1. Type the name of the database in the Database Name field.
  2. Type the name of the table in the Table Name field.
  3. Type your Userid used to access the database.
  4. Type the Password associated with your userid.
  5. If required by your database system, type the name of the Server through
     which you access the database.
  6. Select the OK button to open the file.

 For a detailed explanation of each field, select from the list below:

 o Database Name
 o Table Name
 o Userid
 o Password
 o Server
 o OK button
 o Cancel button


ΓòÉΓòÉΓòÉ <hidden> Database Name ΓòÉΓòÉΓòÉ

Type the name of the appropriate database in the Database Name field.  This
field is only relevant to tables stored by DB2/2 or OS/2.


ΓòÉΓòÉΓòÉ <hidden> Table Name ΓòÉΓòÉΓòÉ

Type the name of the table you want to view.


ΓòÉΓòÉΓòÉ <hidden> Userid ΓòÉΓòÉΓòÉ

For access to your table, type your DB2/2, OS/2 Database Manager or Oracle
userid.


ΓòÉΓòÉΓòÉ <hidden> Password ΓòÉΓòÉΓòÉ

For access to your table, type the password associated with your userid.  For
security, an asterisk (*) displays for each character typed.


ΓòÉΓòÉΓòÉ <hidden> Server ΓòÉΓòÉΓòÉ

For Oracle databases.  Type the name of the server through which you access the
database.


ΓòÉΓòÉΓòÉ <hidden> OK button ΓòÉΓòÉΓòÉ

After typing all the needed information, select the OK button to display the
desired table.


ΓòÉΓòÉΓòÉ <hidden> Cancel button ΓòÉΓòÉΓòÉ

Select the Cancel button if you decide not to open a database file.


ΓòÉΓòÉΓòÉ <hidden> Key Column Identification ΓòÉΓòÉΓòÉ

After opening the Query Result viewer, the first time you try to change or
delete a row this window prompts you to identify the column(s) that serve as
the key to your database file.

To identify a column:

  1. Select the appropriate name under Available Columns..
  2. Select the Add button.  The selected name shows in the Key Columns list.

 To remove a column from the Key Columns list:

  1. Select the column to be removed,.
  2. Select the Remove button.

 When the Key Columns list is correct, select the OK button to continue.

 Warning:  Be sure to select the correct column(s); otherwise deletions or
 changes could be made to the wrong records.

 For a detailed explanation of each field, select from the list below:

 o Available Columns
 o Add button
 o Key Columns
 o Remove button
 o OK button
 o Cancel button


ΓòÉΓòÉΓòÉ <hidden> Available Columns ΓòÉΓòÉΓòÉ

The  Available Columns box lists all of the columns defined for the table being
viewed.

To select a column name, click on it. Selected columns are marked with reverse
highlighting.  To deselect a selected column name, click on it and it will
change to display normally.

When you select the Add button, marked columns are added to the Key Columns
list.


ΓòÉΓòÉΓòÉ <hidden> Add button ΓòÉΓòÉΓòÉ

Click on the Add button to add to the Key Columns list all of the columns
marked in the Available Columns list.


ΓòÉΓòÉΓòÉ <hidden> Key Columns ΓòÉΓòÉΓòÉ

The Key Columns box should list any table columns that make up the key to the
database table.

To add columns to the Key Columns list:

  1. Select them from the Available Columns list.
  2. Click on the Add button.  The columns are listed in the sequence they were
     added.

 To remove a column from the Key Columns list:

  1. Select the column.
  2. Click on the Remove button.


ΓòÉΓòÉΓòÉ <hidden> Remove button ΓòÉΓòÉΓòÉ

Click on the Remove button to remove from the Key Columns list any columns
selected in that list.


ΓòÉΓòÉΓòÉ <hidden> OK button ΓòÉΓòÉΓòÉ

When the Key Columns list is correct, select the OK button to proceed.


ΓòÉΓòÉΓòÉ <hidden> Cancel button ΓòÉΓòÉΓòÉ

Click on the Cancel button if you do not want to proceed with changing the
database file.


ΓòÉΓòÉΓòÉ <hidden> Save. ΓòÉΓòÉΓòÉ

Select the Save option to permanently save the changes you have made in the
file you are viewing.


ΓòÉΓòÉΓòÉ <hidden> Query Result Viewer - Folder menu ΓòÉΓòÉΓòÉ

Use the Folder menu options to create an empty Light Table folder or to convert
the file being viewed into a Light Table folder.

Related information:

 o Create a Light Table folder
 o Convert to a Light Table folder


ΓòÉΓòÉΓòÉ <hidden> Create a Light Table folder ΓòÉΓòÉΓòÉ

Select the Create a Light Table folder option to create an empty Light Table
folder.


ΓòÉΓòÉΓòÉ <hidden> Create a Light Table Folder (from a database) ΓòÉΓòÉΓòÉ

To create an empty Light Table folder from the database:

  1. Type the title of the new Light Table folder being created in the Folder
     Title field.
  2. Select the column whose contents would provide the titles for its
     multimedia objects.
  3. Select the Create button.

 The named Light Table folder is created on your Desktop with schema from the
 database file you are viewing.

 For a detailed explanation of each field, select the item from the list below:

 o Folder Title
 o Title Column
 o Create button
 o Cancel button


ΓòÉΓòÉΓòÉ <hidden> Folder Title ΓòÉΓòÉΓòÉ

Type the title for the new Light Table folder.


ΓòÉΓòÉΓòÉ <hidden> Title Column. ΓòÉΓòÉΓòÉ

Select the name of the column which contains the titles of the multimedia
objects when they are placed in the folder.


ΓòÉΓòÉΓòÉ <hidden> Create button ΓòÉΓòÉΓòÉ

After completing the requested information, click on the Create button to
create the new Light Table folder on your Desktop.


ΓòÉΓòÉΓòÉ <hidden> Cancel button ΓòÉΓòÉΓòÉ

Click on the Cancel button to return to viewing the file without creating a new
Light Table folder.


ΓòÉΓòÉΓòÉ <hidden> Create a Light Table Folder (from a Light Table query) ΓòÉΓòÉΓòÉ

To create an empty Light Table folder from a query to a Light Table folder:

  1. In the Folder Title field, type the title for the Light Table folder to be
     created.
  2. Select the Create button.

 A Light Table folder is created on your Desktop with schema definitions
 identical to those of the Light Table folder that was queried.

 For a detailed explanation of each field, select the item from the list below:

 o Folder Title
 o Create button
 o Cancel button


ΓòÉΓòÉΓòÉ <hidden> Folder Title ΓòÉΓòÉΓòÉ

Type the title for the new Light Table folder.


ΓòÉΓòÉΓòÉ <hidden> Create button ΓòÉΓòÉΓòÉ

After completing the requested information, click on the Create button to
create the new Light Table folder on your Desktop.


ΓòÉΓòÉΓòÉ <hidden> Cancel button ΓòÉΓòÉΓòÉ

Use the Cancel button to return to viewing the file without creating a new
Light Table folder.


ΓòÉΓòÉΓòÉ <hidden> Convert to a Light Table folder ΓòÉΓòÉΓòÉ

Select the Convert to a Light Table folder option to create a Light Table
folder containing a separate multimedia object for each row in the file being
viewed.


ΓòÉΓòÉΓòÉ <hidden> Convert to a Light Table Folder (from a database) ΓòÉΓòÉΓòÉ

To convert the database file you are viewing into a folder:

  1. Type the title of the new Light Table folder in the Folder Title field.
  2. Select the column whose contents would provide the titles for its
     multimedia objects.
  3. If applicable, select the column which contains the filename (including
     path) for the media file to be used for the object's thumbnail.
  4. Select a multimedia file type which gets assigned to all of the multimedia
     objects stored in the new Light Table folder.
  5. Select the Convert button.

 A Light Table folder is created on your Desktop containing a multimedia object
 for each row in the table,  The new Light Table folder's schema reflects the
 schema of the database being viewed.

 For a detailed explanation of each field, select from the list below:

 o Folder Title
 o Title Column
 o Icon Column
 o Multimedia type
 o Convert button
 o Cancel button

 Tip:  Only the rows that you can scroll and view are converted to multimedia
 objects in the new folder. To convert a subset of the database rows into
 objects in the new folder, you can "delete" them from view by marking them and
 using the Delete Mark menu item from the Edit pulldown menu.


ΓòÉΓòÉΓòÉ <hidden> Folder Title ΓòÉΓòÉΓòÉ

Type the title of the new Light Table folder.


ΓòÉΓòÉΓòÉ <hidden> Title Column ΓòÉΓòÉΓòÉ

Select the name of the database column whose values provide the titles for the
folder's multimedia objects.


ΓòÉΓòÉΓòÉ <hidden> Icon Column ΓòÉΓòÉΓòÉ

Select the name of the database column which contains as data the full filename
(including its path) for the media file.

When the system creates the Light Table folder and converts each database row
into a multimedia object, it uses this column's value to find its media file.

This is an optional field and is only relevant to multimedia image objects.


ΓòÉΓòÉΓòÉ <hidden> Multimedia Type ΓòÉΓòÉΓòÉ

Select one multimedia type (audio, video, image, story, or text) that gets
assigned to all objects that are put into the folder.

This selection affects which browser is assigned to each object, and which
thumbnail image is shown for each object.

If multimedia objects of different types are put into this folder, you need to
go into the Light Table folder and change the file type  setting of each object
of a different type to reflect its own media type.


ΓòÉΓòÉΓòÉ <hidden> Convert button ΓòÉΓòÉΓòÉ

After completing the requested information, click on the Convert button to
create a new Light Table folder on your Desktop and convert each row in the
table into a multimedia object within the new folder.


ΓòÉΓòÉΓòÉ <hidden> Cancel button ΓòÉΓòÉΓòÉ

Use the Cancel button to return to viewing the file without converting the
database being viewed to a new Light Table folder.


ΓòÉΓòÉΓòÉ <hidden> Convert to a Light Table Folder (from a Light Table query) ΓòÉΓòÉΓòÉ

To convert the Light Table query result you are viewing into a Light Table
folder:

  1. In the Folder Title field, type the title for the new Light Table folder.
  2. Select the Convert button.

 A Light Table folder is created on your Desktop containing multimedia objects
 for each row in the table.  The schema of the original Light Table folder is
 duplicated as the new Light Table folder's schema.

 For a detailed explanation of each field, select from the list below:

 o Folder Title
 o Convert button
 o Cancel button


ΓòÉΓòÉΓòÉ <hidden> Folder Name ΓòÉΓòÉΓòÉ

Type the title for the new Light Table folder.


ΓòÉΓòÉΓòÉ <hidden> Convert button ΓòÉΓòÉΓòÉ

After typing the requesting information, click on the Convert button to create
a new Light Table folder on your Desktop and convert each row in the table into
a multimedia object within the new folder.


ΓòÉΓòÉΓòÉ <hidden> Cancel button ΓòÉΓòÉΓòÉ

Use the Cancel button to return to viewing the file without converting it into
a new Light Table folder.


ΓòÉΓòÉΓòÉ <hidden> Query Result Viewer - Edit menu ΓòÉΓòÉΓòÉ

Use the Edit menu options to delete rows from the database being viewed, or to
undo the most recent changes made to the database.

Related information:

 o Delete Mark
 o Undo Delete
 o Undo Change


ΓòÉΓòÉΓòÉ <hidden> Delete Mark ΓòÉΓòÉΓòÉ

Select the Delete mark option to delete all records whose key value is the same
as that of the row marked for deletion.


ΓòÉΓòÉΓòÉ <hidden> Undo Delete ΓòÉΓòÉΓòÉ

Select the Undo delete option to bring back the rows deleted the last time the
Delete mark option was taken.


ΓòÉΓòÉΓòÉ <hidden> Undo Change ΓòÉΓòÉΓòÉ

Select the Undo change option to undo the last change you made against the
viewed database.


ΓòÉΓòÉΓòÉ <hidden> Query Result Viewer - Icon Size Menu ΓòÉΓòÉΓòÉ

Use the Icon Size menu options to specify how large you want to display the
thumbnailicons:

 o Small
 o Medium
 o Large, the default size.


ΓòÉΓòÉΓòÉ <hidden> Small ΓòÉΓòÉΓòÉ

The default size (Large) of a thumbnail icon is its size when it first
displays. Select the Small menu option to display the thumbnail icon as 1/16th
the size of the default size.


ΓòÉΓòÉΓòÉ <hidden> Medium ΓòÉΓòÉΓòÉ

The default size (Large) of a thumbnail icon is its size when it first
displays.  Select the Medium menu option to display the thumbnail icon as 1/4th
the size of the default size.


ΓòÉΓòÉΓòÉ <hidden> Large ΓòÉΓòÉΓòÉ

Select the Large menu option to return the thumbnail icon's display size to its
default size.


ΓòÉΓòÉΓòÉ <hidden> Query Result Viewer - View Menu ΓòÉΓòÉΓòÉ

Use View menu options to tailor what you see while browsing a Query Result
file.

 o You can specify whether or not you want to display the thumbnails for the
   media fields.
 o You can choose to view a select set of the available columns by "hiding"
   those you don't want to see.
 o You can choose to sort the file by specifying a sort column.

 Related topics:

 o Display Media Fields
 o Hide Media Fields
 o Hide Columns
 o Sort by Column


ΓòÉΓòÉΓòÉ <hidden> Display Media Fields ΓòÉΓòÉΓòÉ

Select the Display media fields option to include thumbnails in your view.

Related information

Media fields


ΓòÉΓòÉΓòÉ <hidden> Hide Media Fields ΓòÉΓòÉΓòÉ

Select the Hide media fields option if you do not want to include thumbnails in
your view.

Related information

Media fields


ΓòÉΓòÉΓòÉ <hidden> Hide Columns ΓòÉΓòÉΓòÉ

If your file displays more information than you want, you can use the Hide
columns option to identify which columns you want to temporarily hide from
view.  You can also re-display columns that were previously hidden.


ΓòÉΓòÉΓòÉ <hidden> Hide Columns ΓòÉΓòÉΓòÉ

To make viewing the file more manageable, you can hide from view the columns
you don't want to see.  The list box displays all of the columns that are
available for viewing.  Where two adjacent columns have the same name, the
first instance represents the text view of a Media field and the second
instance represents the thumbnail view.

All reverse-highlighted (marked) columns are selected to be hidden from view.

 o To select an unmarked column to be hidden, click on it.

 o To deselect a marked column, click on it.

 Use the OK button to return to viewing the file after you have marked the
 columns to be hidden.

 Use the Cancel button to return to viewing the file without changing which
 files are hidden.


ΓòÉΓòÉΓòÉ <hidden> Select Columns To Hide ΓòÉΓòÉΓòÉ

The list box displays all of the columns that are available for viewing.  Where
two adjacent columns have the same name, the first instance represents the text
view of a Media field and the second instance represents the thumbnail view.

All reverse-highlighted (marked) columns are selected to be hidden from view.

 o To select an unmarked column to be hidden, click on it.

 o To deselect a marked column, click on it.


ΓòÉΓòÉΓòÉ <hidden> OK button ΓòÉΓòÉΓòÉ

Use the OK button to return to viewing the file after you have marked the
columns to be hidden.


ΓòÉΓòÉΓòÉ <hidden> Cancel button ΓòÉΓòÉΓòÉ

Use the Cancel button to return to viewing the file without changing which
files are hidden.


ΓòÉΓòÉΓòÉ <hidden> Sort by Column ΓòÉΓòÉΓòÉ

Select the Sort by column option to change the sequence of the rows in the file
being viewed.


ΓòÉΓòÉΓòÉ <hidden> Sort Column Identification ΓòÉΓòÉΓòÉ

To change the sort sequence of the rows being viewed:

  1. Click on a column name in the list box to select it as the sort column.
  2. Click on the Sort button to view the sorted file.

 The rows always display in ascending sequence.

 For a detailed explanation of each field, select from the list below:

 o Select a Column by which to Sort
 o Sort button
 o Cancel button


ΓòÉΓòÉΓòÉ <hidden> Select a Column by which to Sort ΓòÉΓòÉΓòÉ

The list box displays the names of all the columns defined for the file being
viewed.

 To select a column,
      click on its name. Selected columns display with reverse highlighting.

 To deselect a selected column,
      click on it and it changes to display normally.


ΓòÉΓòÉΓòÉ <hidden> Sort button ΓòÉΓòÉΓòÉ

Click on the Sort button to sort the file on the values of the selected
columns.


ΓòÉΓòÉΓòÉ <hidden> Cancel button ΓòÉΓòÉΓòÉ

Click on the Cancel button if you want to return to viewing the file without
sorting it.


ΓòÉΓòÉΓòÉ 18. Media Browsers ΓòÉΓòÉΓòÉ

The Media Browsers let you view or display multimedia files. Ultimedia
Workplace/2 automatically associates a media browser with a multimedia object
based on its file type.

To browse a multimedia object:

 Double-click on its thumbnail frame.

 You can also start a browser by double-clicking on its icon in the Ultimedia
 Tools folder.

 Related information:

 o Image Browser
 o Audio Browser
 o Story Browser
 o Text Browser
 o Video Browser
 o Table of multimedia file types, and extensions


ΓòÉΓòÉΓòÉ <hidden> Audio Browser ΓòÉΓòÉΓòÉ

Use the Audio browser to play an audio file.

The browser provides a window displaying  control buttons enabling you to
start, stop, pause, fast-forward, reverse, and partially play the file.

A counter shows the current position in seconds.


ΓòÉΓòÉΓòÉ <hidden> Video Browser ΓòÉΓòÉΓòÉ

Use the Video browser to view a video file.

The browser provides a window displaying  control buttons enabling you to
start, stop, pause, fast-forward, reverse, and partially play the file.

A counter shows the current position in frames.


ΓòÉΓòÉΓòÉ 19. Clipdata Help ΓòÉΓòÉΓòÉ

Ultimedia Workplace/2 provides Clipdata objects as tools you can use to
transfer images through the Windows and OS/2 clipboards.

To place an image into the system clipboard:

 o Create a Clipdata object by dragging the Clipdata template in the Templates
   folder onto the Desktop or a folder.

   To change the name of the new Clipdata object, press the Alt key at the same
   time you click on the Clipdata object's name.  Type in the new name, then
   click outside the data entry field.

   (Note: If you open the Clipdata object at this point it displays the current
   contents of the system clipboard through the Clipdata view window.)

 o Drag and drop your image object onto the Clipdata object or onto the open
   Clipdata view window.

 Once your image is in the clipboard it can be used by any program that accepts
 images through the clipboard, for example, most word processing programs.

 You can temporarily store the image in the Clipdata object.

 Other ways to use the Clipdata object to put images into the clipboard:

 o Opening an existing Clipdata object always puts its contents into the
   clipboard.

 o Cut and paste part of an image into the clipboard.

   This involves drawing a bounding box around the part of the image you want
   and "copying" it to the clipboard.

     1. Move the mouse pointer to the place where you want the upper left
        corner of the bounding box to be.
     2. Hold down mouse button 1 and drag the pointer at an angle, downwards
        and to the right, until the box defines the area you want.
     3. Click once on the title bar icon to display the title bar menu.
     4. Click on the Edit menu option, then the Copy option.

 You can also use the bounding box in the Clipdata view window to define an
 area into which to place the current contents of the clipboard.

 Clipdata objects convert any type of image recognized by Workplace/2 to a .BMP
 file, a format commonly used by programs in both the OS/2 and Windows
 environments.

 Clipdata objects only deal with images, not ASCII text.

 Related information:

 o Copy menu option
 o Paste menu option
 o Clear menu option
 o Refresh menu option
 o Saving clipboard images as files


ΓòÉΓòÉΓòÉ 20. Saving Clipboard Images as Files ΓòÉΓòÉΓòÉ

Once you have used a Clipdata object to place an image into the system
clipboard you can use the following technique to save the image as a .BMP
(bitmap) file:

One-time changes-associating the Clipdata and Bitmap templates to a graphics
program, Windows Pbrush.

  1. Open the templates folder.

  2. Use mouse button 2 to click on the Clipdata template to present its pop-up
     menu.

  3. Click (with mouse button 1) on the small arrow to the right of the Open
     option.

  4. Click on the Settings option.

  5. Click on the Menu tab of the settings notebook.

  6. Select Open in the Available menus box

  7. Click on the Create another button to the right of the Actions on: Open
     selection box.

  8. In the resulting Menu Item Settings window, type Windows Pbrush as the
     Menu item name, and type pbrush.exe as the Program name.  Click on OK to
     close the window.

  9. Double-click on the settings notebook's title bar icon to close the
     notebook.

 10. Repeat steps 2 through 9 for the Bitmap template.

 To save an image in the clipboard as a file.

 This procedure assumes the desired image is already in the system clipboard
 and that the Clipdata object has an association to the Windows Pbrush program.

  1. Use the Bitmap template to create an empty bitmap file.  Rename as
     appropriate.

  2. Click once with mouse button 2 on the Clipdata object that reflects the
     contents of the clipboard to display its pop-up menu.

  3. Click (with mouse button 1) on the small arrow to the right of the Open
     option.

  4. Click on the Windows Pbrush menu option.  The Pbrush program opens
     displaying your image.

  5. Click on the File option on the program's action bar.

  6. Click on the Save as option.

  7. Select the bitmap file you created in step 1 and click on the OK button.


ΓòÉΓòÉΓòÉ <hidden> Clipdata object - Edit Menu Option ΓòÉΓòÉΓòÉ

Use the Edit menu option to access the Copy, Paste, Clear, and Refresh
operations used by a Clipdata object.


ΓòÉΓòÉΓòÉ <hidden> Edit - Copy ΓòÉΓòÉΓòÉ

Use the Copy menu option to put the contents of your bounding box, or of the
entire image if there is no bounding box, into the system clipboard.


ΓòÉΓòÉΓòÉ <hidden> Edit - Paste ΓòÉΓòÉΓòÉ

Use the Paste menu option to put the contents of the system clipboard into the
bounding box drawn in the Clipdata view window, or into the entire window if
there is no bounding box.


ΓòÉΓòÉΓòÉ <hidden> Edit - Clear ΓòÉΓòÉΓòÉ

Use the Clear menu option to clear (empty) a clipdata object.  This also clears
the system clipboard.


ΓòÉΓòÉΓòÉ <hidden> Edit - Refresh ΓòÉΓòÉΓòÉ

Use the Refresh menu option to update the clipdata object with the current
contents of the system clipboard.


ΓòÉΓòÉΓòÉ 21. Using Safe to Back Up Files ΓòÉΓòÉΓòÉ

You can use Safe to identify files you want to back up, and to back up the
files to diskette.

To back up folder and file objects from your Desktop:

  1. Define the drive where you want to back up your files on the Drives page
     of the Safe folder's settings notebook.  The system default is the A:
     drive. These settings remain until you change them.

  2. Drag the data-objects or folders over the Safe folder and drop them in. A
     backup job object is created for each object.

  3. Use the Backup menu option from the Safe folder's pop-up menu to start the
     backup procedure.

     The system starts the OS/2 backup program on the objects for the job
     objects stored in the Safe folder.

  4. Insert the diskettes when prompted.

     A Progress window displays the progress of the backup procedure and an
     estimate of the time and capacity needed to complete the procedure.

 When finished, label the backup diskettes and store them in a safe place.

 If you need to restore the files, use these backup diskettes and take the
 Restore option from the Safe folder's pop-up menu.

 Related information:

 Using Safe to Restore Files


ΓòÉΓòÉΓòÉ 22. Using Safe to Restore files ΓòÉΓòÉΓòÉ

To restore files that were previously saved by Safe:

  1. Select the Restore option from the Safe folder's pop-up menu.

  2. Insert the requested diskettes into the appropriate drive as you are
     prompted.

     A Progress window displays a count of the diskettes used, the number of
     objects restored, their size in bytes, and the time taken to do the
     operation.

 Related information:

 Using Safe to Back Up Files


ΓòÉΓòÉΓòÉ 23. Safe Help ΓòÉΓòÉΓòÉ

Ultimedia Workplace/2 enhances OS/2 backup and recovery programs by providing
the Safe folder.

Use the Safe folder to collect objects for the files and/or folders you want to
back up.  Just drag the objects over the folder and drop them in. A backup job
object is created for each object you drop in.

Use the Safe folder's settings notebook to define the drive where you want to
back up your files.  The system default is the A: drive.

When you are ready to back up the files, select the Backup menu option from the
Safe pop-up menu.

The system starts the OS/2 backup program.  Two windows appear.

 o The Progress window displays an estimate of the time and capacity needed to
   complete the Backup procedure and displays its progress.

 o When requested, insert a diskette into the appropriate diskette drive.

 When the backup procedure is finished, label the backup diskettes and store
 them in a safe place.

 Related Information:

 o Using Safe to Back Up Files
 o Using Save to Restore Files


ΓòÉΓòÉΓòÉ <hidden> Drives Tab ΓòÉΓòÉΓòÉ

Use the Drives tab of the Safe folder's settings notebook to define the drives
you want to use for Backup and Recovery.

To define the Backup drive:

  1. Click on the arrow to the right of the list box for Backup to drive to
     display all of the diskette drives on your system.
  2. Select a drive from the list.

 To define the Recovery drive:

  1. Click on the arrow to the right of the list box for Recover from drive to
     display all of the diskette drives on your system.
  2. Select a drive from the list.

 Use the Undo button to return the values to what they were when you opened the
 notebook.

 Use the Default button to set both values to the A: drive.


ΓòÉΓòÉΓòÉ <hidden> Save Folder - Backup Menu Option ΓòÉΓòÉΓòÉ

Use the Backup menu option to back up the files stored in the Safe folder.

Related topics.

 o Using Safe to back up files
 o Using Safe to restore backed up files


ΓòÉΓòÉΓòÉ <hidden> Backup - Progress ΓòÉΓòÉΓòÉ

The Progress window displays status information while the backup procedure is
running.

A horizontal bar across the top of the window shows how much of the backup is
completed.

A box displays error messages and status messages including the names of each
file that is backed up.

Other display fields include estimates of the number of diskettes needed, a
count of the number of objects and their size, in bytes, and an estimate of the
amount of time the backup would take.

Actual counts display as the backup progresses.

Use the Cancel button to cancel the backup operation.

Related topics:

 o Using Safe to back up files
 o Using Safe to restore backed up files


ΓòÉΓòÉΓòÉ <hidden> Backup - Disk Request ΓòÉΓòÉΓòÉ

The Disk Request window requests that you insert a backup diskette in the
target drive. Insert an empty diskette and select Enter when ready.

If the diskette is unformatted, the backup program formats it for you.

You can use the Cancel button to cancel the backup operation.


ΓòÉΓòÉΓòÉ <hidden> Safe Folder - Restore Menu Option ΓòÉΓòÉΓòÉ

Use the Restore menu option to restore files that were previously saved using
the Safe Backup option.

Related topics:

 o Using Safe to back up files
 o Using Safe to restore backed up multimedia files


ΓòÉΓòÉΓòÉ <hidden> Restore - Disk Request ΓòÉΓòÉΓòÉ

The Disk Request window requests that you insert a specific diskette in a drive
it names. Insert the requested diskette and select Enter when ready.

You can use the Cancel button to cancel the process.

Note:  Cancelling in the middle of a restore process can bring indeterminite
results.  In most cases you should only use the Cancel button to cancel the
operation before inserting the first diskette.


ΓòÉΓòÉΓòÉ <hidden> Restore - Progress ΓòÉΓòÉΓòÉ

The Progress window reports the status of the file restoration process.

The restore program shows the file names as they are restored onto the system,
and indicates when the operation is complete.

It also displays a count of the diskettes used, the number of objects restored,
their size in bytes, and the time taken to do the operation.


ΓòÉΓòÉΓòÉ 24. Help for Workplace/2 objects ΓòÉΓòÉΓòÉ

Ultimedia Workplace/2 provides special versions of folder and data-file
objects. The General Help you get for these objects is the "generic" help
describing folders and data-file objects.

To provide help specific to the special versions of these objects, Workplace/2
provides a Help menu item for each object addressing its purpose and use.  For
example, a Light Table folder has the help menu option: Light Table folder
help.

To display the specific object help information for an object:

  1. Open the object's pop-up menu (click mouse button 2 once over the object.)

  2. Click on the small arrow to the far right of the Help menu option.

  3. Click on the object's specific help menu option.


ΓòÉΓòÉΓòÉ <hidden> Help for Workplace/2 Help ΓòÉΓòÉΓòÉ

Select Workplace/2 Help for general information about the Ultimedia Workplace/2
application.


ΓòÉΓòÉΓòÉ <hidden> Help for Light Table Help ΓòÉΓòÉΓòÉ

Select Light Table Help for general information about the Light Table folder.


ΓòÉΓòÉΓòÉ <hidden> Help for Multimedia Object Help ΓòÉΓòÉΓòÉ

Select Multimedia Object Help for general information about Multimedia objects.


ΓòÉΓòÉΓòÉ <hidden> Help for LT Reference Help ΓòÉΓòÉΓòÉ

Select LT Reference Help for general information about LT Reference objects.


ΓòÉΓòÉΓòÉ <hidden> Help for LT Query File Help ΓòÉΓòÉΓòÉ

Select LT Query File Help for general information about LT Query objects.


ΓòÉΓòÉΓòÉ <hidden> Help for LT Query Result File Help ΓòÉΓòÉΓòÉ

Select LT Query Result File Help for general information about LT Query Result
objects.


ΓòÉΓòÉΓòÉ <hidden> Help for LT Query Sequencer Help ΓòÉΓòÉΓòÉ

Select LT Query Sequencer Help for general information about LT Query Sequencer
folders.


ΓòÉΓòÉΓòÉ <hidden> Help for Safe Help ΓòÉΓòÉΓòÉ

Select Safe Help for general information about the Safe folder.


ΓòÉΓòÉΓòÉ <hidden> Help for Clipdata Help ΓòÉΓòÉΓòÉ

Select Clipdata Help for general information about Clipdata objects.


ΓòÉΓòÉΓòÉ <hidden> Help for Help menu ΓòÉΓòÉΓòÉ

The Help menu bar choices are:

 General help
    An overview of the application.
 Help index
    An alphabetical listing of help topics.
 Keys help
    A brief description of how to use the keyboard within the application.
 Using help
    General information about using help.


ΓòÉΓòÉΓòÉ <hidden> Help for Help index ΓòÉΓòÉΓòÉ

Select Help index to see an alphabetical list of the help information that is
available.

Double-click on an index entry to display the help related to that topic.

Press Esc to remove the help topic and get back to the index.


ΓòÉΓòÉΓòÉ <hidden> Help for General Help ΓòÉΓòÉΓòÉ

Select General help to obtain overview information on the application.


ΓòÉΓòÉΓòÉ <hidden> Help for Using Help ΓòÉΓòÉΓòÉ

Select Using help to see information on how to use the help facility.


ΓòÉΓòÉΓòÉ <hidden> Help for Keys Help ΓòÉΓòÉΓòÉ

Select Keys help to display a description about each key you can use in the
active program.


ΓòÉΓòÉΓòÉ <hidden> Help for Product Information ΓòÉΓòÉΓòÉ

Select Product information for copyright information about Ultimedia
Workplace/2.


ΓòÉΓòÉΓòÉ <hidden>  ΓòÉΓòÉΓòÉ

A bitmap is a type of graphics image that is formed by a pattern of dots
(pixels or pels) and stored as on or off bits.  Bitmap image files commonly
have a file extension of .BMP.

The Clipdata object always converts the image form that is passed to it into a
bitmap format.


ΓòÉΓòÉΓòÉ <hidden>  ΓòÉΓòÉΓòÉ

A bounding box is a resizable, rectangular outline used to mark and select an
area of a window.


ΓòÉΓòÉΓòÉ <hidden>  ΓòÉΓòÉΓòÉ

A browser is a program that displays visually-based multimedia files (image,
text, video, story) or that plays sound-based multimedia files (audio).


ΓòÉΓòÉΓòÉ <hidden>  ΓòÉΓòÉΓòÉ

The clipboard is a temporary storage area used to pass information from one
place to another within a program, or from one program to another.  The terms
cut, copy, and paste are most often associated with using the clipboard.


ΓòÉΓòÉΓòÉ <hidden>  ΓòÉΓòÉΓòÉ

A Workplace/2 Clipdata object facilitates image data exchange. It passes images
through the OS/2 or Windows system clipboard.


ΓòÉΓòÉΓòÉ <hidden>  ΓòÉΓòÉΓòÉ

A column is the area of a table into/from which the smallest unit of data can
be entered/read.  Often used synonymously with field, a column has a particular
data type (e.g. character, decimal, or integer) and size.


ΓòÉΓòÉΓòÉ <hidden>  ΓòÉΓòÉΓòÉ

A database is a collection of related information stored in tabular form.  It
can be manipulated to help retrieve information and make decisions based on
that information.  Workplace/2 supports DATABASE 2, OS/2 Database Manager,
Oracle, and dBASE format databases.


ΓòÉΓòÉΓòÉ <hidden>  ΓòÉΓòÉΓòÉ

The Desktop is the portion of the OS/2 graphical interface with which the user
most often interacts. It is an open folder containing all of the other objects
a user can manipulate in his or her view on the screen.


ΓòÉΓòÉΓòÉ <hidden>  ΓòÉΓòÉΓòÉ

OS/2 provides extended attributes as a location for maintaining additional
information about files or objects.  Workplace/2 uses extended attributes as
one of two locations for storing extended data; the other location for extended
data is a database.


ΓòÉΓòÉΓòÉ <hidden>  ΓòÉΓòÉΓòÉ

Extended data is user-defined information about Light Table folder objects.
Extended data includes user-defined columns, and may come either from a
supported database or from extended attributes.


ΓòÉΓòÉΓòÉ <hidden>  ΓòÉΓòÉΓòÉ

A field contains a unit of information about a subject.  A field has
characteristics (e.g. character or numeric data, size, etc.) and a value.

The term field is often used synonymously with column.


ΓòÉΓòÉΓòÉ <hidden>  ΓòÉΓòÉΓòÉ

The value of a field is the information contained in a field.  In a database
table, a field value is the data contained at the intersection between column
and row.


ΓòÉΓòÉΓòÉ <hidden>  ΓòÉΓòÉΓòÉ

A file is a collection of information treated as a unit.


ΓòÉΓòÉΓòÉ <hidden>  ΓòÉΓòÉΓòÉ

A file's extension is the three character suffix, preceeded by a period that is
attached to its name; e.g. "readme.doc" is a full filename including the
extension: doc. File extensions are used to categorize files.  The formats of
Multimedia files are identifiable by their extensions.

In most cases, when OS/2 or Workplace/2 use the term filename or file name, the
extension is considered part of the name.


ΓòÉΓòÉΓòÉ <hidden>  ΓòÉΓòÉΓòÉ

A file name is the name assigned to a file.  It includes the three character
file extension.

In many programs the term file name includes the drive and path
(subdirectories) as well as the base file name and extension.  This may be
called the full file name.


ΓòÉΓòÉΓòÉ <hidden>  ΓòÉΓòÉΓòÉ

File types enable you to associate programs with data-file objects.  You can
then open a program object and a data-file object at the same time by selecting
only the data-file object.

Workplace/2 provides file types for audio, video, text, story, and image files
which are associated with the appropriate browser.


ΓòÉΓòÉΓòÉ <hidden>  ΓòÉΓòÉΓòÉ

A folder is an object that contains other objects.  A folder can be used to
organize objects such as program objects, data-file objects, and other folder
objects.

Double-click on the folder object to display the objects contained in it.


ΓòÉΓòÉΓòÉ <hidden>  ΓòÉΓòÉΓòÉ

A frame is the area surrounding a thumbnail.  It resembles a slide frame.  When
you double-click on an object's thumbnail frame, you open the object's browser.


ΓòÉΓòÉΓòÉ <hidden>  ΓòÉΓòÉΓòÉ

A join is a relational operation that allows retrieval of data from two or more
tables, based on matching column values.

In Workplace/2, a Light Table folder's information is treated as a table.  The
information for objects in one Light Table folder can be joined to information
in other Light Table folders, or to databases.


ΓòÉΓòÉΓòÉ <hidden>  ΓòÉΓòÉΓòÉ

A key is a special field (column) in database records whose value is used to
identify a record from others in the same database.


ΓòÉΓòÉΓòÉ <hidden>  ΓòÉΓòÉΓòÉ

A Light Table folder is a type of folder with special properties for organizing
and viewing multimedia objects and maintaining information about the objects it
holds.


ΓòÉΓòÉΓòÉ <hidden>  ΓòÉΓòÉΓòÉ

An LT Query object is a type of data-file object which holds query information
that is used by the LT Query Sequencer folder to query Light Table folders
and/or databases.


ΓòÉΓòÉΓòÉ <hidden>  ΓòÉΓòÉΓòÉ

An LT Query Result object is a type of data-file object which holds the results
of a query.


ΓòÉΓòÉΓòÉ <hidden>  ΓòÉΓòÉΓòÉ

An LT Query Sequencer folder is a type of folder which holds the components of
one or more queries, and runs them.


ΓòÉΓòÉΓòÉ <hidden>  ΓòÉΓòÉΓòÉ

An LT Reference object allows you to store a file in one location and access it
in another location without duplicating the file itself.


ΓòÉΓòÉΓòÉ <hidden>  ΓòÉΓòÉΓòÉ

A media field is Light Table schema column which displays the thumbnail of the
multimedia object to which it refers.


ΓòÉΓòÉΓòÉ <hidden>  ΓòÉΓòÉΓòÉ

A object is a visual component of a user interface that a user can work with to
perform a task.


ΓòÉΓòÉΓòÉ <hidden>  ΓòÉΓòÉΓòÉ

The term path is used to indicate a file location on a disk storage media. The
path consists of all the directories that must be opened to get to a particular
file.  The directory names are separated by a backslash (\).  The first
backslash represents the root directory.

A path is sometimes followed by a file name and file extension (if there is
one). It is sometimes preceded by a drive letter and a colon (:).

For example, a file named thing that is located in the EDIT directory of drive
C has a path of:

  C:\edit\thing


ΓòÉΓòÉΓòÉ <hidden>  ΓòÉΓòÉΓòÉ

A pop-up menu, when requested, is displayed next to the object that it is
associated with.  It contains choices appropriate for the selected object, or
set of objects, in their current context.  A pop-up menu is displayed by
clicking mouse button 2 on an object or on the desktop.


ΓòÉΓòÉΓòÉ <hidden>  ΓòÉΓòÉΓòÉ

A query is a request for information from a database or a Light Table folder.


ΓòÉΓòÉΓòÉ <hidden>  ΓòÉΓòÉΓòÉ

A row is a horizontal arrangement of related fields.  In a database, a row is
the same as a record or data record.


ΓòÉΓòÉΓòÉ <hidden>  ΓòÉΓòÉΓòÉ

The Safe folder is a type of folder used to store data-objects and folders
selected to be backed up. The Safe folder is used to run OS/2 backup or
recovery.


ΓòÉΓòÉΓòÉ <hidden>  ΓòÉΓòÉΓòÉ

In Workplace/2, the term schema refers to how information associated with
objects in a Light Table folder is structured.  A Light Table folder's schema
defines field characteristics for data kept in its objects' extended
attributes, and if applicable, the characteristics of the database to which it
is joined.


ΓòÉΓòÉΓòÉ <hidden>  ΓòÉΓòÉΓòÉ

The information abouOS/2 file-system information regarding object, including:
title, real name, size, last write date, last write time, last access date,
last access time, creation date, creation time, and flags.


ΓòÉΓòÉΓòÉ <hidden>  ΓòÉΓòÉΓòÉ

A table is an orderly arrangement of data in rows and columns that can contain
numbers, text, or a combination of both.  The term table is often used
interchangeably with database or database file


ΓòÉΓòÉΓòÉ <hidden>  ΓòÉΓòÉΓòÉ

A thumbnail is a representation of a multimedia data file that generally
conveys more information than a standard Desktop icon. A thumbnail is used as
an aid in the selection process.

A Workplace/2 thumbnail is enclosed within a frame which can be used to start
the appropriate browser for the multimedia file it represents.  The browser for
an object is started by double-clicking on its thumbnail's frame.


ΓòÉΓòÉΓòÉ <hidden>  ΓòÉΓòÉΓòÉ

The title (name) of a folder or object is the text that displays under its
icon.