[See all pages on this site.] [Find out more about Trifox Inc.] [Find out how to contact Trifox personnel.] [Complete product documentation, FAQs, online references.] [Pricing is simple.] [Download an evaluation copy of any Trifox product.] [Descriptions of all products, including VORTEX, DesignVision, and Genesis.]

[LOGO]
[Navigation Map]

 

[Search Site]

| 

ADABAS C Driver

   

[*] Introduction
[*] How to Get the Driver
[*] More Reading

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

You are now ready to run SQL queries and updates against the STAFF table! You need only decide which Trifox client product to use.

How To Get the GENESIS ADABAS Driver

To obtain your evaluation, go to our Evaluation page and choose Vortex.

More Reading

Please refer to the GENESIS Users Guide.

Back To Top


© 1985-2013 Updated 30 Jan 2013.