General:

We recommend that the first thing a new user does is explore the system. Open the various modules and look through the notebook pages. Place your cursor in various fields and click the [Help] button. Familiarize yourself a bit with the screens.

After you have checked out the system components a bit, enter your Vendors in the Vendor screen. Build some [Lookup] tables, practice doing lookup and searches. From there, you might want to build data into the Equipment screen.

Oz was designed to be optimal in 800 x 600 x 65K colors. Other resolutions will work, but 800 x 600 is the best.

      5303 *-*   moduleTitle = .Oz!Names~getval('Parts Title')
        17 *-*   call 256_Form.1 2147484033
        17 *-*   Interpret _VpEventCall
      REX0097E: Error 97 running C:\OZ\EXE\PARTS.EXE line 5303:  Object method not found
      REX0476E: Error 97.1:  Object ".OZ!NAMES" does not understand message "GETVAL"

This message indicates that your Multimedia is not installed properly. You should try to correct the Multimedia setup. As a temporary fix, you can edit the Preferences File, BldPref.DAT, using the "Custom" Utility in the \Oz\ENV Folder. Find the four "Say..." parameters,

SayWarning
SayWorking
SayNoItemsFound
SayAreYouSure

Change these values to 0. Be sure to set them back to 1 after you fix your Multimedia setup.

Sometimes it seems that the system "hangs," that is, it displays the "Wait" cursor. This happens when you make a change to a record, such as a Part, while at the same time making another change to the same record, such as issuing a Purchase Order from the Requisitions screen on the same Part.

This can easily be remedied by clicking the [Save] button on the screen you are changing, such as the Parts screen before issuing the order. Sometimes you might have to close one or more screens. As a last resort, use the Window List (Ctrl-Esq) to bring up Oz and shut down, then start again.

Enter the date field you wish to search on. When the Voice Calendar pops-up, choose the [Between] button, select a date and accept it. Then go back the the field, pop up the Calendar, choose the [And] button, select a date and accept it. The date field will contain something similar to

[01/01/1998,12/31/1998]

The square brackets indicate a range of dates on which to Search. Choose "Search" and you will see the selected data.

You could have specified "Before" or "After" a specified date as well.

When you see the + sign on an Oz icon, it indicates that this is a folder as opposed to a single program. Folders may contain several "program files".

The database requires that dates be in the correct format, even if you have not specified a date. Therefore, any date of the form 01/01/0001 may be treated as a blank, or unspecified date. Do not worry, just ignore these.

The Utilities folder contains the following programs:

The Inventory folder contains the following programs:

The Work Orders folder contains the following programs:

Look for the vertical blinking bar. If you place the cursor into a field and click, that field should have the focus. Or, if you are using speech, the focus field will be surrounded by a blue box.

No. The only fields that are absolutely required to be filled in are the "key fields" which are usually the identification fields. If you fail to fill in a field that is required, the computer will let you know.

Data is not entered into the lookup table automatically. You have to build lookup tables for each field.

You can type a few characters into one or more fields and use the [Lookup] and [Search] functions.

The [Remove] button removes the record from the database container, not just the Entry field. In order to remove a record from the [Entry] field, you need only highlight it and press the [Delete] button or you could merely backspace over it.

You do not type directly into the container. You add items to the container by typing the information into the fields directly below the container and pressing the [Add] button.

If you are in the container, pressing the mouse button 2 will open the container so that you can view additional entries. If you continue to click button 2 while in the container, the container will continue to expand until it reaches the bottom of the window.

If you make a selection from the container, it is reduced to its original state. If you do not wish to make a selection, you can merely double click with mouse button 1.

It is possible to bounce between the pages of the notebook to make changes in a record in the container. However, if you are making changes to more than one record in the container, you must press the [Change] button before you go into a second record for the changes to take affect on the first record.

Yes, you can change the number of items that are displayed. This can be done in the preferences by setting FETCH_LIMIT to the desired number. See the "Custom" utility Fetch-Limit.

Use "Lookup" to fill a field; "Search" to find records in the database.

If you do a Search after using the [Clear All] button, all available items will be found.*

*By default, Oz displays only the first five items found.

If you have already created records, but have not created the Lookup tables, you might perform a [Search] and then select your table entries from the records. For example, if, [Schedule Handle] in the container, you have "Weekly", "Monthly", "Quarterly", "Yearly" and "As Needed", you could enter these categories in the Lookup table for [Schedule Handle]. You could do this under any field name to build that field's Lookups.

Yes, if you prefer you can. This can be done in the preferences by setting the "autoCalendarPopup" to 0 (zero). See the "Custom" utility.

These are fields that you are not allowed to change.

If you check help for any field, you will be able to see how many characters are permitted for that field. If you are using a small font size, it may appear that more characters will fit, but the database is set up to accept only a certain number of characters. There are many fields available to you in the program where you can enter whatever data you wish.

The [Remove] button will remove the record from the database that is highlighted.

You already have a help window open or you have another window, such as the Calendar, Calculator or Lookup open that must be closed before any other action can be taken. Open the window list to find it, if the window is hidden under another window.

Activating the [Undo] button will undo all of the changes you have made to the DataBase (the data in the container) since your last Save. (In addition to using the [Save] button, a save is done automatically when you exit a program)

Undo does not undo keystrokes you enter into entry fields in the notebook, but no changes are effected until you click the [Change] button. If you inadvertantly make a change to an entry field in the notebook, you could switch to another record and then come back into the record. All changes you have made to that record that have not been changed or saved will be lost if you do this.

CAUTION! Be careful using the [Undo] button. The Undo function will delete any changes you have made since you started the current session or since your last [Save] or [Clear All]. If you wish to undo changes to the record that you are currently working on, merely switch to another record in the database container without pressing the [Change] button and then switch back to the first record.

The lookup begins at whatever characters you entered in the field (alphabetically).

Click [Clear All] twice. You can then enter characters in these fields for search purposes only.

These are fields that you are not allowed to change.

You probably used the [Remove] button. In order to delete data in any field, you should use the "Delete" or "Backspace" key on your keyboard. Using the [Remove] button always removes the entire record after asking for confirmation.

No. You must use the [Change] button to save any changes you have made. The [Refresh] button deals only with the relevant pages of the notebook; not with the data contained in the database. The [Refresh] button will cause the system to perform any recalculations made necessary by any changes you have made.

The focus must be on a field which has a "Lookup" function. A few fields do not have this function.

Buttons are greyed out when they are not available for use. For example, the [Undo] button is greyed out until you make a change. Then you are given the option of undoing the change you have made.

After you make a change on the notebook, you must press the [Change] button in order to make the change permanent.

