beautypg.com

Chapter 10. managing items and batches, Managing items – HP Integrity NonStop H-Series User Manual

Page 115

background image

dba/m Database Manager V7.1 User's Guide – 540156-001

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.

This manual is related to the following products: