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:
|A table name with a file number
|Column names with ADABAS field names
|Index names with ADABAS descriptor names
|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
; Sample description of the STAFF table
; comment,ADABAS field name,internal
MYDB,PUBLIC,STAFF, ID,1,0, 4,4,0,Y,0,ID,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, COMM,7,8, 4,8,2,Y,0,CM,0
; database,owner,table,index,unique,comment,columns,ADABAS descriptor name,
To run the utility on UNIX:
You are now ready to run SQL queries and updates against the STAFF table! You
need only decide which Trifox client product to use.
To obtain your evaluation, go to our
and choose Vortex.
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
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
gds6init adabas -i
4. Load the STAFF definition
Assuming that the staff definition is in a file called 'staff.in',
gds6init adabas -astaff.in
Please refer to the
GENESIS Users Guide.
Back To Top
Updated 30 Jan 2013.