You are in a date field and have the autoCalendarPopup preference set to "1"; If you set it to "0", the calendar will not pop up automatically when you enter a date field.

Yes, absolutely, and this is a good idea if you want to narrow your search.

Of course! You can merely type any letter and the program will find any items in the lookup table that begin with that letter and any items that begin with letters that follow that letter. If you want to be more specific, you could also search by the first few characters such as Mac, or Mc.

If this happens you should use the [Clear All] button. What you described will happen if you have opened the screen housing the container using search criteria on another screen and nothing was found meeting that search criteria. If you merely press the [Search] button again without pressing the [Clear All] button, the system will still be looking for the original search data.

Yes. but you must perform the [Clear All] function twice.

These fields are maintained by the system and the user is not permitted to change the data contained in these fields.

If you perform a Lookup on these fields, the Calendar is opened.

mm/dd/yyyy. It is a good idea to use the Lookup to bring up the Calendar since using the Calendar will always bring the date into the entry field in the expected format and can save you a lot of grief.

The [Entry] field in the Lookup table is a key field and cannot be changed. It is possible to delete an entry and create a new one with the correct spelling. If, however, you have already generated schedule records using this misspelled entry, you may not want to delete it since you will not be able to use the Lookup feature to search for those entries.

Or, you could always create a corrected Lookup entry; Delete the erroneous entry and do a mass change on the records that were created using the the entry with the error.

Yes. %. However, the system has built in wildcard criteria so that if you search for a combination of letters and the combination appears anywhere in the name, it will be found. For example, you could search for "un" and the program would find Ounce of Prevention, if it is on file. Use of the built-in wildcard criteria is a default preference and can be turned off. If it is turned off, your searches must either be exact matches or you could use the %.

If you have a lot of data, you might want to turn this preference off in order to narrow the records which are found.

If you have built Lookup tables, these can be used to fill in search criteria. It should also be noted that you can use just the first letter or two to start a search.

The system was designed to save you time and unnecessary typing and data entry. There are several explanations for why data appears in fields where none was entered.

First, many of the fields in Oz are calculated from data that is entered into other fields.

Second, there are fields that have default data supplied if none is entered.

Third, if you do not perform a [Clear All] function and data remains from a previous record in the entry fields when you create a new record, that data is used for the new record. This can be very handy if you have records that use much of the same data; you can bring up a record, change only what needs to be changed and then create an entirely new record from the old one using the [Add] button.

Yes.

The tab key moves you from field to field. The up arrow key moves you up a field and down takes you down one unless you are in a 'memo' field. Click with the mouse button 1 once to open a tab.

DO NOT TRY TO USE THE ENTER KEY TO MOVE FROM FIELD TO FIELD. The enter key does not move you from field to field.

Once you have found the record you wish to delete, highlight it and click the [Remove] button. The system will prompt you to make sure you want to continue.

After you have pressed the [Add] button to add the first record, use the [Clear All] button to clear all fields and repopulate them with new data. Or, if you wish, you can leave the data in the fields and merely change the data in those fields which must be changed.

Enter search criteria in one or more of the fields and press the [Search] button; or, press the [Search] button with all fields empty to search for all records. When the search list appears, click with your mouse button 1 on the record you want to change. This will bring the record up in the notebook section of the screen. Make the changes in the appropriate fields, then click on [Change] to accept the changes.

While still on the record select the [Undo] button, the screen will clear and your changes will be undone.

Position your cursor on the field you want to add lookups to, click with mouse button 2. You can add as many as you want. Entry is the value that will go into the field, meaning allows you to enter a more complete description.

Highlight the entry you want, use the [Accept] button.

There is a file in the \Oz\Env folder called Monitor.CMD. When this file is moved into the \Oz\Auto folder, it will be started when you bring up Oz. It looks for the existence of a file, called EmergWO.TXT, in the \Oz\Auto folder. This file contains instructions for generating an emergency WO. A sample EmergWO.TXT file is also contained in the \Oz\Env folder.

Monitor.CMD will bring up the Active Work Order program and create an emergency Work Order based on information in the EmergWO.TXT file.

Thus, if your monitoring devices are able to create an EmergWO.TXT file, the monitoring process will be activated.

You can, of course, customize the Monitor.CMD program and the EmergWO.TXT file to suit your own needs, or we can customize this process for you.

Speech:

Oz is the first CMMS that is 100% speech-aware.

To use Speech, first you have to Enroll:

Speech Enrollment:

Open the OS/2 Programs Folder on your Desktop

Open the Voice Type Folder, the select Enrollment.

Create a User Name, choose the option to place the user's Speech icon on the Desktop.

Select Enroll:

First do Navigation (50 Sentences only). After Navigation, back up your speech data.

Second do Dictation (50 Sentences only). After Dictation, back up your speech data.

Double-click on the user's Desktop Speech icon. This opens the Voice Manager window at the bottom left of your desktop. You can right-click this window to set the properties.

You can speak "Switch to Programs," "Open Inventory"

If several Oz programs are running, such as Parts, Equipment and Vendors, you can say "Switch to Parts," or "Switch to Vendors," etc.

In an Oz program, you can speak "Lookup" in a field, or "Help" or "Clear All" etc.

You can say "Close" to close a program. You can say "Container Scroll Right" or "Container move down three."

If your Oz Handles are recognizable words, you can speak them, and the appropriate record will be selected from the container.

If you are in a Date Field, and you speak "Lookup," the Voice Calendar will open. You can speak the month, day or year, such as "February 27 1995" Or just the day, "27" or "February." You can speak "Yesterday," "Today" or "Tomorrow." Say "Accept" and the date will be returned to the field.

If you are in a Numeric Field, and you speak "Lookup" or "Calculator," the Voice Calculator will open. You can speak numbers or expressions like "one - two - three - point - four - five - times - one - point one - zero - equals" and the calculation will be performed, just like a real calculator. Say "Accept" and the result will go to the field. The Voice Calculator also has memory "Save" "Recall" and "Clear" options, which you can speak.

Our prediction is that speech will seem a bit uncomfortable and unusual for you at first, but once you get used to it, you will begin to hate the mouse, using it less and less.

IMPORTANT: After you have Enrolled the first 50 items in Navigation, the computer will tell you that you have done enough. This is all you need to do. It shouldn't take more than 20 minutes, but we recommend that you BACKUP your Speech Files after this.

Same thing with Dictation; you only need to do the first 50 items. This will take a bit longer. BACKUP again after this step.

The whole Enrollment process shouldn't take more than 1 hour.

The Computer button allows you to dictate free text that goes into your Entry Fields.

