◄Contents►  ◄Index►  ◄Back►
──────────────────────────────────────────────────────────────────────────────
                 ISAM available in Professional Edition only
──────────────────────────────────────────────────────────────────────────────
 ISAMIO.EXE converts ISAM database tables to ASCII text files, or ASCII text
 files to ISAM database tables.
 
    ISAMIO {option1} asciifile databasename tablename specfile {option2}
 
    ■ option1        One option from the list below must be specified:
 
      Option         Description
      ═══════════    ═══════════════════════════════════════════════════════
      /? or /H       Displays help for the ISAMIO utility; anything following
                     these options on the command line is ignored
      /E             Specifies ASCII text file to create from ISAM table
      /I             Specifies ISAM table to create from ASCII text file
 
    ■ asciifile      Name of ASCII file to import (/I) or export (/E)
 
    ■ databasename   Name of database into which the table should be
                     placed (/I), or from which the data for the ASCII file
                     should be taken (/E)
 
    ■ tablename      Name of table within database file into which records
                     from the ASCII file should be placed (I), or from which
                     the data for the ASCII file should be taken (/E)
 
    ■ specfile       Required only when converting Btrieve files:
 
                     basictype, size, columnname
 
                     • basictype     Term used by Btrieve to identify the
                                     data type
 
                     • size          Length of field in the Btrieve format;
                                     size is ignored for all types except
                                     STRING
 
                     • columnname    Any valid ISAM column name
 
    ■ option2        You can specify /A or /C but not both; /F is always
                     optional:
 
      Option         Description
      ═══════════    ═══════════════════════════════════════════════════════
      /A             Specifies that data being imported (/I) should be
                     appended to tablename. If tablename does not exist, an
                     error message is displayed. If /A is not specified,
                     ISAMIO imports the data into the named table based on
                     the table description given in specfile. If no specfile
                     is named (or found), an error message is displayed.
      /C             When an ISAM table is being imported (/I) from an ASCII
                     file, /C specifies that the table's column names should
                     be taken from the first row of data in the ASCII file;
                     if omitted, ISAMIO interprets the first row as the
                     beginning of data records and looks for column names in
                     specfile.
      /E             When an ISAM table is being exported (/E), /C specifies
                     that the table's column names should appear in the ASCII
                     file as the first row of data; if omitted, column names
                     are not exported.
      /F[: width]    Stipulates the size of fixed-width fields in the data
                     being imported (/I) or exported (/E); if omitted, fields
                     are assumed to be comma-delimited. Note: When exporting,
                     width specifies the width of binary fields; the default
                     width is 512.
 
 See Also
    ◄Command-Line Options►