The following sections describe the variables available for base, upgrade and add-on configurations with respect to the SQL Web Connect feature.
SYSSQL = YES
NO ◄─
The SYSSQL variable governs the creation of System SQL Catalog within the APPLDICT dictionary, on a ‘Base’ installation. The SQL Catalog is a required component for using SQL with SQL WEB Connect. Users who have purchased the CA IDMS SQL Option automatically receive this component.
SQLDEMO = YES
NO ◄─
The SQLDEMO variable governs the creation of the SQL version of the Employee Skills Demo Database on a ‘Base’ installation.
UPGSYSQL = YES
NO ◄─
The UPGSYSQL variable governs the creation of System SQL Catalog within the APPLDICT dictionary, on an ‘Upgrade’ installation. The SQL Catalog is a required component for using SQL with SQL WEB Connect.
Users who purchased the CA IDMS SQL Option normally already have this component, just like Visual DBA users.
The addition of the SQL Catalog requires updates to both the global DMLC and Database name Table of your CV.
UPGQDEMO = YES
NO ◄─
The UPGQDEMO variable governs the creation of SQL version of the Employee Skills Demo Database on an ‘Upgrade’ installation.
Specify NO if you have already installed the SQL version of the Employee Skills Demo Database. The Employee Skills database has not changed since Release 12.0.
The addition of the Employee Skills database requires updates to both the global DMLC and Database name Table of your CV.
ADDSYSQL = YES
NO ◄─
The ADDSYSQL variable governs the creation of System SQL Catalog within the APPLDICT dictionary, on an ‘Add-On’ installation. The SQL Catalog is a required component for using SQL with SQL Web Connect.
The addition of the SQL Catalog requires updates to both the global DMLC and Database name Table of your CV.
ADDQDEMO = YES
NO ◄─
The ADDQDEMO variable governs the creation of the SQL version of the Employee Skills Demo Database on an ‘Add-On’ installation.
The addition of the Employee Skills database requires updates to both the global DMLC and Database name Table of your CV.
This Documentation, which includes embedded help systems and electronically distributed materials, (hereinafter referred to as the “Documentation”) is for your informational purposes only and is subject to change or withdrawal by CA at any time. This Documentation is proprietary information of CA and may not be copied, transferred, reproduced, disclosed, modified or duplicated, in whole or in part, without the prior written consent of CA.
If you are a licensed user of the software product(s) addressed in the Documentation, you may print or otherwise make available a reasonable number of copies of the Documentation for internal use by you and your employees in connection with that software, provided that all CA copyright notices and legends are affixed to each reproduced copy.
The right to print or otherwise make available copies of the Documentation is limited to the period during which the applicable license for such software remains in full force and effect. Should the license terminate for any reason, it is your responsibility to certify in writing to CA that all copies and partial copies of the Documentation have been returned to CA or destroyed.
TO THE EXTENT PERMITTED BY APPLICABLE LAW, CA PROVIDES THIS DOCUMENTATION “AS IS” WITHOUT WARRANTY OF ANY KIND, INCLUDING WITHOUT LIMITATION, ANY IMPLIED WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, OR NONINFRINGEMENT. IN NO EVENT WILL CA BE LIABLE TO YOU OR ANY THIRD PARTY FOR ANY LOSS OR DAMAGE, DIRECT OR INDIRECT, FROM THE USE OF THIS DOCUMENTATION, INCLUDING WITHOUT LIMITATION, LOST PROFITS, LOST INVESTMENT, BUSINESS INTERRUPTION, GOODWILL, OR LOST DATA, EVEN IF CA IS EXPRESSLY ADVISED IN ADVANCE OF THE POSSIBILITY OF SUCH LOSS OR DAMAGE.
The use of any software product referenced in the Documentation is governed by the applicable license agreement and such license agreement is not modified in any way by the terms of this notice.
The manufacturer of this Documentation is CA.
Provided with “Restricted Rights.” Use, duplication or disclosure by the United States Government is subject to the restrictions set forth in FAR Sections 12.212, 52.227-14, and 52.227-19(c)(1) - (2) and DFARS Section 252.227-7014(b)(3), as applicable, or their successors.
Copyright © 2014 CA. All rights reserved. All trademarks, trade names, service marks, and logos referenced herein belong to their respective companies.
|
Copyright © 2014 CA.
All rights reserved.
|
|