Introduction

The GENESIS ADABAS C driver uses direct ADABAS C calls to provide very high performance with SQL access. The GENESIS SQL engine quickly parses the SQL statements and converts them into discrete read/write operations that are executed by the ADABAS C native driver.

Included with the driver is a GENESIS dictionary maintenance utility. GENESIS relies upon four dictionary tables to keep track of the ADABAS FDTs, including descriptors and files. The utility uses an input file to make the new GENESIS dictionary entries. This file is divided into four sections corresponding to the four GENESIS dictionary tables:

Import File Section	Dictionary Table	Associates
TABLES	GENESIS_TABLES entries	A table name with a file number
COLUMNS	GENESIS_COLUMNS entries	Column names with ADABAS field names
INDEXES	GENESIS_INDEXES entries	Index names with ADABAS descriptor names
XCOLUMNS	GENESIS_XCOLUMNS entries	Column names with ADABAS descriptor field names

The file format is shown below. Note that the semicolon (;) in the first column denotes a comment. Also the order of the entries is not important.

     ; Sample description of the STAFF table
     TABLES
     ; database,owner,name,type,comment,columns,filenum,internal
     MYDB,PUBLIC,STAFF,T,0,7,21,0
     
     COLUMNS
     ; database,owner,name,column,sequence,datatype,length,precision,scale,nulls,
     ; comment,ADABAS field name,internal
     MYDB,PUBLIC,STAFF,    ID,1,0, 4,4,0,Y,0,ID,0
     MYDB,PUBLIC,STAFF,  name,2,1,10,4,0,Y,0,NM,0
     MYDB,PUBLIC,STAFF,  DEPT,3,0, 4,4,0,Y,0,DP,0
     MYDB,PUBLIC,STAFF,   JOB,4,1, 6,4,0,Y,0,JB,0
     MYDB,PUBLIC,STAFF, YEARS,5,0, 4,4,0,Y,0,YR,0
     MYDB,PUBLIC,STAFF,SALARY,6,8, 4,8,2,Y,0,SA,0
     MYDB,PUBLIC,STAFF,  COMM,7,8, 4,8,2,Y,0,CM,0

     INDEXES
     ; database,owner,table,index,unique,comment,columns,ADABAS descriptor name,
     ; internal
     MYDB,PUBLIC,STAFF,STAFF_IX1,U,0,1,ID,0

     ; database,owner,table,index,column,sequence,direction,internal
     XCOLUMNS
     MYDB,PUBLIC,STAFF,STAFF_IX1,ID,0,A,0

To run the utility on UNIX:

1. Create the GENESIS dictionary.

adafdu < gds6init.fdu (modify the dbid, file parameters)

2. Create a GENESIS data source file.

In $GENESIS_HOME, create a file with

database <dbid>
dictionary <fnum>

where <dbid> is the database id and <fnum> is the GENESIS dictionary file number. These must match the values used in step 1.

3. Load the GENESIS dictionary.

Assuming that the file in step 2 is called adabas and you have set $GENESIS_HOME correctly,

gds6init adabas -i

4. Load the STAFF definition

Assuming that the staff definition is in a file called 'staff.in',

gds6init adabas -astaff.in

How To Get the GENESIS ADABAS Driver

More Reading

Please refer to the GENESIS Users Guide.

Back To Top

© 1985-2020 Updated 30 Jan 2013.