-sqllink

Links a physical file into c-tree SQL Server database. It requires the administrator password, the database name and optionally a logical name to be used for the table. If the last parameter is not provided, the table on the database will be called the same way of the disk file.

After the link operation, the physical file can be interfaced as standard ISAM file by isCOBOL Framework and as database table from SQL clients.

Usage

ctutil -sqllink file admin_password database_name [-symb=symbolic_name] [-owner=owner_name] [-prefix=table_prefix][-public[=ro]]

•	file is the name of the c-tree file. The default file extension (that is ".dat" if not configured differently) must be omitted. Relative paths are resolved according to the c-tree server working directory.

•	admin_password is the password of the administrator user.

•	database_name is the name of the destination SQL Server database.

•	the -symb option allows to specify the name for the resulting table. By default, the table has the same name as the disc file.

•	the -owner option allows to specify a specific table ownership.

•	the -prefix option allows to specify a prefix that will be put before the table name in the database. For example, if you link a file named “file1” with -prefix=myprefix, you obtain a table named “myprefixfile1” in the database.

•	the -public option grants public access permissions on the resulting table. Use -public=ro to indicate read-only permissions to all SQL users. Admin users are always able to modify a c-tree file.