DEFINE SEARCH (DS=)

Used to specify and activate a fence filter (a SQL SELECT statement that determines which elements can be selected for fence operations). There can be one fence filter active for each table in the database. For each table, the SELECT statement is stored in the fencefilter column of the row for the table in MSCATALOG.

1. Key in:DEFINE SEARCH <SQL_SELECT_statement> DS=<SQL_SELECT_statement>
   For example:
   DS=SELECT * FROM parts WHERE pc='8255' AND cost=2.10

1. In the Key-in Window, key in: DS=$
   Clicking the Next button in the SQL Window retrieves the next row.

1. Key in:DS=NONE