ctsqlimp Usage

ctsqlimp is used as follows (after creating the database file):

ctsqlimp <filename> [-d database] [-s server] [-u userid] [-a password]
         [-n symbolic] [-o userid]
         [-i] [-r] [-k] [-c] [-x] [-p] [-z] [-g] [-b] [-j]
         [-w script] [-m idxname] [-e xmlfile] [-f s|z|sz] [-l size] [-q prefix]
         [-h]

• <filename>: data file name/path (relative paths to c-treeACE SQL directory)
• -d database : database name (default: ctreeSQL)
• -s server: c-treeACE SQL Server name (default: FAIRCOMS)
• -u userid: userid for logging into c-treeACE SQL
• -a password: password for authorization
• -n symbolic: set SQL table name to symbolic symbolic
• -o userid: set owner of table to userid
• -i: non interactive mode: ignore errors and continue
• -r: remove existing linked table (file is not deleted)
• -k: skip fields that don't comply with conventional identifiers rules
• -c: allow table names not complying with conventional identifiers rules
• -x: skip indices
• -p: promote unsigned integer to greater signed type
• -z: allow indices with missing string terminator in key segments
• -g: ignore existing index name in IFIL resource
• -b: grant public access permissions to imported table
• -j: non-interactive relink of existing table
• -w script: write creation statements into file script instead of importing the table
• -m idxname: set index idxname as primary key
• -e xmlfile: get DODA definitions from external XML file xmlfile
• -f s | z | sz: force string padding to (s)paces (z)eroes or (sz)spaces zero terminated
• -l size: specify LONGVAR* field size threshold
• -n symbolic: Specify a symbolic name that is different form the <filename>
• -q prefix: prefix SQL table name with prefix (when the -q option is combined with the symbolic table name option, -n, the prefix is prepended to the symbolic name instead to the table name)
• -h: display usage help

Note: The parameters are case-sensitive. By default they are lower case unless otherwise stated.

Example

To make existing c-tree files mydata.dat (containing proper IFIL and DODA resources) and mydata.idx accessible via c-treeACE SQL, follow these steps:

1. Create a database named ctreeSQL.
2. Copy your ISAM custmast.dat and custmast.idx files into the ctreeSQL.dbs subdirectory of the server's working directory.
3. Ensure c-treeACE SQL is running, as ctsqlimp is a client application.
4. Run the ctsqlimp utility found in the /tools/cmdline/admin/client/ directory of your c-treeACE installation:

   ctsqlimp custmast.dat -u ADMIN -a ADMIN -s FAIRCOMS

5. Run the Interactive SQL, isql, utility and issue the command:

   SELECT * FROM custmast;