Using Library Manager with a DBMS
To use Library manager with a DBMS system, like Oracle’s ODBC driver, DB2, or SQL Server, update your master resource library to include these changes:
LBYINDEX.DFD
The LBYINDEX.DFD file is used as the Library manager’s index. You typically can omit this DFD file unless you are using Library manager with a DBMS, like DB2, SQL Server, or Oracle.
Reference this file in the ArcRet control group of the FSIUSER.INI file using the LBYIndexDFD option. You must use this option because the default settings include a Resource column which is a reserved word in Oracle.
Note |
You can see an example of this file in the DMS1 master resource library.
To create an index table, be sure to comment out these fields in the LBYINDEX.DFD file:
< Fields >
; FieldName = RESOURCE
; < Field:RESOURCE >
; INT_Type = CHAR_ARRAY
; INT_Length = 25
; EXT_Type = CHAR_ARRAY
; EXT_Length = 25
; Key = N
; Required = N
CARFILE.DFD
You must change the default setting for this file because of the Total_Size field. For that field set the EXT_Type field to Double. For the CARData field of BLOB type, you need to specify an INT_Length and EXT_Length for the column to be created in the Oracle data table. Here is an example:
< Field:Total_Size >
INT_Type = Long
INT_Length = 4
EXT_Type = Double
EXT_Length = 4
Key = N
Required= N
< Field:CARData >
INT_Type = BLOB
INT_Length = 252
EXT_Type = BLOB
EXT_Length = 252
Key = N
Required = N