PROFESSIONAL APPLICATION CREATION ENVIROMENT PACE/CULLINET CONNECTION

• Document Type: CREST
• Collection: General CIA Records
• Document Number (FOIA) /ESDN (CREST): CIA-RDP90-00191R000100060043-0
• Release Decision: RIFPUB
• Original Classification: K
• Document Page Count: 4
• Document Creation Date: December 23, 2016
• Document Release Date: October 24, 2013
• Sequence Number: 43
• Content Type: MISC

Declassified and Approved For Release 2013/10/24: CIA-RDP90-00191R000100060043-0
\ftiof
WANG
vs
Professional Application Creation Environment
PACE/Cullinet Connection
HIGHLIGHTS
? !Direct access to_IBM_Inain-
rframe c?ia.Tfin VS Professional
Afiplia-lion Creation Environ-
ment ((PAM Query
? Minimal need for familiarity
with the IBM or Cullinet? soft-
ware environment
? Only selected recoaraind
cfield are returned - no file)
1,0ownloading requirecl
? All output options of PACE
QueW supported including inter-
fa to PACE Report, Wang
ord Processing, the VS
raphics Facility, and Wang VS
20/20
? SNA communications
support
OVERVIEW
The PXCETCaii--iet Connection7
igfPACE users a link
between PACE and corporate
data residing on an IBM n_=!Aiiji-
lframe,khat is defined to
Cullinet and IDMS are registered trade-
marks of Cullinet Software, Inc.
Cullinet's Information Data Base7
i(IDB)JIDB is one component of
Cullineff Information Celite7-7
Management System (C/ICMS)
To retrieve data from IDB you
simply use PACE Query to
,create and execute queries
against the mainframe data. The
query process is the same as that
used to access PACE tables. All
of the Cullinet IDB tables that
an individual user is authorized
to access are displayed along with
PACE tables.
The PACE/Cullinet Connec-
tion is a transparent bridge
between PACE Query and
Cullinet's IDB, that provides
access to data stored on the IBM
mainframe including IDMS/R8,
VSAM, or extracts of DL1, IMS,
and TOTAL? data bases. Utili-
ties running under PACE
Manager establish the connec-
tions among the network soft-
ware, the IBM system, and
Cullinet's IDB, making the inter-
face transparent to the end user.
The VS communications software
that supports the PACE/Cullinet
Connection is 3274 Emulation for
SNA communications.
PACE/CULLINET
CONNECTION FEATURES
[Ease of Use 7
? T,r.arent Accl There
is no requirement for the end
user to be familiar with the IBM
or Cullinet software environment.
A PACE Query user's IDB
knowledge need only include an
IDB user identification and pass-
word for the catalog. Tables and
fields the end user is authorized
to access are automatically
displayed.
Eas*to Use Administrationj
Screens_jthe PACE/Cullinet
Connection comes with a set of
menus with which to establish
the relationships among the
network transport information,
the IBM system information, and
the IDB catalog information.
After these relationships are
established, the end user can
retrieve data transparently from
the IBM mainframe. No dupli-
cate dictionary information is
required. All information is inter-
actively, but transparently,
retrieved from the IBM main-
frame.
? Simi/aritr"-- All
IBM mainframe data is pres-
ented in the same format as
PACE tables. No additional data
base management system knowl-
edge is required.
POWERFUL QUERY
CAPABILITIES
? Mininzvnlothding
? PACE Queryprovides you
with the ability to select only
those records and fields that you
require. Downloading of entire
files from the IBM mainframe is,
therefore, unnecessary. From a
TOTAL is a registered trademark of
Cincom Systems, Inc.
20120 is a trademark of Access Technol-
ogy, Inc. . ?
Declassified and Approved For Release 2013/10/24: CIA-RDP90-00191R000100060043-0 ?
Declassified and Approved For Release 2013/10/24: CIA-RDP90-00191R000100060043-0
I '
performance standpoint, this
minimizes the amount of data to
be sent. From a security stand-
point, only the data the user
needs and has authority to access
is sent to the VS.
? Integration of PACE and IDB
Data ? PACE Query users can
construct queries that integrate
PACE data with IBM mainframe
data. This enables you to
augment local PACE applications
with central corporate informa-
tion, eliminating storage redun-
dancy and providing up-to-the-
minute information.
INTEGRATION OF
CORPORATE DATA WITH
PACE AND OFFICE
FUNCTIONS
? PACE Report Integration ?
Queries can be formatted into
professional-looking reports using
PACE Report.
? DMS File Creation ? The
output of the query can be saved
as DMS data and control files
that can then be easily converted
into a PACE table or a 20/20"
spreadsheet. In addition, data
can be transformed into various
formats to be processed by any
PC supported by the PC/VS Data
Exchange Utility.
? VS Graphics Facility ? The
answer to a query can be
graphed using the VS Graphics
Facility.
? WP Integration ? A query
result can be automatically trans-
formed into a Wang WP docu-
ment or a WP merge document.
ACCESSING IBM
MAINFRAME DATA
PACE remote data bases can be
created pointing to Cullinet IDB
catalogs that are accessible to
PACE Query. When one of those
data bases is selected, the user is
prompted for an IDB user ID
and catalog password. The system
displays a list of all the tables the
user is authorized to access, and
after the user selects a table, all
the fields within that table are
displayed. The user can define
selection conditions for the query
and an answer table for the
result.
The final query can be saved
and executed at a later time. In
addition, the user can exercise
the many query output options
including formulation of a PACE
Report, creation of a WP docu-
ment or merge document,
creation of a graph with the VS
Graphics Facility, or creation of a
DMS data and control file that
can be converted to a PACE
table or a 20/20 spreadsheet.
INTEGRATING PACE AND
MAINFRAME DATA
WITHIN A QUERY
The PACE/Cullinet Connection
enables you to include both local
and remote data within the same
query. While selecting tables
from any PACE data base, you
can select a PF key option to
access a remote data base. When
you select this option, the system
displays a list of remote data
bases to choose from. After you
select a remote data base, and
enter IDB user information, the
system then displays all the IDB
tables that you have authority to
access, along with the PACE
tables you have selected. You can
then query a remote table or a
PACE table. Multiple queries can
be executed to combine query
results.
PACE/CULLINET
CONNECTION
ADMINISTRATION
PACE Manager provides a set of
menus enabling the administrator
to establish the connections
between the PACE data bases,
the VS 3270 Emulation software,
the IBM system, and Cullinet's
Information Data Base. The
menus include:
? Transport menus ? Defining
the parameters necessary for SNA
telecommunications software. The
parameters are used to access the
transports without user interac-
tion, when a PACE Query user
selects a remote data base.
? New PACE Manager menus
? Enabling an administrator to
establish the relationship among
the IDB Catalog names, the IBM
system in which they reside, and
IDMS/DC or CICS information.
? PACE Manager Data Base
Creation menu ? Provides an
option enabling a data base
administrator to create remote
data bases through an interactive
screen. The administrator simply
selects the IDB catalog to be
connected to the PACE remote
Declassified and Approved For Release 2013/10/24: CIA-RDP90-00191R000100060043-0
Declassified and Approved For Release 2013/10/24 ? CIA-RDP90-00191R000100060043-0
PACE/Cullinet Connection
IBM or Compatible
Mainframe
Environment
._
Other
IMS
DUI
TOTAL
Data
Sources
Cullinet's
C/ICMS
SNA Data
Communications Link
VS
Environment
PACE Query
20/20
Spreadsheet
Wang
OFFICE
DMS
File/
PACE
Table
Word
Processing
PACE
Report
VS
Graphics
Facility
PC
Environment
VS/PC
Data
Exchange
Utility
PC
Figure 1.
Declassified and Approved For Release 2013/10/24: CIA-RDP90-00191R000100060043-0
Declassified and Approved For Release 2013/10/24: CIA-RDP90-00191R000100060043-0
WANG
ONE INDUSTRIAL AVENUE
LOWELL, MASSACHUSETTS 01851
TEL. [phone]
TWX 710-343-6769, TELEX 94-7421
data base that is created. PACE
Query users of this data base are
automatically shown all the tables
that they are authorized to access
in the catalog based on their IDB
user ID.
The diagram, shown in Figure
1, illustrates a logical view of the
PACE/Cullinet Connection.
SUMMARY
The PACE/Cullinet Connection
enables PACE Query users to
access PACE tables and IBM
mainframe data stored under
Cullinet's Information Data Base.
The functions of PACE Query
that are supported include:
? Relational retrieval capabilities
including project, select, and join
? WP and WP merge document
creation
? Reporting capabilities through
PACE Report
? Graphics through the VS
Graphics Facility
? Creation of DMS data and
control files that can be
converted to PACE tables, 20/20
spreadsheets, or downloaded to
any PC supported by the PC/VS
Data Exchange Utility.
The ability of the PACE/
Cullinet Connection to insulate
end users from IBM and Cullinet
software brings the power of
corporate information to the
PACE and VS software environ-
ment.
Standard Warranty Applies
Wang Laboratories, Inc., reserves the right to change specifications without prior notice.
Copyright C 1986, Wang Laboratories, Inc. Printed ,i45u6s6.6t
Declassified and Approved For Release 2013/10/24: CIA-RDP90-00191R000100060043-0 7-86