Setting up Documaker Workstation to store the WIP index into a SQL database.
(Doc ID 788398.1)
Last updated on APRIL 23, 2021
Applies to:Oracle Documaker Desktop - Version 10.0.0.0 to 11.2
z*OBSOLETE: Microsoft Windows
The Purpose of this bulletin is to describe the steps required to setup Documaker Workstation to store the WIP index into a SQL database, or convert existing Xbase WIP index entries to a SQL database.
This bulletin is intended for users who have received sufficient training and have a technical understanding of how to modify the Documaker Workstation configuration. These instructions are valid for products known as Documaker Workstation (RP) / DAP Processing System / PPS.
The sample libraries we ship do not contain the wip.dfd file.
In this document you will find the layout of the standard (default) wip.dfd file.
The standard WIP system uses an Xbase index and a flat files (nafile, polfile) format.
Optionally, the flat files can be compressed.
We refer to this system index as Xbase or DBASE IV.
The major difference between the wip.dfd for DBASE IV and SQL is a field UNIQUE_ID. Since this field is not included in the default wip.dfd, the SQL user has to create a wip.dfd with all default fields plus the additional UNIQUE_ID field. See UNIQUE_ID field comments in detailed steps section.
After setup you will convert any existing xBase WIP files before saving new transaction files to WIP in SQL Server.
SQL Server installed
ODBC DSN configured and tested. You will put your DSN (data source name) in the INI file. See Server option in detailed steps.
Documaker WS / PPS installed version 10.0 or higher.
PRIOR TO MAKING THE CHANGES OUTLINED IN THIS BULLETIN, MAKE A BACKUP OF THE CURRENT WIP DIRECTORY.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document