[Prev] [Next] [Top] [Bottom] [Contents] (6 out of 16)

Object Editor

The Object Editor is used to create, modify and delete Data Objects. Each Data Object has specific operations that can be performed on that Data Object Type. These operations will be explained in detail as they show up.

The following section provides an image of each state of the Object Editor and a description of the major components.

States of the interface

Figure 2-15 Object Editor in PROC State

About the PROC State

Figure 2-16 Object Editor in DSQL State

About the DSQL State

Figure 2-17 Object Editor in FILE State

About the FILE State

Figure 2-18 Object Editor in EXEC State

About the EXEC State

Figure 2-19 Object Editor in FUNC State

About the FUNC State

Pulldown Menus

File

Edit

View

Tools

Help

How to Invoke the Interface

1. From the Project Window's Tools menu
2. From the Project Window's Main Button Bar
3. From the Database Browser's Tools Menu
4. From the Object Editor's Tools Menu
5. From the Object Bind Editor's Tools Menu.
Output Area

The Output Area is used in FILE, EXEC and FUNC States of the Object Editor. It works the same in all three Object Editor States.

The Output Area looks like the following Figures

:

Figure 2-20 Output Area Using Delimited Output

Figure 2-21 Output Area Using Fixed Width Output

About the Output Area

Defining Delimited Columns

1. Set the Delimited toggle to on (button is depressed).
2. Choose the Column Delimiter from the Column Delim combo.
3. Choose the String Delimiter from the String Delim combo.
4. Add all of the column names to the Column Name List. With delimited data, no width needs to be specified.

Defining Fixed Width Columns

1. Set the Delimited toggle to off (button is not depressed)
2. Type a column width and name into the Width and Name textFields, respectively.
3. Press the Add button. The width and column are added to the Column Name List.
4. Repeat steps 2 and 3 until all of the Data Object's columns are defined.

Arguments for EXEC Data Objects

When specifying Arguments for EXEC Data Objects, use this simple format:

#name, type[, remove_previous]
Where

name = The name of the argument. This will appear in the Object Bind Editor.

type = This can be WRAP or NO_WRAP. WRAP means to wrap the argument value with quotes and NO_WRAP means to not wrap the value with quotes.

remove_previous = This is an optional parameter. A value of True means to remove the prefix of this argument if the value returned for the argument is NULL or empty. False means do not remove the prefix.

Examples:

Argument definition:

-f #filename, WRAP# -v
Data provided by end-user:

NULL
Resulting String:

-f -v

Argument definition:

-f #filename, NO_WRAP, True# -v
Data provided by end-user:

NULL
Resulting String:

-v
See Data Objects for more information and examples.

Testing PROC and DSQL Data Objects

When the Test button is pressed, different things will happen based upon whether the Data Object has arguments and/or results:

Test Arguments Dialog

The Test Argument Dialog is used when testing PROC and DSQL Data Objects. If the Data Object has arguments, this dialog is invoked so the user can enter argument values to test the Data Object.

.

Figure 2-22 Test Arguments Dialog

The Object Results Viewer

The Object results Viewer displays results for PROC and DSQL Data Objects. The results are organized into a list of row/column matrices. Each matrix represents one results group from the results data. A group is the product of a SELECT statement in SQL (rows and columns). The groups can be stepped through one at a time. Rows and Columns for each group are displayed in tabular form with column headings and sequentially numbered rows. Error Code and Return Code are displayed in the lower corners of the Object results Viewer
.

Figure 2-23 Object Results Viewer

Setting Privileges

To set privileges for PROC Data Objects, it is accomplished through the Privileges Dialog. The Privilege Dialog is invoked by choosing Privileges from the Object Editor's Edit menu

.

Figure 2-24 Privileges Dialog

Note: Only the owner of the Data Object can change Privileges for the current Data Object.


[Prev] [Next] [Top] [Bottom] [Contents] (6 out of 16)