Skip navigation FileNet logo
Glossary  |  Help Directory  
  Help for vwtool
  Search
Process Reference  
vwtool
Getting Started
Commands
  !<shell_cmd>
  =
  assertbehavior
  attachtran
  config
  convert
  count
  createDBviews
  dbconfig
  deletewob
  dispatchwob
  dump
  echo
  emptyqueue
  environment
  hardcopy
  help
  listdbconfig
  listobjects
  listobjects
  loadstatus
  lockwob
  logconfig
  logquery
  memory
  pagebreak
  queueconfig
  readcdl
  recover
  region
  regions
  resetloadstatus
  rosterconfig
  schemastatus
  statistics
  stepprocessors
  storedquery
  terminatewob
  trace
  unlockwob
  version
  views
  wobquery
  workstation
  writetrace

 

   

createDBviews (FileNet Web Services Client and Open Client)

This command recreates database views for all local queues, rosters, and event logs. Database views are automatically created whenever a transfer occurs. (Note that a transfer creates the views on all servers in a multi-server system; the createDBviews command only creates the views on the local server.)

Database views provide an alternative to using the Process Java API to query queues, rosters, and event logs; this alternative involves the use of standard database query tools and can significantly improve performance when querying large numbers of records. For further information about such queries, see "Using ADO to Query the Process Database" in Help for Process Java API.

The createDBviews command has two options—recreate the database views immediately, or create a script and an accompanying text file to use with standard database tools to recreate the database views.

The naming convention for database views is:

vwv<type>_<isolated_region>_<classname>

where

type

Indicates queues (q), rosters (r), or event logs (l).

isolated_region

The isolated region in which the views are created.

classname

The name of the roster, queue, or event log.

For data fields, the command uses the names specified in the Process Configuration Console, rather than the physical name used in the database. Therefore, the resulting script may contain syntax errors if the alias is not a valid database field name.

NOTE Oracle limits field names to 30 characters. If the user-defined name exceeds 30 characters, it is automatically truncated.

When using the views to perform queries, you must enclose all user-defined field names in quotation marks. In addition, queries on event log views require that you enclose all field names in quotation marks. See the examples below.

Queue or roster query

select F_WobNum, F_WorkSpaceId, "userfieldname1", "userfieldname2" from f_sw.VWVQ94_testmodswp;

Event log query

select "F_WobNum", "F_WorkSpaceId", "userfieldname1", "userfieldname2" from f_sw.vwvl94_testparentlog;

The Oracle database views are created with a 'read only' option. This feature is not available with SQL Server, therefore, you must manually modify the permissions on views for SQL Server.

Syntax

createDBviews <choice> <workspaceid> <filename>

Parameters

choice

Whether to create a script or create the views . Enter "s" to create a script that can be run later using standard database tools, along with a text file describing the views. Enter "v" to create views immediately.

workspaceid

Workspace ID of workspace from which to retrieve the information.

Press Enter to select the current workspace or a enter valid workspace ID to select another specific workspace.

filename

Name (and path) of the resulting script and text files, without an extension. (The extensions .SQL and .TXT are automatically appended to the name you choose.) By default, the files are created in the directory from which you are running vwtool. This command option only applies if you enter "s" for the choice.

   

TIP In vwtool, you can enter parameters on the command line (following the command name) or let vwtool prompt you for the information by entering just the command name. Generally, we recommend prompt mode for all but the simplest commands. Entering the parameters on the command line is intended primarily for script-driven input.

NOTE If necessary, change to the desired isolated region prior to executing this command.