We recommend you try our Java version called xBaseJ. There are two versions:
RexxBase is a Rexx External Interface DLL that allows OS/2 V2.x and WARP command procedures to access dBase III and IV files. Rexx programs can control files by reading, writing and updating data fields directly.
RexxBase provides support for DBF, DBT, NDX and MDX files.
System requirements:
| Function | Description |
|---|---|
| Rexxbase_Init | initialize RexxBase routines to the REXX Environment. |
| Rexxbase_ShutDown | release RexxBase routines from the REXX Environment. |
| Rexxbase_OpenDBF | open a dBase file and associated index file. |
| Rexxbase_ReadDBF | read a dBase record. |
| Rexxbase_ReadPrevDBF | read previous dBase record. |
| Rexxbase_WriteDBF | write a new dBase record. |
| Rexxbase_UpdateDBF | updates a record. |
| Rexxbase_CloseDBF | closes a dBase file. |
| Rexxbase_CreateDBF | creates a dBase file. |
| Rexxbase_CreateFromDBF | creates a dBase file based on the structure of an existing file. |
| Rexxbase_ModifyDBF | modify the structure of a dBase file. |
| Rexxbase_SortDBF | sorts a database on several fields. |
| Rexxbase_ExportDBF | export a dBase file to an ASCII delimited file. |
| Rexxbase_ImportDBF | imports a dBase file from an ASCII delimited file. |
| Rexxbase_GoToRecord | read a record based on its position in the database. |
| Rexxbase_FindRecord | read a record based on an index. |
| Rexxbase_PackDBF | remove deleted records and reorganize a database. |
| Rexxbase_DeleteRecord | mark a record as deleted. |
| Rexxbase_UndeleteRecord | unmark a record as deleted. |
| Rexxbase_CreateIndex | created an index file. |
| Rexxbase_ReindexDBF | reindex a corrupted index file. |
| Rexxbase_SetIndexTagName | sets a MDX tag field as the primary index. |
| Rexxbase_CreateMultipleIndexFile | creates an MDX tagged file. |
| Rexxbase_AddTagToIndex | adds a tag field to a MDX file. |
| Rexxbase_DropTagFromIndex | removes a tag field from a MDX file. |
| Rexxbase_CloseAllDBF | closes all open dBase files. |
| Rexxbase_FilterDBF | filter function for read routines. |
| Rexxbase_ScanForRecord | search through the database until the search logic is true. |
| Rexxbase_ChangePrimaryIndex | make a secondary index the primary index. |
| Rexxbase_Soundex | return a 4 byte SOUNDEX string based from input. |
| Rexxbase_SummarizeDBF | Sorts and summarizes a database based on the sort fields. |
| Rexxbase_JoinDBF | create (physical or virtual) dBase file from two dBase files. |
| Rexxbase_ReadAndLockDBF | read a record and set a record lock. |
| Rexxbase_ReadAndLockPrevDBF | read previous record and set a record lock. |
| Rexxbase_GoToAndLockDBF | read a specific record and set a record lock. |
| Rexxbase_FindAndLockPrevDBF | find and read a record and set a record lock. |
| Rexxbase_LockDBF | locks the current record. |
| Rexxbase_UnlockDBF | used to release record not updated. |
| Rexxbase_SetLockTimeout | sets time out limit for locked records. |
| Rexxbase_FormatDate | format a date based on NLS (National Language Support.) |
| Rexxbase_InternalDate | change a NLS formatted date to a dBase date. |
| Rexxbase_DaysDifference | calculate the differences between two dates. |
| Rexxbase_DateCalc | calculate a date based on a date and an integer. |
| Rexxbase_DayOfWeek | calculate the day of the week for a date. |
RexxBase generates dBase field names and values that are available directly to a Rexx program. The Rexx program can change this data and update dBase files directly. Also database file control information is available to the Rexx program. This information includes such data as last date the database was updated, number of records on file, field names, etc.
Along with the DLL file, the package contains a executable program to provides simple front-end to database development.