home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
OS/2 Shareware BBS: Product
/
Product.zip
/
DB-OSDBM.ZIP
/
DB-OSDBM.DOC
next >
Wrap
Text File
|
1991-12-05
|
5KB
|
133 lines
DB-OSDBM
Joseph R. McVerry
8004 Selfridge Ct
Raleigh NC 27615-4721
This software package is supplied AS IS.
Joseph R. McVerry does not warrant that the functions contained in
this program meet any specific requirements or that they are
error free.
In no event will Joseph R. McVerry be liable for any damages
arising from the use of this program.
The user assumes sole and complete responsibility for
its use.
Copyright 1991 - Joseph R, McVerry Raleigh, NC USA
All rights reserved.
Please register your copy by sending $75.00 to the above address.
This will support my software and maybe I can write a PM version
of the program.
Trademarks.
dBASE III is a trademark of Ashton-Tate Corporation.
dBASE III is a trademark of Borland Corporation.
IBM is a trademark of International Business Machines
Corporation.
OS/2 is a trademark of International Business Machines
Corporation.
REXX is a trademark of International Business Machines
Corporation.
Description: DB-OSDBM is a complete dBASE III to OS/2 EE 1.3
Database Manager file conversion utility. The program reads a
dBASE III DBF file. DB-OSDBM creates an OS/2 CMD file and a data
delimiter file.
When you run this CMD file OS/2 creates an EE 1.3 Database
Manager file, imports the dBASE data the DBF file, and if
included creates indexes as specified in the dBASE NDX files.
DB-OSDBM process dBASE III DBF, dbt and NDX files to create
OS/2 CMD and DEL files. Path names are not supported. Be sure to
run the program in the directory containing the dBASE files.
The OS/2 CMD file contains the OS/2 REXX code and imbedded SQL
code to build and import the former dBASE III file.
The OS/2 DEL file contains the former dBASE III data including
memo fields.
format: DB-OSDBM [options] DB3filename [DB3indexfilename ...]
options:
/D:database - specifies the OS/2 DB database name.
/Q:qualifier - specifies the qualifier associated with
table.
/T:tableid - specifies the table id.
The default for /D /Q /T is the filename prefix.
/I:importmsgfile - specifies the message file for the import
function. The default is CON. The message file name is added to
the SQL IMPORT code in the REXX command file.
/F:fieldnaming - specifies the default character added to
field names that are reserved words. Default is $.
/V - specifies that all character fields are VARIABLE
length.
/MLV - specifies that memo fields are created as LONG
VARCHAR. LONG VARCHAR are special fields. You will not be able to
view these fields using Query Manager.
/m: - specifies the memo length for VARCHAR when not using
the option /MLV. Default is 4000. Remember that the largest row
size is 4005 characters.
/u - specifies indexes are create as UNIQUE.
/x - specifies NOT to include DELETED data in delimiter
file.
DB3filename is the dBASE III file name. Path names not
supported.
DB3indexfilename is the dBASE III index file name.
Conversion considerations:
dBASE III SQL Field
Field Type Definition Action
CHAR CHAR Length is specified as in dBASE.
CHAR VARCHAR If /V option is specified. Length is
specified as in dBASE.
NUM SMALLINT If field length is less than 5 and
no decimal positions specified.
NUM INTEGER If field length is less than 10 and
no decimal positions specified.
NUM DECIMAL If decimal positions specified or
field length is equal to or greater than
10.
LOGIC CHAR Length of one. There are no logic fields
in EE Data Manager.
MEMO LONG VARCHAR If /MLV option is specified.
MEMO VARCHAR If /MLV option is not specified. This is
the default action. Default field length is
4000. Field length can be changed by using
the /m option.
DATE DATE Direct conversion.