Example DFD File (AOR.DFD)

This DFD (Data Format Definition) file descry ibes the database table schema to Documaker. In this example, with a database table called AOR, this file is called AOR.DFD and is used to define the interface between Documaker and the data table AOR in the Oracle database used for storage of the extract data.

The DFD file is used in the DAL script where you will see references to AOR in the DBAdd, DBOpen, and DBPrepare function calls. This file is loaded via DBOpen so Documaker knows what columns are available. Documaker also uses that information to insert the row in the AOR table.

In the example, this file is in the deflib subdirectory, per the call in the DAL script: DBOPEN(AOR_TableName, "ODBC", ".\deflib\aor.dfd", "READ&WRITE&CREATE_IF_NEW") Here is an example of the AOR.DFD file:

< Fields >
FieldName = JOBID
FieldName = TRANID
FieldName = BATCHID
FieldName = DOCID
FieldName = NAME
FieldName = TYPE
FieldName = TITLE
FieldName = AUTHOR
FieldName = SECGROUP FieldName = PFILE
FieldName = CATEGORY
FieldName = CABINET
FieldName = STATUSCD
FieldName = KEY1
FieldName = KEY2
FieldName = KEYID
FieldName = TRANCODE
FieldName = RUNDATE
FieldName = CURRUSER
FieldName = AGENCYID
FieldName = EFFDATE FieldName = EXPDATE
FieldName = INSFNAME
FieldName = INSLNAME
FieldName = INSADD1
FieldName = INSADD2
FieldName = INSCITY
FieldName = INSSTATE FieldName = INSZIP
FieldName = INSPHONE
FieldName = INSDOB
FieldName = INDEX01
FieldName = INDEX02
FieldName = INDEX03
FieldName = INDEX04
FieldName = INDEX05
FieldName = INDEX06
FieldName = INDEX07
FieldName = INDEX08
FieldName = INDEX09
FieldName = INDEX10
FieldName = INDEX11
FieldName = INDEX12
< Field:JOBID >
Int_Type = CHAR_ARRAY 