Use it for large fields, suct as Comments, Instructions, Remarks, etc., or for your various Supplementary Work Sheets, Equipment Sheets, etc.

For an example, open the Vendor Program and find a Vendor, then go to the Comment Field. Speak "Computer."

This button switches you to the Dictation Window. You will see a message "Begin Dictation." Just speak whatever you want, slowly and distinctly at first. Say something like "This - Vendor - is - a - leading - supplier - of - paper - and - packaging - products - for - commercial - and - industrial - use."

When finished Dictating, say "Stop Dictation," then "Send." The results of your Dictation will be pasted into the Vendor's Comment field.

If you Edit a Sheet, such as the Vendor Sheet, and want to dictate, just say "Begin Dictation" and you can dictate the whole sheet.

Yes it will. Make sure you get a good noise-cancelling microphone ($85 - 125). Also make sure that you Enroll in the same environment that you intend to use Speech. IBM's VoiceType Dictation knows how to compensate for noisy environments.

Navigation in Oz will work very well. If you want to impress your boss, hand her the mike and tell her to speak some of the Notebook Commands, Entry Field Titles, etc. She will be amazed.

Dictation is another story. Dictation is very user-sensitive. If your boss says "Computer" and enters the Dictation Window and tries to dictate, you will both have a good laugh at the results. Of course, the laughter itself will be interpreted as speech, making it even funnier! You will probably have to use the mouse to Stop Dictation.

Your boss will have to Enroll and set up her own Dictation icon.

Speak "go to sleep" and the Speech system will go dormant until you speak "Wake up please."

You could also speak "Microphone off" and the Speech will go off. You need to click on the icon in the Voice Manager window to re-activate it.

Ad Hoc Reports:

The Ad Hoc Reports program supplied with Oz is a mini version of V Trex Information . . . at your COMMAND! The Ad Hoc Reports program, like all components of Oz, is voice-enabled; It provides you with an easy way to access the data in the database using natural language. Using this program, you can produce your own custom queries. With the Ad Hoc Reports program there are no SQL commands to learn; you use natural-language words and phrases. With this program you can print reports or write your data to disk.

This program has its own online help.

Colors:

By using the Colors program, you are able to change the color properties of the Oz screens and screen components. You can use any of the preloaded schemes or you can customize a color scheme or schemes of your very own. Although you can save color schemes, the color changes made to the screen are only saved during the current session. Whenever you close Oz. the default color scheme is reapplied.

The changes you make to colors on the screen only last for the current session. Once you close Oz. the colors revert to the default (BlueJeans)

In order to change the colors for a session, click on the "Colors" icon. Select a color scheme from the container and press the [Apply] button. Any window that is currently open will not be affected; Any window you open after taking this action will have the new color scheme. If you close the unaffected window that was open and reopen it, it will have the new color scheme. It is possible (and easy) to open many windows and have each one have a different color scheme.

Yes. In the Colors window, click the [Clear All] button; click on the [Get Colors] button to open the GerColor.Exe program. Move the red, green and blue dials to get the color you want, specify a font, (a right click in the font entry field will bring up the available fonts) Click the [Set] button; click the [Copy above spec for pasting] button; In the Colors window, click in the Windows Properties or Button Properties entry field and Click the [Past Colors] button. You can then name the color, give it a description and add it to the container for future use if you wish.

Equipment:

The Equipment program is where you build your data on each piece of equipment. "Equipment", here, is a very broad term meaning anything that you need to maintain." This, of course, could be machinery such as presses, pumps, conveyors, sewing machines, computers; vehicles, such as trains, boats, planes, cars and trucks, or something that most people don't equate with "equipment" at all, such as elevators, buildings, zoos, mines, parks and grounds or schools.

Your equipment might be made up of components as well as parts. For example, if you list a truck as a piece of equipment, you might enter the engine as a component and spark plugs as parts.

The Equipment screen looks much like the other screens in Oz. The upper portion of the screen has a container which enables you to see data contained in the database. The lower portion of the screen contains a notebook of pages of data that relate to individual pieces of equipment contained in the database. Additions and changes to data cannot be made directly in the container, but must be made through the notebook.

On the right-hand side of the screen are buttons which perform various functions when pressed.

Enter all of the information you want to include into the entry fields on the various pages of the notebook and press the [Add] button. The entry will not be added to the database until the [Add] button is activated. You can add as many pieces of equipment as you wish, pressing add after each piece of equipment. In order for the changes to be made permanent, you must press the [Save] button. IF YOU EXIT THE PROGRAM, THE CHANGES WILL BE SAVE AUTOMATICALLY; NO PROMPT WILL BE ISSUED.

A component could be classified as any "piece" of the "equipment" which is made up of smaller parts, but could also be something that could be completely replaced as a whole. For example: Each engine on a twin-engine plane. could be considered a component since each engine is a unit in itself made up of parts. It is possible to replace parts of the engine, but it is also possible that you might replace the entire engine.

Pressing the [Parts List] button will open the "Parts" Window. Using the [Parts] button enables you to work in the parts window "on-the-fly".

Pressing the [Components] button will open the "Components" Window. Using the [Components] button enables you to work in the components window "on-the-fly".

When you enter the parts window, all of the parts used by the chosen piece of equipment will be displayed in the container. If those parts happen to be used by additional pieces of equipment, those pieces of equipment will show up in the [by equipment ID] field of the parts window.

When you make a change in the Equipment Window to the [Description] field the change is not made in the Parts window. Deleting the original name in the [by Equipment Description] field on the Parts Screen and pressing the [Change] button, will get rid of the original name.

Labels:

This is because the Number of Lines specified on the Parameters Page of the Labels Program does not match the Number of Lines defined by the Report Name. Change the Number of Lines and the DATA.i.LINE_x values will go away.

The Labels program enables you to generate labels in various stock formats.

This will seem very complicated to read, but you will see when you try it, that it is indeed quite simple and intuitive.
Follow these steps:

1. Open the Labels program.

2. Do a [Search] to see if an existing Label configuration can be used. If so, you might want to make changes to it. If not, you can make an entirely new label form.

3. For a new form, press [Clear All].

4. Enter a Handle (it must be unique), and a Description, eg.,

           Handle:On Hand        Description: Parts On Hand
   

5. Choose a Table where the Label information comes from. You can click button 2, or [Lookup] to select a Table from the list, eg.,

           Select Parts.DAT from the lookup, gives Table = Parts
   

