SQL Messages

Program #:   1609

Module:    Utilities

Overview

Use SQL Messages (program #1609) to create SQL message groups and messages. When the program opens, it displays a list of message groups. You can use these message groups to define either language or company-specific translations for use in the SQL version. You may create translations for each of these groups.

Other message programs include GUI Messages (program #1606), JAM Messages (program #1607), SQR Messages (program #1608), and IBS Messages (program #1610).

Note: You must notify IBS when you make any changes in this program so they can be copied back to IBS and stored in the message system that is delivered with new releases. This ensures that any changes you make survive upgrades.

Note: In the main window of SQL Messages, customers do not have access to:

l    Change Record

l    New Record

l    Delete Record

Note: In the SQL Messages Details tab, customers do not have access to New Record.

To access SQL Messages, choose SQL Messages (program #1609) from the main menu of SBN.

The SQL Messages Window

The following graphic shows the main window of SQL Messages.

Field/Column Descriptions

The following table describes the fields and columns used in SQL Messages.

Viewing the Information of a SQL Message Group

You can view specific information about a message group in the lower pane of the main window of SQL Messages in the following fields:

• Sub

• Min s#msgno

• Number of Msgs to Allocate

• Description

Use the following steps to view SQL message group information:

   1.    In SQL Messages (program #1609), select the SQL message group for which you want to view information.

   2.    Choose Get Record.

‰    SBN displays the information in the lower pane of the main window of SQL Messages.

Changing the Information About a SQL Message Group

Use the following steps to change the information about a SQL message group:

   1.    In SQL Messages (program #1609), select the SQL message group you want to change.

   2.    Choose Change Record.

   3.    Change the information in the lower pane of the main window of SQL Messages.

   4.    Choose Save Existing Record.

Creating a New SQL Message Group

Use the following steps to create a new SQL message group:

   1.    In SQL Messages (program #1609), choose New Record.

   2.    Complete the fields in the lower pane of the main window of SQL Messages.

   3.    Choose Save New Record.

Deleting a SQL Message Group

Use the following steps to delete a SQL message group:

   1.    In SQL Messages (program #1609), select the SQL message group you want to delete.

   2.    Choose Delete Record.

‰    SBN asks if you want to delete the message group.

   3.    Choose Yes.

‰    A message may appear that states that you cannot delete the group because it has messages.

   4.    Choose OK.

Zooming In/Out of the Sublevel

Zoom in or out of the sublevel to open or close the SQL Messages Details tab for a specific message group. Opening the SQL Messages Details tab provides additional SQL message options.

Field/Column Descriptions — Details Tab

The following table describes the fields and columns used in this tab.

Searching for Messages

Use the following steps to search for specific messages within a message group:

   1.    In SQL Messages (program #1609), select the message group you want to search.

   2.    In SQL Messages Details tab, complete the search parameter fields.

   3.    Choose Search.

Viewing a Message

Use the following steps to view a message:

   1.    In SQL Messages Details tab, select the message you want to view information about.

   2.    Choose Get Record.

‰    The information displays in the lower pane of the SQL Messages Details tab.

Changing a Message

Use the following steps to change existing message information:

   1.    In SQL Messages Details tab, select the message you want to change.

   2.    Choose Change Record.

   3.    Change information in the lower pane of the SQL Messages Details tab.

   4.    Choose Save Existing Record.

Deleting a Message

Use the following steps to remove messages from the message list in the Details tab:

   1.    In SQL Messages Details tab, select the message you want to delete.

   2.    Choose Delete Record.

A confirmation box opens asking if you want to delete the message.

   3.    Choose Yes.

Using Message Translation

You can enter a message translation for a selected message based on language or company specific requirements.

Note: When you define translations for APP message group, you must define three (3) translations, which you must enter in positions #1, #41, and #61 in the Message field. These positions represent the long, medium, and short translations for column headings.

Field Descriptions — Message Translations

The following table describes the fields used in this window.

Translating a Message

Use the following steps to translate a message:

   1.    In SQL Messages Details tab, select the message you want to translate.

   2.    Choose Translate.

‰    The Message Translation dialog box opens.

   3.    Complete the fields, as needed.

   4.    Choose OK.

Installing and Compiling Messages

Use Installing and Compiling Messages to install the messages that have been changed to the system.

Note: SBN automatically installs SQL Messages.

Note: Use Install and Compile Message for

l    JAM Messages (program #1607)

l    SQR Messages (program #1608)

l    SQL Messages (program #1609)

l    IBS Messages (program #1610)

Use the following steps to install messages:

   1.    In SQL Messages Details tab, choose Install and Compile Message.

A confirmation box opens asking if you are sure.

   2.    Choose Yes.

Button Functions

The following table displays the buttons, describes the shortcut keys, actions and functionality.

Modifications and Updates to SQL Messages

The following table lists modifications and updates to the SQL Messages document.