Cincom Supra Manual
1 SQL ACCESS FOR SUPRA SERVER PDM Installation Guide P 2 SQL Access for SUPRA Server PDM Installation Guide Publication Number P, 2007, 2009, 2011 Cincom Systems, Inc. All Rights Reserved This document contains unpublished, confidential, and proprietary information of Cincom.
No disclosure or use of any portion of the contents of these materials may be made without the express written consent of Cincom. See for a list of Cincom trademarks and other trademarks that may appear in Cincom product documentation. All other trademarks are trademarks or registered trademarks of their respective companies. Cincom Systems, Inc. 55 Merchant Street Cincinnati, Ohio USA PHONE: (513) FAX: (513) WORLD WIDE WEB: Attention: Some Cincom products, programs, or services referred to in this publication may not be available in all countries in which Cincom does business. Additionally, some Cincom products, programs, or services may not be available for all operating systems or all product releases.
Contact your Cincom representative to be certain the items are available to you. 3 Release information for this manual SQL Access for SUPRA Server PDM Installation Guide, P, is dated September 1, This document supports Release 2.0 of SQL Access for SUPRA Server PDM.
Cincom Technical Support for SQL Access for SUPRA Server PDM All customers Web: U.S.A customers Phone: Fax: (513) Attn: SQL Access for SUPRA Server PDM Support Mail: Cincom Systems, Inc. Attn: SQL Access for SUPRA Server PDM Support 55 Merchant Street Cincinnati, OH USA Outside of U.S.A. All: Visit the support links at to find contact information for your nearest Customer Service Center. Using this manual $ORDB refers to the directory identified by the ORDB environment variable. This will be set to the installation directory. This document may use both UNIX ($ORDB/.) and Windows (%ORDB%.) notations. Please adjust the environment variable and slashes accordingly for your platform.
4 Contents 1. Overview of SQL Access. 5 Overview SQL Access installation. 6 Site requirements. 6 Upgrading to SQL Access on Windows. 28 Testing the CID Adapter Server installation To test the CID Adapter Server installation, follow these steps: 1.
Select START Programs SQL Access from the Windows Taskbar. Then click on Visual SQL. This will bring up the Visual SQL tool that can be used to create Foreign Tables, which map a PDM or CICS VSAM file.
You will see the dialog box to logon to the SQL Access Server. Enter the SQL Access Server name that you defined during the Windows Server installation (step 13 of 'The SQL Access Server installation option' on page 14), if it isn t already displayed.
Enter dba for the User Name, leave Password blank, and click Open. The product is delivered without a password. Refer to the Visual SQL chapter of the SQL Access for SUPRA Server PDM SQL Reference Guide, P, to create a password. Installation Guide, P. You will now be back at the tree view of the server. Click on the foreign database name and you will see two categories: - Mapped to Foreign Tables - Not Mapped to Foreign Tables The fact that you see these two categories indicates that you have successfully connected to the CID Adapter Server and it has returned a list of files.
Click on Not Mapped to Foreign Tables and you will see a list of all your PDM and/or VSAM files. Choose one of the files that you would like to access and click on it to create a foreign table (map of the PDM or VSAM file). Installation Guide, P. The Create Foreign Table dialog box allows you to modify the foreign table name and foreign table attribute names that will be exposed to the client application.
For further details review the Visual SQL chapter of the SQL Access for SUPRA Server PDM SQL Reference Guide, P For the test, you could accept the defaults and click Create Foreign Table. You have already tested the connection to the CID Adapter Server by retrieving the PDM or VSAM file names and field names for the above foreign table.
Now you can test the retrieval of data from those files. You can test them in Visual SQL or with a client application.
Cincom Supra Manual Transmission
Installation Guide, P.
Cincom SupportWeb is an Internet-based system designed to help you answer your product- and usage-related questions about Cincom products. Cincom SupportWeb is your link to some of the same information Cincom's Product Support personnel use to answer questions and solve problems.
Cincom Supra Manual Lock
It is available virtually 24 hours each day. Cincom SupportWeb allows you to do the following:.
Cincom Supra Manual Swap
Search for problem resolutions and fixes. Submit new problem cases and track the status of your company's cases. Enter messages or information for Cincom support personnel. View your customer profile information and update your company's contacts.
Access Cincom's FTP site to download fixes Cincom SupportWeb is provided free of charge to Cincom customers who are authorized to use Cincom Support. If you have not yet registered to use Cincom SupportWeb, please take a few moments to complete the registration form.
You will be asked to provide a UserId and Password which you will use to access Cincom SupportWeb. You will be notified by email when your registration has been completed (usually within about one business day).
Please note that the UserId and Password are case-sensitive and must be entered exactly as provided on the registration form.