6. Choose a Report Name by clicking button 2. At present, there are three label report templates to choose from:

        AVY_5260.VPT - Avery 5x60 1" x 2 5/8" (6 lines per label, 3 x 10 per page)
        AVY_5261.VPT - Avery 5x61 1" x 4"     (6 lines per label, 2 x 10 per page)
        AVY_5262.VPT - Avery 5x62 1 1/3" x 4" (6 lines per label, 2 x  7 per page)
   

7. On the Parameters Page, click 2, or [Lookup] to build

        Where: OnHand > 0
   
        Sort By: StorageLocation Asc
   

8. Set the Number of Lines to 6.

9. Set the number of Copies of each label.

   This can be a fixed number, such as 1 or 7. It can also be a variable from the Data Table, which you can build by clicking mouse button 2, eg.,

        Copies of each label: OnHand  
   

   CAUTION: This might cause thousands of labels to be printed. You might want to include "AND OnHand <= 25" in your "Where" Condition.

10. Go to the "Lines" page of the Notebook. You should see 6 blank lines. If not, go back to "Parameters" and set Number of Lines to 6.

11. At the bottom left of the "Lines" page, you will see a button, with a caption "Open Parts" or "Open Vendors" etc. Click this button, or speak "Open Parts."

    This will open the appropriate Table. You will notice a button,

                        "Capture"
    

    on the screen. Here's how you use it:

    a. Find the field you want on the label, such as "Part ID." Click in the "Part ID" field, or speak "Part ID." It will get the focus.

    b. Click the "Capture" button, or speak "Capture."

    c. Switch to the Labels Program, place your cursor in Line 1 (or speak "Line 1").

    d. Click "Place" or speak "Place" or double-click in the line to place "PartID" in the first line.

12. Switch to the "Parts" program, place your cursor in "Part Description," then "Capture."

    Switch back to "Labels." Place the cursor in Line 2, then "Place."

13. Continue "Capturing" fields from the Table and "Placing" them in your label Lines.

    NOTE: You can edit a line by Alt-clicking on it. You can then use the arrow keys, Delete key and Insert key to enter changes. You can cut from one line and paste into another this way, too.

    After you make a change, click once on the edited line, then just to be sure the change took, click on a different line.

    NOTE: You can insert literal strings on the labels. Just edit the line as described in the note above, and Insert your literal, surrounded by double-quotes.

    For example, if you want a colon between the Warehouse and Storage Location, you would have on the Line,

                    Warehouse,": ",StorageLocation
    

14. After Capturing and Placing your fields, select the "Run" tab on the Notebook page.

    You might wish to "Preview" the labels first. This will display a few labels on the screen.

    When you are satisfied, choose "Run." The "Report" Menu option will allow you to Print the labels.

Labor:

The Labor program is where you keep track of who works on each piece of equipment.

You can build separate records for each person who performs labor with that individuals rates, skills, education, what equipment they work on, and employee information such as time, starting date, vacation time, etc.

The Labor screen looks much like the other screens in Oz. The upper portion of the screen has a container which enables you to see data contained in the database. The lower portion of the screen contains a notebook of pages of data that relate to individual employee or contractor contained in the database. Additions and changes to data cannot be made directly in the container, but must be made through the notebook.

On the right-hand side of the screen are buttons which perform various functions when pressed.

Parts:

The Parts program is where you build your data for parts belonging to each piece of equipment in the Equipment file. Parts are used to repair or maintain equipment and are listed in Work Orders. A "Part" could be something like a gasket or could be something more general such as oil for lubrication.

You also use the Parts program to make requisitions, purchase parts, and review purchases, requisitions and receipts.

Parts can be associated with the equipment on which they are used.

The Parts screen looks much like the other screens in Oz. The upper portion of the screen has a container which enables you to see data contained in the database. The lower portion of the screen contains a notebook of pages of data that relate to individual parts contained in the database. Additions and changes to data cannot be made directly in the container, but must be made through the notebook.

On the right-hand side of the screen are buttons which perform various functions when pressed.

The switch button switches the Preferred Vendor with Vendor Alternate 1 or 2, whichever had the focus last. In order for the [Switch] button to work, one of the entry fields must have the focus. It is possible that the very first time you come into this screen after the program is opened none of the fields has the focus. You set the focus by clicking in the field.

Key fields are very important for searches. Warehouse is an important criteria if for example, you have two garages and each uses the same parts but has its own inventory of parts in its own physical location.

Yes.

Yes.

If you add new parts or make changes to the "Handle" the added items and the changed items appear at the bottom. When you refresh by clearing all and doing a search, these items will be in their proper alphabetic order.

To find low items for a category, use [Clear All] button to clear the container, then either do a Lookup or type the category information (example: <2 in the [On Hand] field or "Pump" in the [Handle] field) and press the [Find low items] button. This would give you only low pumps or only records with less than 2 items on hand.

If you do a [Find Low Items] with nothing specified in the entry fields, you will get all records with low items. If there is data in the container when you perform the [Find Low Items] function, the container will be cleared out and repopulated.

This field is available should you wish us to customize it for you.

You add items to the container by typing the information into the fields directly below the container and pressing the [Add] button.

You DO NOT add a part to a piece of equipment in the parts window. You add a "place where the part is used" in the [by Equipment ID] field. When you add equipment to the [by Equipment ID] field, you must press the [Change] button to have the effect take place.

Yes. You can enter multiple selections into the Equipment ID field

When you highlight a part in the container, all equipment that uses that part will be displayed in the [by Equipment ID] field.

You CANNOT change the data in the [ID] and [Warehouse] fields once the record has been added. What you can do is: Using the original record that you wish to change, change the information in the [ID] and [Warehouse] fields to read the way you want it to read, then press the [Add] button. This will give you a second record with the correct information. Now you can delete the original record by highlighting it and pressing the [Remove] button.

You can right click on the equipment handle field and select one equipment number or highlight a selection of equipment numbers to link together. The equipment ids, handles and descriptions will be separated by semicolons.

Reports:

The Database is case-sensitive. You can convert a term to upper-case, thus removing the case-sensitivity, by using the built-in Database function TRANSLATE. When you use the automatic condition builder on your reports, Oz generates this function for you.

By using the Reports program, you can get many standard reports which you can use "as is" or customize to make your own versions.

On the Run page of the Reports program click mouse button 2 in the Output field. This displays a pop-up of defined output devices. Choose your printer and click Accept.

Exporting data is done by choosing the FILE output device. When you choose FILE from the Output lookup, a window opens on the Run page of Reports. You can choose database table fields from a lookup list of fields for this table.

NOTE: You must choose a table in the Table field before this lookup will work.

If you are exporting an existing report, the Table Fields window will already have the appropriate fields. You need not change these fields.

