Previous Topic: Define Informix DBSpacesNext Topic: Creating a Dimensional Model

Creating Models › Creating a Physical Model › Physical Storage Objects › Define Sybase Segments

Define Sybase Segments

When your target server is Sybase, you can use the Sybase Segment Editor to add and specify the parameters for a segment in which to store Sybase tables.

To define a Sybase segment

  1. Click Target - Sybase, Segments on the Model menu.

    The Sybase Segment Editor opens.

  2. Work with the following options:
    property editor PREVIOUS icon Previous

    Positions the editor on the previous segment in the Navigation Grid.

    property editor NEXT icon Next

    Positions the editor on the next segment in the Navigation Grid.

    property editor SORT iconSort

    Sorts the segments by alphabetic or reverse alphabetic order. Click the Sort button to specify how to sort the list.

    property editor DB SYNC buttonDB Sync

    Opens the DB Sync wizard, where you can perform a database-level compare of objects in the current model with matching objects in another model or database.

    New icon in property editors to create a new object New

    Creates a new segment that becomes the current object in the editor.

    property editor DELETE button Delete

    Deletes the selected segment.

    property editor HELP button Help

    Accesses online help for the editor.

    enter filter text box in a property editor to filter object list

    Lets you enter text to filter a large list of segment objects so you can quickly locate the one that you want.

    Name

    Displays the segment name. You can change the segment name in this field.

    Generate

    Generates SQL during forward engineering. Clear the check box if you do not want to generate SQL.

  3. Click the Comment tab to enter a comment for the segment.
  4. Click the UDP tab to enter user-defined property values for the segment.
  5. Click the Notes tab view or enter any user notes for the segment.
  6. Click Close.

    The Sybase segment is defined and the Sybase Segment Editor closes.

****************

When your target server is Sybase, you can use the Sybase Segment dialog to add and specify the parameters for a segment.

To open the Sybase Segment dialog, on the Database menu, select Segments.

The Sybase Segment dialog includes the following tabs:

Segment

Displays all available segments in the current model.

New

Opens the New Segment dialog and add a segment name.

Rename

Opens the Rename Segment dialog and change the name of the selected segment.

Delete

Deletes the selected segment.

DB Sync

Starts the Complete Compare task so you can synchronize the physical storage objects defined in your model with the information stored on the server.

Note: Once you add a segment on Sybase, you can associate tables with it using the Tables dialog. Although you can enter a name for a new segment and view the names of existing segments in the Sybase Segment dialog, you cannot generate a segment using CA ERwin Data Modeler. To generate a segment to Sybase, you must use the sp_addsegment stored procedure.