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.
The Operator Training Tutorial uses a software program and a manual to guide. An overview of Cincom's Supra relational data base management system. 2 SQL Access for SUPRA Server PDM Installation Guide Publication Number P, 2007, 2009, 2011 Cincom Systems, Inc. All Rights Reserved This document.
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. Installation Guide, P.
Cincom Smalltalk™ Cincom is the world leader in Smalltalk application development software, web application development tools and deployment environments. Cincom® ObjectStudio® is an ideal solution for Windows®-centric application development. Cincom® VisualWorks® will assist those looking for enterprise-level, cross-platform, custom application development that connects everything. Cincom Smalltalk cuts the complexity that complicates software development while accelerating your potential for profitable growth. Robust development tools help you create value at the lowest possible risk and assures you of the fastest return on investment. MANTIS® MANTIS is an application development platform that enables you to deploy anywhere across multiple environments, including mobile and Android.
Cincom Supra Manual
It addresses all aspects of application development, including creation, maintenance, modernization and integration. MANTIS enables you to develop new graphical and web-based business applications, and allows you to browser-enable your existing MANTIS applications with very little effort. Quick and easy development of business applications across all major computing platforms (Android, Windows, Linux, UNIX, z-Series and OpenVMS). The three major components of MANTIS (MANTIS Server, MANTIS Web and MANTIS Studio) address all aspects of application development (creation, maintenance, modernization and integration). User benefits range from enhanced functionality for legacy applications to mainframe application modernization and mobile business applications. Integration with SAP and Oracle. Cincom SUPRA® Cincom SUPRA is mainframe database management software designed for high-volume, online transaction processing.
Cincom Supra Manual Lock
Here’s how our customers are using SUPRA. Integrate and analyze operational data to make better business decisions. Effectively manage operational data with Cincom SUPRA PDM’s networked, hierarchical, interactive database management system. SUPRA SQL is Cincom’s ANSI-compliant relational database management system used for the deployment of high-performance data access applications. Access your SUPRA data using standard SQL tools for reporting and business intelligence.
Write Java, Visual Basic and COBOL applications using standard SQL interfaces.