IMPORTANT: If you change or remove fields from this list your standard reports may not function properly. For this reason you cannot save changes to built-in Standard Reports.

In the printed report, we combine certain fields to save space. These fields are not combined in the exported report.

The Oz preference ExportFixedFieldLength can be set to 1 (true). This will set each value to the length of the field (with trailing spaces).

NOTE: It is a good idea to change the field separator and text delimiter to the word "BLANK" enclosed in <>.

These Oz preferences are:

When you choose FILE: as an output destination, you should include a fully-qualified filename for the exported data. If you do not specify a filename or path the Oz preference ExportDefaultDestinationFolder will determine where the file goes, and ExportDefaultDestinationFilePrefix will determine what the file will be called.

Oz will use your prefix and add a five digit unique number and a .TXT extension. If you specify a filename only, the filename you have chosen will be used and stored in the ExportDefaultDestinationFolder folder.

The Oz preference ExportFieldSeparator can be changed to a single or multiple character value to be used as a separator. This value, however, cannot start with an @ symbol. This value should be set to for fixed length field exports.

The Oz preference ExportTextDelimiter can be set to a single or multiple character value to be used as a text delimiter. This value, however, cannot start with an @ symbol. This value should be set to for fixed length field exports.

NOTE:If you want your text to be delimited with a double quote("), the preference ExportTextDelimiter should be set to " (one double quote) not "" (two double quotes). Only one character is needed.

Oz allows you to add literal strings to export files. These literal strings will not appear on printed reports. To add a literal string to an export file, add your literal string in the field window of the Run page in Reports as if it were a regular table field. You must delimit the string with single quotes. For example; if your current field list looks like:

'EAST15205', EquipmentID, EquipmentHandle, EquipDescription, System, SerialNumber

the string:

`EAST15205`, EquipmentID, EquipmentHandle, EquipDescription, System, SerialNumber

will also work since the saved database values will be converted from "'" to "`".

Some fields are used to calculate others. For instance, the JobDate field is needed to calculate how many days have expired since the job was scheduled. JobDate may not appear on the report, but the calculation will.

First, try the same report in PREVIEW mode. If the report still fails, check that the report name is a valid VPT file. If the report works in preview mode check your printer connections and output destination.

A VPT is a report template file created in Hockware's VisPro Reports. These files are used to layout the data in a set design.

The buttons on the Category page group reports into like categories. You may define the criteria for these buttons to create your own groupings. For instance, You may make a button for a single employee (Jill) or a job category (Plumber). Now Jill can press this button to get all of her reports.

The BldPref file contains fields like REPCUST1BUTT. This field lets you define an SQL statement to limit the reports which will be displayed when the button is clicked. Look at other field definitions like REPVENDBUTT to see how these conditions where built. In the case of REPVENDBUTT, we are looking for all reports which have the string VEND as a part of thier table name.

To change the text on the button, change the value of REPCUST1 in BldNames.

You may choose the HTML option fromthe output window. Follow HTML: with the filename for export. Be sure to use an extension of HTM or HTML.

HTML exports must have an extension of .HTM or .HTML. This extension is the key to Oz that you want the report formatted for a web browser.

You may change the files HTMLPRE.TXT and HTMLPOST.TXT in the INIDATA folder to change all HTML reports. If you want to change the output of just one report see below.

You can change the size of the HTML report font by setting the preference HTMLDataFontSize in the Pref file.

Using the method template_HTML in the CustLib.CMD command file, you can customize the output of a particular HTML report. Follow these steps:

1. Obtain the Handle of the report you want to change. This is the first field in the Reports program. eg; EquipByID
2. Open the command file CustLib.CMD for editing.
3. Locate and copy the method template_HTML.
4. Paste the method and rename it to _HTML class. eg; ::method EquipByID_HTML class
5. Edit the method as necessary. Help in Object REXX can be obtained via the book Object REXX by Example by Aviar, Inc.

You must include table fields in the Table Fields window. See above for information on accessing the Table Fields window.

Certain reports were designed for landscape printing. If this is so, a text message will appear beneath the Output field asking you to output them as landscape. Trying to print these reports on standard 8 1/2 x 11 paper will result in lost data. However, if you have a wide carriage printer, these reports will print fine.

If the report template (the VPT file) starts with the letters LND_ the Reports program will advise you to print the report in landscape mode. Report templates are stored in the RepForms folder of Oz.

1. Try running the report in PREVIEW mode. If this works, there is a problem with your output device.
2. Check that the date range (if applicable) is valid.
3. Check that the VPT file is valid. VPT files are stored in the RepForms folder of Oz.
4. Try exporting the file to the desktop, then look at the export. If this works there may be a problem with your output device.

Schedule:

If you add a new Schedule Record with the same "Schedule Handle" AND "Job Handle" the Labor, Parts and Tools data will be copied to the newly added record automatically.

Make TWO Schedule Records, one for Monday and one for Friday. Use 1 Week for the Interval on both.

Sure, just make your [Hours, Miles Between PMs] a Negative number. You will get a warning, but just ignore it. This will handle "Countdown" Scheduling.

Use the Schedule program to schedule PM jobs, to generate Work Orders, to review Open Work Orders and to review Work Order History.

The Schedule program is tied in directly to the Equipment, Labor, Parts and Tools programs and these programs can be opened from within the Schedule notebook "Equipment" and "Resources" pages.

The Schedule program has fields for estimated time, labor and parts costs, as well as meter information and many custom fields which you can use to store whatever data you wish.

The schedule program is also used to produce the 52-week and one-month reports which are "projective" reports.

The Schedule screen looks much like the other screens in Oz. The upper portion of the screen has a container which enables you to see data contained in the database. The lower portion of the screen contains a notebook of pages of data that relate to individual jobs contained in the database. Additions and changes to data cannot be made directly in the container, but must be made through the notebook.

On the right-hand side of the screen are buttons which perform various functions when pressed.

Yes, this is possible. If you wish to do this, you should contact Technical Support. You should be aware, however that the [Job Description] field is only 35 characters and if you have more than 35 characters in the meaning, it will be cut off at 35 characters.

If it is truly a "one-time" only job, you should probably not go through the "Schedule" screen, but should make the work order using the Active Work Order screen. However, if it is a job that may need to be performed again sometime, you might want to make a special category in the [Schedule Basis] called "On Demand" or "As Needed". If you do this, you will have to put some number in the [Interval] entry field and either Weeks or Months in the [Period] entry field since these fields may not be left blank.

If, when you built your parts, you completed the [Where Used] section of the notebook, anytime you schedule a job, or, generate a work order or store room requisition which matches the [Where Used] criteria, ([Equipment Handle], [ID] or [Description]), that part will show a *. This is to alert you to the fact that these are parts which you have indicated are used for this particular job. This makes these parts very easy to find if you have many parts on record.

These buttons are only "active" when a record in the database container is highlighted (selected) since they get the labor, parts and tools for a specific record.

The [Search] button on any of the Resource screens ([Labor], [Tools], [Parts] opened through the Resource page of the notebook) will find only those parts which you have added to the schedule or work order of the current record which is consistent with the way the [Search] button works throughout Oz.

A [Lookup] on any field will bring up all of the available values if all of the fields on the Resourse screen are blank. (These tables do not have to be built, since the system uses the [Labor], [Tools] and/or [Parts] tables from the database.) You may have to use the [More] button if there are more values than the container is set up to accept.

It is important to remember that the Resource screens, ([Labor], [Tools], [Parts] opened through the Resource page of the notebook) are always assigned to a specific record.

The only field you absolutely must fill in is [Interval], but why would you want to do that? The current day and date will be defaulted in, "Standard" will be defaulted in as the [Schedule Basis], and "Weeks" will be defaulted in as the [Period].

Enter values of Schedule Basis for which you want to generate work orders into this field. Typically, this would be the *standard* schedules, but you may wish to select any of your special event-driven values.

If you build criteria into the table, such as Emergency, One-Time, etc., you can get these from the Lookup table. It is possible to specify more than one schedule basis in this field and the Lookup table will permit you to select as many items from the table as you wish; you should be aware however, that this field has a character limit of 100.

Note: Meters are always checked no matter what you specify here so that if a meter-based work order is due, it will be generated.

Yes. When you perform this function, a field will appear on the bottom right portion of the screen which will show how many work orders have been scheduled.

Click Mouse Button 2 on the Period field to toggle between Weeks and Months.

You must first click the ADD button to create this schedule before you can add resources to it.

Although you can leave these fields blank, it is not recommended that you leave both blank. When you are in the Active Work Orders, the [Schedule Handle] does not appear anywhere in the database container. Therefore, if you are identifying your job merely by what you have in the [Schedule Handle],you will have difficulties.

Tools:

The Tools program is where you build your data on the tools used to maintain your equipment.

Tools can be associated with the equipment they are used maintain.

The Tools screen looks much like the other screens in Oz. The upper portion of the screen has a container which enables you to see data contained in the database. The lower portion of the screen contains a notebook of pages of data that relate to individual tools contained in the database. Additions and changes to data cannot be made directly in the container, but must be made through the notebook.

On the right-hand side of the screen are buttons which perform various functions when pressed.

Vendors:

The Vendor program is where you build and store your information regarding the vendors from whom you make purchases.

Vendors can be associated with parts and equipment.

The Vendor screen looks much like the other screens in Oz. The upper portion of the screen has a container which enables you to see data contained in the database. The lower portion of the screen contains a notebook of pages of data that relate to individual vendors contained in the database. Additions and changes to data cannot be made directly in the container, but must be made through the notebook.

On the right-hand side of the screen are buttons which perform various functions when pressed.

Since the system always uses the "Preferred" Vendor, the only way you can use an "Alternate" Vendor is to use the [Switch] button to switch the data between the two fields. Whichever field "has the focus" when the [Switch] button is pressed is the field whose data will be put into the Prefered entry field.

You can enter telephone numbers with dashes. We do not format the field since with the global market the phone country codes and international codes might be used.

Bar Code Processing:

This program reads files produced by a Bar Code device. It updates the Parts Inventory by reducing the On Hand Quantity.

It also attaches the Parts used to the Work Order under the "Parts" section of the "Resources" page.

By default, the Bar Code files should be downloaded into the \Oz\BCFiles folder. The files should contain three fields per line (record):

The format of the files is specified in Utilities - Custom - Preferences. You can modify the Bar Code Entries, located under the heading "Bar Code file preferences."

You can specify the beginning column and length for each of the above items.

Although the On Hand Quantity is updated instantaneously, other Inventory fields, such as last date used, yearly costs, etc., are not updated until the Work Order is completed and moved to history.

Note that the Work Order Number is Barcoded right on the Printed Work Order.

After you "Process" a bar code file, the program will display the results. If there were errors, you can edit the file, fix the errors and process it again. This will not re-process any lines which were OK, only those which you fixed.

For your own records, we recommend that you "Print" each Bar Code file after you have processed it.

Bar Code updates will show up in the the "Reports" program under "Requisitions - Storeroom Requests," identified as Bar Code records.

Closed POs:

This program stores historical PO information. You can use it to search or print reports, but you can't change anything.

No, you must add the part in either the Parts screen or the Requisition screen before it can be added to the Closed POs program.

Yes, as long as it has not yet been moved to Closed Out Purchase Orders.

Enter Physical Counts:

This program was designed to assist you in reconciling your actual physical inventory with the records of inventory stored in the system.

The steps for using the Physical Inventory program are:

1) Generate and print the "Physical Inventory Worksheets" from the Reports module.
2) Count your parts and use the Physical Inventory Worksheets to record the actual physical count.
3) Open the Physical Inventory program by clicking on the Enter Physical Counts icon.
4) Press [Start] in the Physical Inventory screen. Use Physical Inventory Worksheets to determine if the actual counted inventory matches the data in the system. If the actual counts do not agree with the data in the computer, press the [Wrong] button; you can then change entry and make a note in the [Comments] field explaining the discrepancy, if you wish.

