![]() ![]() |
|
Help for vwtool | |
Search | |
![]() |
|
![]() |
![]() |
![]() |
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 optionsrecreate 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
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.
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
|
TIP NOTE |
![]() |
|
![]() |
|