c-treeRTG COBOL Edition User's Guide

-sqlrefresh

Preserves existing information about the table (synonyms, grants, etc.) when relinking into SQL.

Usage:

-sqlrefresh file xfd_file database_name

[-symb=table_name] [-prefix=table_prefix]

[-owner=user_name] [-conv=convention_ID]

[-rule=rules_file]

Description:

The ctutil -sqlrefresh command is very similar to the -sqlize command. The -sqlrefresh command has these properties:

1. It can be used only if the table was already sqlized.
2. It refreshes the table structure maintaining the existing grants and synonyms.
3. It does not support the "public" option available in -sqlize since authorizations are kept from the original sqlize and grant occurred in SQL.

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