IBM Enterprise Records, Version 5.1.+            

Using Enterprise Manager

The Enterprise Manager administration application is useful tool for both examining details about deployed IBM® Enterprise Records class and property schemas and in providing the capacity to test SQL query statements.

Common IBM Enterprise Records classes

The following paths refer to the hierarchy displayed in the Enterprise Manager tree view. These paths represent the more common IBM Enterprise Records schema classes used in report queries.

Object Stores | <object store> | Document Class | Record
This is the base class for all of the concrete IBM Enterprise Records record classes.
Object Stores | <object store> | Other Classes | Folder | RM Folder
This is the base class for all of the IBM Enterprise Records record container classes such as File Plan, Record Category, Record Folder and Volume. Record Folder is further subclassed into several electronic and physical record container types.
Object Stores | <object store> | Other Classes | Link | RM Link
This is the base class for all of the IBM Enterprise Records link related classes such as Record Hold Link, RM Folder Hold Link, and others.
Object Stores | <object store> | Other Classes | Custom Object
Under this node reside many IBM Enterprise Records custom object classes such as Action, Disposal Schedule, Location, Phase, Record Hold, Record Type, and others.

Using Enterprise Manager to Test Report Queries

The Enterprise Manager Query Builder feature is helpful in developing and testing P8 CM SQL query statements.

To access the Query Builder feature

  1. In Enterprise Manager, right-click the Object Stores | <object store> | Search Results tree view node.
  2. Select New Search from the context menu.
  3. On the View menu, select SQL View to change the Query Builder view to the free form SQL text entry form.
When using the Enterprise Manager Query Builder, the first SELECT statement item must be the "This" object reference pertaining to the primary table involved in the query. For example, the following report SQL statement:
		SELECT ri.DocumentTitle, ri.DateCreated 
		FROM RecordInfo ri 
		WHERE ri.Format LIKE 'Regulator Data%'
must be changed to:
		SELECT ri.This, ri.DocumentTitle, ri.DateCreated 
		FROM RecordInfo ri 
		WHERE ri.Format LIKE 'Regulator Data%'
in order to test the SQL statement with Enterprise Manager Query Builder. When supplying literal date/time values, P8 CM SQL syntax requires the use of the ISO format YYYYMMDDhhmmss[,ffff]Z or the W3C format YYYY-MM-DD[Thh:mm:ss[.ffff]][<timezone> as in:
		WHERE ri.DateLastModified >= 20080324T112334Z   
		AND ri.DateLastModified <= 2009-02-12


Feedback

Last updated: August 2011
use_em.htm

© Copyright IBM Corporation 2011.
This information center is powered by Eclipse technology. (http://www.eclipse.org)