Owner manual

NonStop dba/m Database Manager for NonStop SQL/MP User’s Guide 522632-005 10-1
CHAPTER 10. MANAGING ITEMS AND
BATCHES
Using dba/m Database Manager, you can manage items and batches:
• An item is a unit of work that consists of SQL commands and
operations, such as SQLCOMP. You create items in windows such
as Create Table, Create Index, and Compile Programs. An item is
executed as a single transaction.
• A batch is a collection of one or more items that you execute in a
user defined sequence. A batch is also executed as a single
transaction.
Managing Items
You can create, edit, or delete items.
Create an Item
You create an item by clicking on Queue in an object management window
such as catalog-management, table-management, view-management, index-
management, program-management, or in the copy or load data windows.
The item is queued for later execution and is given a numeric identifier.
Once the item is queued, you can manipulate it in the Create Batch
window.
Edit an Item
After you have queued an item for later execution, you can edit it in the
Create Batch window. To display the Create Batch window, click on
CreateBatch in the Main window. The Create Batch window is displayed,
as shown in Figure 10-1.