DBF0-1518-H0

UtilityZone (.dbf File Conversion Utility)

PRODUCT OVERVIEW

.dbf NOT supported by your transfer utility?

No support for the FILES SYSTEM?

inPROdbf/400 can give you relief!!!!

What is inPROdbf/400 (inPROdbf/400)?

INPRO International announces DBF/400 (DBF/400) Version 5.1.5 Because the typical PC file transfer products don't run in BATCH and require PC Support with no .dbf support, INPRO has developed DBF/400. Designed with performance in mind it uses the FILE SYSTEM to appear as a Network File to others on the network. WINDOWS WORKGROUP(Net Server Sharded Directories) sessions can get and put data down there in a heartbeat.

Full DDS is generated from the .DBF information and all field types are supported in either direction, including binary, packed, etc.

FEATURES

Full DBFIII, DBFIV, CSV, and XLS support
Full DDS support
All field types supported (binary, packed, etc.)
FILES SYSTEM support
Extremely low overhead based on ILE C
Easy to use COMMAND interface
ASCII-EBCDIC conversions done on the fly
Extended ASCII character set supported

ADVANTAGES

NO PC/Support required
NO File Transfer required
Simplifies conversions TO or FROM the AS/400
BATCH commands for daily operations
Network Neighborhood can access your files
Data conversions done for you
Non-standard characters for language specific countries

NOTE:This is an overview of the main concepts of inPROdbf/400.

REQUIREMENTS

OS/400 4.4.0 or higher

START HERE

After installation of inPROdbf/400 is completed, see SHARED FOLDERS STYLE INSTALLATION or NON-SHARED FOLDERS STYLE INSTALLATION options return here.
ADDLIBLE dbfexe (or simply use a qualified command DBFEXE/CVT2PC and everything else is automatic)
Prompt the command of choice, see REFERENCE MATERIAL

SAMPLE CODE

None.

REFERENCE MATERIAL

SCREEN CAPTURES

CVT2PC (Convert to PC .dbf)

NOTE:This is the command to run in inPROdbf/400 that builds a .dbf or .csv version of the AS/400 Database in the FILES SYSTEM on the AS/400 using the files DDS information (Field Name, Column Headings, Description, Data Type, Data Length, Data Decimal Positions and others. The EBCDIC to extended ASCII conversion is done on the fly.

Keyword Description

FILE This is the AS/400 physical file name and it's library. The library name can be *LIBL for library list or *CURLIB for current library or a specific library name.

MBR This is the physical file member to convert. The default is to first member (*FIRST).

TOFMT This is the format to convert to. The default is DBIII(*DBIII) format. Currently supported formats:*DBIII, *DBIV, *CVS_NOHEAD *CSV_HEADING, *XLS, *CLIPPER

PCFILE This is the name of the file to convert to. the name must be fully qualified. All directory and subdirectory names must exist. ie "/MYDOWNLOAD/FILENAME.DBF" The file system does support long file names but shared folders do not.

CVTPC2

NOTE:This is the second command to run in inPROdbf/400 and builds a full blown DDS Physical File on the AS/400. The extended ASCII to EBCDIC conversion is done on the fly. File QTEMP/INPROPF is available if you wish to use the *NONE file option on the command and copy from QTEMP with other SELECT/OMIT logic. The option for a source file allows you to specify that FULL DDS be generated along with the data being converted.

Keyword Description

PCFILE This is the name of the file to convert to. the name must be fully qualified. All directory and subdirectory names must exist. ie "/MYDOWNLOAD/FILENAME.DBF" The file system does support long file names but shared folders does not.

FROMFMT This is the format to convert to. The default is DBIII(*DBIII) format. Currently supported formats:*DBIII, *DBIV, *LABTECH_EPA_1.

FILE This is the AS/400 physical file name and it's library. The library name can be *LIBL for library list or *CURLIB for current library or a specific library name.

MBR This is the file member to convert to. The default is to first member(*FIRST).

SRCF This is the name of the file to convert header information to DDS and store it(optional).
SRCMBR This is the name of the source member to be named, usually same as file(optional).

UNLOCK PRODUCT

NOTE:This will unlock inPROdbf/400 permanently regardless of model changes. Call INPRO product support for your unlock codes.
RELATED PUBLICATIONS
None.
ERROR MESSAGES
Maximum numeric field size for most PC packages is 16 digits, inPROdbf is not limiting the field sizes or truncating fields in any way.
STATEMENT OF DIRECTION
Support for DBIII format (in prior version)
Support for DBIV format (in prior version)
Support for very early versions of DBIII (in prior version)
Support for non-standard character set (extended ASCII) (in prior version)
Support for 64 bit I/O (in prior version)
Support for .csv (in prior version)
Fix for Paradox (in prior version)
Support for EXCEL .xls format, .csv with column heading, and country code page specific conversions (in prior version)
Fix for NULL capable fields in DDS (in prior version)
Fix for NULL fields in .dbf (in prior version)
Fix for wild field names in .dbf (in prior version)
Fix for sign issues in large numeric fields in .dbf (in prior version)
Fix for trash issues (*'s) in numeric fields in .dbf (in prior version)
Support for *CLIPPER field formats on outbound side (in prior version)
Support for *LABTECH_EPA_1 field formats on inbound side (in prior version)
Support for 1 byte field names on inbound side (in prior version)
Support for *FOXPRO field formats on inbound side (in this version)
INPRO International, Inc., 701 Brazos, Suite 500, Austin, TX 78701-3232 (800) 63-INPRO, (512) 320-9107 Fax:(512) 444-4931, sales@inprointernational.com, www.inprointernational.com

Keyword	Description
FILE	This is the AS/400 physical file name and it's library. The library name can be LIBL for library list or CURLIB for current library or a specific library name.
MBR	This is the physical file member to convert. The default is to first member (*FIRST).
TOFMT	This is the format to convert to. The default is DBIII(DBIII) format. Currently supported formats:DBIII, DBIV, CVS_NOHEAD CSV_HEADING, XLS, *CLIPPER
PCFILE	This is the name of the file to convert to. the name must be fully qualified. All directory and subdirectory names must exist. ie "/MYDOWNLOAD/FILENAME.DBF" The file system does support long file names but shared folders do not.

Keyword	Description
PCFILE	This is the name of the file to convert to. the name must be fully qualified. All directory and subdirectory names must exist. ie "/MYDOWNLOAD/FILENAME.DBF" The file system does support long file names but shared folders does not.
FROMFMT	This is the format to convert to. The default is DBIII(DBIII) format. Currently supported formats:DBIII, DBIV, LABTECH_EPA_1.
FILE	This is the AS/400 physical file name and it's library. The library name can be LIBL for library list or CURLIB for current library or a specific library name.
MBR	This is the file member to convert to. The default is to first member(*FIRST).
SRCF	This is the name of the file to convert header information to DDS and store it(optional).
SRCMBR	This is the name of the source member to be named, usually same as file(optional).