Int_Length = 47
Ext_Type = CHAR_ARRAY
Ext_Length = 47
Key = Y
Required = Y
< Field:TRANID >
Int_Type = CHAR_ARRAY Int_Length = 47
Ext_Type = CHAR_ARRAY
Ext_Length = 47
Key = Y
Required = Y
< Field:BATCHID >
Int_Type = CHAR_ARRAY Int_Length = 47
Ext_Type = CHAR_ARRAY
Ext_Length = 47
Key = Y
Required = Y
< Field:DOCID >
Int_Type = CHAR_ARRAY Int_Length = 47
Ext_Type = CHAR_ARRAY
Ext_Length = 47
Key = Y
Required = Y
< Field:NAME >
Int_Type = CHAR_ARRAY
Int_Length = 47
Ext_Type = CHAR_ARRAY
Ext_Length = 47
Key = N
Required = Y
< Field:TYPE >
Int_Type = CHAR_ARRAY Int_Length = 10
Ext_Type = CHAR_ARRAY
Ext_Length = 10
Key = N
Required = Y
< Field:TITLE >
Int_Type = CHAR_ARRAY Int_Length = 30
Ext_Type = CHAR_ARRAY
Ext_Length = 30
Key = N
Required = Y
< Field:AUTHOR >
Int_Type = CHAR_ARRAY
Int_Length = 30
Ext_Type = CHAR_ARRAY
Ext_Length = 30
Key = N
Required = Y
< Field:SECGROUP >
Int_Type = CHAR_ARRAY Int_Length = 30
Ext_Type = CHAR_ARRAY
Ext_Length = 30
Key = N
Required = Y
< Field:PFILE >
Int_Type = CHAR_ARRAY
Int_Length = 255
Ext_Type = CHAR_ARRAY
Ext_Length = 255
Key = N 
Required = Y
< Field:CATEGORY >
Int_Type = CHAR_ARRAY
Int_Length = 30
Ext_Type = CHAR_ARRAY
Ext_Length = 30
Key = N
Required = N
< Field:CABINET >
Int_Type = CHAR_ARRAY
Int_Length = 30
Ext_Type = CHAR_ARRAY
Ext_Length = 30
Key = N
Required = N
< Field:STATUSCD >
Int_Type = LONG Int_Length = 1
Ext_Type = LONG
Ext_Length = 1
Key = N
Required = Y
< Field:KEY1 >
Int_Type = CHAR_ARRAY Int_Length = 100
Ext_Type = CHAR_ARRAY
Ext_Length = 100
Key = N
Required = N
< Field:KEY2 >
Int_Type = CHAR_ARRAY
Int_Length = 100
Ext_Type = CHAR_ARRAY
Ext_Length = 100
Key = N
Required = N
< Field:KEYID >
Int_Type = CHAR_ARRAY Int_Length = 100
Ext_Type = CHAR_ARRAY
Ext_Length = 100
Key = N
Required = N
< Field:TRANCODE >
Int_Type = CHAR_ARRAY Int_Length = 30
Ext_Type = CHAR_ARRAY
Ext_Length = 30
Key = N
Required = N
< Field:RUNDATE >
Int_Type = CHAR_ARRAY
Int_Length = 30
Ext_Type = CHAR_ARRAY
Ext_Length = 30
Key = N
Required = N
< Field:CURRUSER >
Int_Type = CHAR_ARRAY
Int_Length = 100
Ext_Type = CHAR_ARRAY Ext_Length = 100
Key = N
Required = N
< Field:AGENCYID>
Int_Type = CHAR_ARRAY Int_Length = 30
Ext_Type = CHAR_ARRAY
Ext_Length = 30
Key = N
Required = N
< Field:EFFDATE >
Int_Type = CHAR_ARRAY Int_Length = 30
Ext_Type = CHAR_ARRAY
Ext_Length = 30
Key = N
Required = N
< Field:EXPDATE >
Int_Type = CHAR_ARRAY
Int_Length = 30
Ext_Type = CHAR_ARRAY
Ext_Length = 30
Key = N
< Field:CUSTID >
Int_Type = CHAR_ARRAY
Int_Length = 30
Ext_Type = CHAR_ARRAY
Ext_Length = 30
Key = N
Required = N
< Field:POLNUM >
Int_Type = CHAR_ARRAY Int_Length = 100
Ext_Type = CHAR_ARRAY
Ext_Length = 100
Key = N
Required = N
< Field:INSFNAME >
Int_Type = CHAR_ARRAY Int_Length = 30
Ext_Type = CHAR_ARRAY
Ext_Length = 30
Key = N
Required = N
< Field:INSLNAME >
Int_Type = CHAR_ARRAY
Int_Length = 30
Ext_Type = CHAR_ARRAY
Ext_Length = 30
Key = N
Required = N
< Field:INSADD1 >
Int_Type = CHAR_ARRAY Int_Length = 100
Ext_Type = CHAR_ARRAY
Ext_Length = 100
Key = N
Required = N
< Field:INSADD2 >
Int_Type = CHAR_ARRAY Int_Length = 100
Ext_Type = CHAR_ARRAY
Ext_Length = 100
Key = N
Required = N
< Field:INSCITY >
Int_Type = CHAR_ARRAY
Int_Length = 30
Ext_Type = CHAR_ARRAY
Ext_Length = 30
Key = N
Required = N
< Field:INSSTATE >
Int_Type = CHAR_ARRAY
Int_Length = 3
Ext_Type = CHAR_ARRAY
Ext_Length = 3
Key = N
Required = N
< Field:INSZIP >
Int_Type = CHAR_ARRAY Int_Length = 11
Ext_Type = CHAR_ARRAY
Ext_Length = 11
Key = N
Required = N
< Field:INSPHONE >
Int_Type = CHAR_ARRAY Int_Length = 30
Ext_Type = CHAR_ARRAY
Ext_Length = 30
Key = N
Required = N
< Field:INSDOB >
Int_Type = CHAR_ARRAY
Int_Length = 30
Ext_Type = CHAR_ARRAY
Ext_Length = 30
Key = N
Required = N
< Field:WIPREASON >
Int_Type = CHAR_ARRAY Int_Length = 30
Ext_Type = CHAR_ARRAY
Ext_Length = 30
Key = N
Required = N
< Field:INDEX01 >
Int_Type = CHAR_ARRAY Int_Length = 30
Ext_Type = CHAR_ARRAY
Ext_Length = 30
Key = N
Required = N
< Field:INDEX02 >
Int_Type = CHAR_ARRAY
Int_Length = 30
Ext_Type = CHAR_ARRAY
Ext_Length = 30
Key = N
Required = N
< Field:INDEX03 >
Int_Type = CHAR_ARRAY
Int_Length = 30
Ext_Type = CHAR_ARRAY
Ext_Length = 30
Key = N
Required = N
< Field:INDEX04 >
Int_Type = CHAR_ARRAY Int_Length = 30
Ext_Type = CHAR_ARRAY
Ext_Length = 30
Key = N
Required = N
< Field:INDEX05 >
Int_Type = CHAR_ARRAY Int_Length = 30
Ext_Type = CHAR_ARRAY
Ext_Length = 30
Key = No
Required = No
< Field:INDEX06 >
Int_Type = CHAR_ARRAY
Int_Length = 30
Ext_Type = CHAR_ARRAY
Ext_Length = 30
Key = No
Required = No
< Field:INDEX07 >
Int_Type = CHAR_ARRAY Int_Length = 30
Ext_Type = CHAR_ARRAY
Ext_Length = 30
Key = No
Required = No
< Field:INDEX08 >
Int_Type = CHAR_ARRAY Int_Length = 30
Ext_Type = CHAR_ARRAY
Ext_Length = 30
Key = No
Required = No
< Field:INDEX09 >
Int_Type = CHAR_ARRAY
Int_Length = 30
Ext_Type = CHAR_ARRAY
Ext_Length = 30
Key = No
Required = No
< Field:INDEX10 >
Int_Type = CHAR_ARRAY Int_Length = 30
Ext_Type = CHAR_ARRAY
Ext_Length = 30
Key = No
Required = No
< Field:INDEX11 >
Int_Type = CHAR_ARRAY Int_Length = 30
Ext_Type = CHAR_ARRAY
Ext_Length = 30
Key = No
Required = No
< Field:INDEX12 >
Int_Type = CHAR_ARRAY Int_Length = 30
Ext_Type = CHAR_ARRAY
Ext_Length = 30
Key = No
Required = No
< Keys >
KeyName = BATCH
KeyName = DOCID
< Key:BATCH >
Expression = JOBID+TRANID+BATCHID
FieldList = JOBID,TRANID,BATCHID
< Key:DOCID >
Expression = DOCID
FieldList = DOCID