You can stop at any time and by pressing [Restart], you can pick up where you left off.

After you have finished going through the inventory, you can run the Descrepancy Report found in the Reports module under Parts List.

PO Details:

Once you Receive an item, the PO becomes automatically Finalized. You can't make any changes after that.

The current date is entered into this field by default to save the user typing and should you wish to use the [Auto Receive] button on the Order page of the notebook. The system will not show the item received until the [Receive Item] button on the Receive page or the [Auto Receive] button on the Order page is clicked.

PO Header:

Yes, as long as the record you are attempting to change has not been [Finalized], [Closed] or [Cancelled]

Default data is entered into these fields when a PO is generated. This is done to alert you to the fact that you can customize the custom field headers if you wish to.

Print Purchase Orders:

Receiving:

In the Receiving module, you can search by the Part's [Handle], [ID], or [Description]. You can search by [Manufacturer], or [Manufacturer Part Number]. You can search by the Vendor's [ID] or [Vendor Part Number].

On the Receive page, you can search by a [Due Date] range.

If all else fails, you can specify [Quantity Due] as >0. This will find all items which are not fully received.

Yes, just specify the relevant information on the Receiving screen [Open PO Details]. Even though there is no PO, you can go to the Receive page and Receive the Item.

Yes, just specify the relevant information. A record of the receipt will be created, but no Inventory update will be done.

