Product Documentation

BTRV Edition User's Guide

Previous Topic

Next Topic

-sqllink

Makes an existing file accessible from SQL by linking the file name to the FairCom DB SQL dictionaries.

Usage

ctutil -sqllink file_name database_name

[-symb=table_name] [-prefix=table_prefix] [-owner=user_name] [-public[=ro]]

where:

  • file_name - File name without extension
  • database_name - Database name to be associated with the file
  • symb=table_name - Optional table name to use when adding file to a database
  • prefix=table_prefix - Optional prefix for table or symbolic name
  • owner=user_name - Optional user name to assign table ownership
  • public[=ro] - Optionally grant public access permissions, read-only when =ro is used

Note: This is an administrative operation and therefore must be performed with caution. Do not attempt to use this operation on a file that is open. The <instance user> associated with the file for a sqllink operation must have either DBA or RESOURCE SQL privileges in order for the operation to succeed or a c-treeRTG error 456 (group access denied) is returned. While strongly discouraged, backward compatibility is provided with this configuration option: COMPATIBILITY SQLIMPORT_ADMIN_PASSWORD.

Error Logging

When the ctutil -sqllink or ctutil -sqlize procedures (or an automatic "sqlize" by the COBOL driver) fail, the logic logs error messages that could help identifying issues. The ctsqlcbk.FCS file on the client will have information about the nature of the error.

TOCIndex