My Oracle Support Banner

How to Setup Documaker and Documaker Workstation, to Store the WIP Index and WIP Data into DB2 Database Tables. (11.2 Feature 1872) (Doc ID 788426.1)

Last updated on JULY 01, 2021

Applies to:

Oracle Documaker - Version 11.2 to 11.5
Oracle Documaker Desktop - Version 11.2 to 11.5
Information in this document applies to any platform.

Goal

How to setup Documaker, Documaker Workstation, to store the WIP index and WIP Data into DB2 database tables. 

Assumptions:

These instructions are valid for products known as Documaker Desktop (Documaker Workstation) and Documaker Server (Documaker RP).

The sample libraries we ship for Documaker and Documaker Workstation contain the wip.dfd (index) and wipdata.dfd file.

In this document you will find the layout of the standard (default) wip.dfd file and the wipdata.dfd file.

The standard WIP system uses an Xbase index and a flat file (nafile, polfile) format.
We refer to this system index as Xbase or DBASE IV.
Optionally, the flat files can be compressed.

The major difference between the wip.dfd for DBASE IV and DB2 is a field UNIQUE_ID. Since this field is not included in the default wip.dfd, the DB2 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.

For this scenario you will update the INI file to automatically create tables in the DB2 database.
For the purposes of this document we assume your Primary resource library will be in the following structure:
c:\fap\mstrres\rpex1
The fsiuser.ini and fsisys.ini are in this directory.
The wip.dfd and wipdata.dfd files are in the c:\fap\mstrres\rpex1\deflib directory.
We assume the dll directory is as follows: c:\fap\dll.

Prerequisites:

DB2 is installed
DB2 client with native DB2 driver is configured and has been tested.
Documaker, Documaker WS (RP) installed version 11.1 P22 or higher 
 

Solution

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
Goal
 Assumptions:
 Prerequisites:
Solution
 Detailed Steps:

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.