Easy. Just enter a NEGATIVE number in the [Received] field on the Receiving Screen. The computer will ask if you are sure you meant a negative number. Just ignore this message. Then you can RETURN the items. All appropriate files will be updated.

Requisitions:

You can't add a record directly in the Requisitions Screen. You have to Requisition Parts in the Parts screen.

Check the [Requisition] field on the Data Page or Review Requisitions on the Orders Page. What you described will happen if you have items requisitioned.

If you answer "Yes", any parts that have been ordered will be removed from Requisitions. Seeing this message does not mean there are requisitions to be moved; this message pops up everytime you leave the Requisitions program whether there are any requisitions to be moved or not.

Parts in Requisitions, even if already ordered, will not be removed.

Review Receipts:

The Review Receipts screen allows you to see those purchases that have been recorded as received. This screen can be opened by clicking on the Review Receipts icon found un the Inventory folder.

Storeroom Requests:

The Storeroom Requests program lets you keep track of parts that are not requested through the Work Order program.

Using the Storeroom Requests screen you can either choose to update Inventory or not.

If you specify a WO Number, all the Equipment-related fields will be filled in for you. We highly recommend that you do it this way. Specifying the WO Number when requesting parts is the best way to assign the true parts costs to each Work Order. This gives you the best cost analysis for your maintenance tasks.

Transfer Parts:

Use the Transfer Parts program when you wish to move parts from one location to another. Using this program is another way of helping you keep track of your parts.

Active Work Orders:

These buttons are only "active" when a record in the database container is highlighted (selected) since they get the labor, parts and tools for a specific record.

This sort of thing can happen in any screen since sometimes when you select a second record the data from the first record may still be showing in the entry fields and when you think you are changing the data for the second record in actuality you are not. This problem may manifest itself if you are running a slower, older computer.

The [Search] button on any of the Resource screens ([Labor], [Tools], [Parts] opened through the Resource page of the notebook) will find only those parts which you have added to the schedule or work order of the current record which is consistent with the way the [Search] button works throughout Oz.

A [Lookup] on any field will bring up all of the available values if all of the fields on the Resourse screen are blank. (These tables do not have to be built, since the system uses the [Labor], [Tools] and/or [Parts] tables from the database.) You may have to use the [More] button if there are more values than the container is set up to accept.

It is important to remember that the Resource screens, ([Labor], [Tools], [Parts] opened through the Resource page of the notebook) are always assigned to a specific record.

If, when you built your parts, you completed the [Where Used] section of the notebook, anytime you schedule a job, or, generate a work order or store room requisition which matches the [Where Used] criteria, ([Equipment Handle], [ID] or [Description]), that part will show a *. This is to alert you to the fact that these are parts which you have indicated are used on this particular Equipment. This makes these parts very easy to find if you have many parts on record.

This button belongs to the [Equipment Sheet] entry field. If you have an Equipment Sheet, you can enter the name and clicking the [Edit] button will open the file in the text editor. If you leave this field blank, but with the focus and click the [Edit] button, the editor will open, and you can create and save a file.

This is an example of what could happen, if for example, you have a job that takes several days. you can enter data, the first day, but not put a completion date in. The next day if you look at the work order, some of the fields will already be filled in.

This was done by design because [Down Cost] is a very subjective value.

In addition to entering a completion date in the [Completion Date] field, you must press the [Change] button in order to finalize the completion process.

When you close the Active Work Order screen, a pop-up window will give you the option to move completed work orders to work order history.

Yes, this is possible. If you wish to do this, you should contact Technical Support. You should be aware, however that the [Job Description] field is only 35 characters and if you have more than 35 characters in the meaning, it will be cut off at 35 characters.

Yes. If you perform a [Clear All] in the Active Work Order screen and then narrow your lookup in the [Completion Date] field to all dates greater than the first completion date that you entered, Example: ">05/09/1998", you will get only those work orders that have been marked with a completion date.

No.

In the Active Work Order screen, these fields are "read only"

The system will not generate more than one work order with the internal number supplied by the program. However, it will allow you to use the same number in the [Our Number] field for more than one record.

Yes. You would do this in the Mass Change program. You would then have to open the Active Work Order screen and close it and when the program asks if you want to move completed work orders to history, you should choose "yes".

Yes, but you cannot enter a date into the [Completion Date] field that is in the future.

To attach a single text document to a work order, add the filename to the Work Order Sheet field of the Active Work Order record.

To include additional sheets add the word INCLUDE followed by a colon (:) and a reference to your ASCII text document. If the file is not stored in the Oz\Sheets folder, you must include a fully qualified filename. For instance, the text;

will print the listed file after the initial Work Order Sheet has been printed. The text;

will assume that the file is in the Oz\Sheets folder.

To include bitmapped images on your Work Order, use the word IMAGE followed by a colon (:) and a reference to a bitmap file. Additionally, you can include a short text name of the image. (Enclose the name in angle brackets <> ). If the file is not stored in the Oz\Images folder, you must include a fully-qualified filename. For instance, the text;

will print this one image on a page and print the words 'Electrical System' beneath the image.

As described above use the syntax INCLUDE: followed by the image filename and a title. Images can be printed one, two, three or four to a page. To get two (or more) images on one page, include all of the image names on the same line, separated by semicolons (;):

The image printing facility of Oz tries to fit your image into its predefined shape.

To get the best image quality, choose the layout (1, 2, 3 or 4 to a page) which displays your image properly.

You can print the same image twice on the page or print your image and a blank image. To get the Oz default blank image use the NOIMAGE.BMP. For instance;

Oz is not designed to print text and images on the same page, however this can be done if you are willing to make an image of just text. For instance, if you want to print an image of a motor and include extensive text about that table beneath it, you will have to create a BMP file which contans the text you want to display. Then display them as you would any other images;

We do not recommend making a bitmap of only text because it is not an efficient way of storing text.

When you specify Parts for this Work Order using the "Bar Code Processing" program, or through "Storeroom Requests," the On Hand Quantity for these parts has already been updated. Thus, you can not change the part information while the Work Order is still active. After you complete the Work Order, and move it to History, you may change these values.

Completed Work Orders:

These buttons are only "active" when a record in the database container is highlighted (selected) since they get the labor, parts and tools for a specific record.

The [Search] button on any of the Resource screens ([Labor], [Tools], [Parts] opened through the Resource page of the notebook) will find only those parts which you have added to the schedule or work order of the current record which is consistent with the way the [Search] button works throughout Oz.

