-sqlize

Registers a file into the c-tree SQL Server in one single step. Using -sqlize is like using -sqlinfo followed by -sqlunlink and -sqllink. It requires the administrator password, the database name and an optional logical name to be used for the table as well as the iss file and the numeric data convention.

Usage

ctutil -sqlize file iss_file admin_password database_name [-symb=symbolic_name] [-owner=owner_name] [-prefix=table_prefix][-public[=ro]][-sign=sign_convention][-rule=rules_file]

•	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.

•	iss_file is the dictionary file. 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.

•	sign_convention identifies the numeric data convention.

o	use A for programs compiled with -dca option or without data compatibility options.

o	use D for programs compiled with -dcd option.

o	use I for programs compiled with -dci option.

o	use M for programs compiled with -dcm option.

o	use N for programs compiled with -dcn option.

o	use R for programs compiled with -dcr option.

 

If omitted, A is assumed

•	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.

•	rules_file identifies a file with external rules. See Defining External Rules in Faircom’s documentation for more information.