Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » Context-Sensitive Help » SQL Anywhere plug-in help » SQL Anywhere properties windows

 

Plug-in Preferences window: General tab

This window has the following components:

  • Settings   The preferences on the General tab govern how SQL Anywhere responds when you perform specific tasks in Sybase Central:

    • Warn when connecting to a read-only database   Select this preference to be warned when you are connecting to a read-only database.

    • Warn when connecting as a user without the PUBLIC system role (version 16 databases only)   Select this preference to be warned when you are connecting with a user ID that does not have the PUBLIC system role. You must log in as a user with the PUBLIC system role to use Sybase Central.

    • Warn when connecting as a user without DBA authority (version 12 and earlier databases only)   Select this preference to be warned when you are connecting with a user ID that does not have DBA authority. You must log in as a user with the DBA authority to enable all plug-in functionality.

    • Warn when connecting to a server version that is newer than the version of the plug-in   Select this preference to be warned when you are connecting to a server whose version is newer than the version of the plug-in.

    • Warn when including a column with an approximate data type in an index or text index   Select this preference to be warned when a column with an approximate data type is included in an index. It is recommended that you do not use approximate data types such as FLOAT and DOUBLE for primary keys or for columns with unique constraints. Approximate numeric data types are subject to rounding errors after arithmetic operations.

    • Warn when including a column with a spatial data type in a text index   Select this preference to be warned when a column with a spatial data type is included in an index or text index. See Indexes on spatial columns.

    • Warn when creating or renaming an object if a SQL reserved word is used as the object name   Select this preference to be warned when you are creating or renaming an object that has a SQL keyword in its name.

    • Warn when modifying the SQL for a materialized view   Select this preference to be warned when you modify a materialized view.

    • Warn when modifying an active LDAP server   Select this preference to be warned when you try to modify an active LDAP server.

    • Warn when choosing the JDBC connection type for a remote server if support is deprecated by the database server   Support for remote servers that use the JDBC connection type is deprecated for SQL Anywhere version 12 and later database servers. Select this preference to be warned when you choose a JDBC connection type for a remote server.

    • Inform when the SQL editor automatically reformats the beginning of a SQL statement   Select this preference to be informed when the SQL editor automatically reformats the beginning of a SQL statement.

    • Inform when a breakpoint is hit while debugging   Select this preference to be notified when a breakpoint is hit when you are working in Debug mode.

    • Inform when a statement is canceled while debugging   Select this option to be notified when a statement is canceled when you are working in Debug mode.

    • Confirm adding user to group via clipboard and drag-and-drop operations   Sybase Central allows you to use drag-and-drop operations and copy and paste operations to add users and groups.

      Select this preference if you want Sybase Central to prompt you before a user or role is added by dragging and dropping or by copying and pasting.

    • Confirm granting of object privileges via clipboard and drag-and-drop operations   Sybase Central allows you to use drag-and-drop operations and copy and paste operations to grant object privileges on tables, views, procedures, and functions to users or roles.

      Select this preference if you want Sybase Central to prompt you before privileges are granted to a user or role by dragging or copying and pasting them to a table, view, procedure, or function.

    • Confirm creation of SQL Remote subscriptions via clipboard and drag-and-drop operations   Sybase Central allows you to use drag-and-drop operations and copy and paste operations to create SQL Remote subscriptions for remote users and consolidated users.

      Select this preference if you want Sybase Central to prompt you before you subscribe a remote user or consolidated user to a publication by dragging or copying and pasting the user to a publication.

    • Confirm creation of MobiLink synchronization subscriptions via clipboard and drag-and-drop operations   Sybase Central allows you to use drag-and-drop operations and copy and paste operations to create synchronization subscriptions for MobiLink users.

      Select this preference if you want Sybase Central to prompt you before you subscribe a MobiLink user to a publication by dragging or copying and pasting the MobiLink user to a publication.

    • Confirm deletions when editing table data   Select this preference if you want SQL Anywhere to prompt you before table data is deleted on the Data tab in Sybase Central.

    • Confirm updates when editing table data   Select this preference if you want SQL Anywhere to prompt you before table data is updated on the Data tab in Sybase Central.

    • Confirm inserts when adding table data   Select this preference if you want SQL Anywhere to prompt you before table data is inserted on the Data tab in Sybase Central.

    • Confirm implicit updates when editing table data   Select this preference if you want SQL Anywhere to prompt you before implicit updates are made in Sybase Central. Implicit updates are made when you are editing a row on the Data tab and then click anywhere else in Sybase Central outside the row you are currently editing.

    • Confirm cancellations when editing table data   Select this preference if you want Sybase Central to prompt you when you cancel changes to table data on the Data tab in Sybase Central.

    • Show an information message when a maintenance plan is started   Select this preference if you want Sybase Central to show an information message when you start a maintenance plan by selecting it and choosing Run Now from the menu.

    • Show a warning message when modifying or deleting an event associated with a maintenance plan   Select this preference if you want Sybase Central to show a warning message when you modify or delete an event associated with a maintenance plan.

    • Inform if attempting to modify a non-editable object privilege   Select this preference if you want Sybase Central to show a message when you attempt to modify an object privilege that was granted by another database user.

    • Inform if revoking an object privilege for a user automatically revokes it for other users   Select this preference if you want Sybase Central to show a message who also had WITH GRANT OPTION for that privilege and granted the privilege to other users. When you revoke the object privilege from that user, then everyone who that user granted the privilege to also has their privilege revoked.

  • Restore Defaults   Click this button to return the preferences on this tab to their default values (selected or cleared). By default, all the preferences on this tab are selected.