A [Lookup] on any field will bring up all of the available values if all of the fields on the Resourse screen are blank. (These tables do not have to be built, since the system uses the [Labor], [Tools] and/or [Parts] tables from the database.) You may have to use the [More] button if there are more values than the container is set up to accept.

It is important to remember that the Resource screens, ([Labor], [Tools], [Parts] opened through the Resource page of the notebook) are always assigned to a specific record.

You must have a record selected from the container before clicking the [Review Schedule] button since otherwise the system will not know which record you wish to review.

Yes, but only in the History program.

Equipment History:

Monthly Work Summary:

This program allows you to see all of the jobs, based on set criteria, scheduled on a month to month basis for a period of one year where you specify the end date.

For example, you could find all emergency jobs scheduled for each month from the period May 1, 1997 through April 30, 1998 broken down by month, if you specify "Emergency" in the [Schedule Basis] of the Schedule screen and enter the following text in the [Where (say Lookup to build) field on the Parameters page of the notebook on the Work Order Monthly Summary screen:

After you have created a report, you must use the [Add] button to add it to the container if you wish to keep it for future use. The report must have been given a unique [ID]

The container on the Work Order Monthly Summary screen contains only those reports which have been added to the database through the use of the [Add] button on the Work Order Monthly Summary screen.

Print Work Orders:

The Print Work Order screen can be opened by clicking on the Print Work Orders icon found in the Work Orders folder.

In the Print Work Order screen you can specify conditions which govern which work orders will be printed and how they are to be sorted.

Workload Balancing:

The Workload Balancing program examines the work orders by week and allows you to balance the workload hours by skill.

Alias Manager:

Use the Alias Manager program in the Utilities folder to create Aliases. A user cannot access the Oz tables unless he has an alias.

Users need Aliases to Oz tables. To create Aliases use the Alias Manager program in the Utilities folder. Following are some notes on Alias Manager.

NOTE: You must have GRANT priviledges on the listed tables to successfully create an alias for a user. It is best to run Alias Manager when logged in as the DB Administrator.

AliasMan uses the BldPref value 'tableCreator' which should be set to the userid of the administrator who created the database tables.

Upon opening AliasMan a list of valid users will appear in the drop-down list on the left. Select a user from this list.

You will note that the check boxes will change with the different users. These boxes are for informational use only and cannot be used to adjust a users access levels.

Click the [Aliases] button to open a list of available tables.

This list shows the table/view name, the current alias status, and the original alias status when this session began.

If the user has an alias for a table/view, an X will appear on the line.

You may add or remove an alias by double-clicking the table/view line. Note that the X appears or disappears as appropriate.

Be sure to accept your changes before closing the window.

Custom:

This program allows you to make custom changes to your Oz. system.

The most common thing that a user would change is the nomenclature and you should feel free to experiment with this part of the Custom program. Clicking the [Names] button, will bring up a text-based file which can be edited. A backup copy of this file (with the defaults) is available should you decide you would like to return the system to its previous state.

If there is some other customization that you wish to make, chances are good that it can be done. It is possible to make changes to "Preferences" such as having the Calendar popup automatically when you enter a date field; having specific data entered automatically when you enter a certain field; having a calculation run and the results entered into a field when some button is clicked, or having an external program open. You could also set fields that you don't use to "invisible." There are many, many things that can be done using the Custom program, but we strongly advise you NOT to use this part of the program without help from Technical Support (412) 367-6161.

The "for Screen" field is for Oz. custom programming ONLY and you should never attempt to use this part of the Custom program without help from Technical Support. (412) 367-6161.

Get System Printers:

If none of your printers are listed in the Output Device list run the program 'Get System Printers' in the Utilities folder.

All printers that are available to your system will be listed in the Get System Printers' container, but you must first "Add" them before they are available to the Output Device list in Oz.

If you want to add a printer by hand,
follow these steps.

1. Open the Properties of the desired printer.
2. On the View page, find the Physical Name.
3. Close the printer Properties.
4. Go to the Run page of the Reports program.
5. Pop-up the Output lookup with mouse button 2.
6. In the ENTRY field, type the Physical name obtaind in step 2.
7. Type your description of the printer in the MEANING field.
8. Click Add. Your printer is now available to all reports.

Output destinations in reports may include any printers or fax modems connected to your system. To quickly add all such devices to the output list, run 'Get System Printers' in the Utilities folder of Oz.

This program lists all available devices and allows you to Add them or Close. All devices are added and can be removed from the Output lookup through the usual methods.

This method should only be run when the system is initialized or new printers/devices are added, however rerunning the program has no ill effects.

Mass Change:

You would use the Mass Change program to make the same change or changes to many records such as changing all of the jobs that are assigned to one employee to a different employee or marking all work orders generated between certain dates as completed, etc. If you are not certain how to use this program, call Technical Support (412) 367-6161 for help.,

Yes. You would do this in the Mass Change program. You would then have to open the Active Work Order screen and close it and when the program asks if you want to move completed work orders to history, you should choose "yes".

Mass Delete:

You would use the Mass Delete program to delete all records from the database with specified conditions. You should be very careful using the Mass Delete program unless you know what you are doing. If you have any doubts, contact Technical Support for assistance. (412) 367-6161.

Security:

Yes. The Security program can be opened by clicking on the Security icon found in the Utilities folder by anyone with DB2 database administrator authority. The Oz security enhances the security already built into DB2..

You can only use the security program to add or modify users who have already been established in the DB2 system administration process. If you are the database administrator you can specify which users may not perform certain functions such as "view labor rates, remove records, change data, etc.

Lookup:

Remember, the Lookup searches the field which has the current FOCUS. You have to make sure that field has the FOCUS. You do this by Left-clicking, or by tabbing to the desired field.

You will have no problem if you use SPEECH. Just speak the name of the field you want. That automatically gives it the focus. Then speak "Lookup."

Errors:

SQLCA.SQL0100W No row was found for FETCH< UPDATE or DELETE; or the result of a query is an empty table. SQLSTATE=02000?***

On certain screens, if the container and all of the fields are blank and you type something into one of the fields and press the [Change] button, this is one of the SQL errors you may get. You might alos see:

You would get this message when you attempt to use the [Computer] button and you do not have Voice Manager install on your system.

You probably got this error because you do not have speech activated, or speech is not available. You get this message if you do not have Multimedia installed properly. You can avoid this error by changing the "Say" items in the Preferences. Use the [Custom] utility, click [Preferences]. Then search for "Say'. Change the values, "Say Warning," "Say Working," etc to 0.