Client Services Applications (CSAs) are customer written applications that enable CICS applications to access local area network (LAN) resources. This book describes how to design, code, and test CSAs.
This guide is for anyone responsible for:
Designing, coding, and testing CSAs in one of the supported programming languages (COBOL II, assembler, PL/1, or C)
Implementing CSAs in CICS
Administering Open ClientConnect™, Open ServerConnect™, or DirectConnect™
Administering database management systems
Supporting data transfer and staging
Each chapter in this book represents a task and each appendix represents reference information to help you accomplish a task. CSA examples are provided in COBOL II.
If you are not familiar with CICS and the CICS control tables, ask your CICS or system programmer to make the required CICS entries.
This book includes the following chapters:
Chapter 1, “Introduction,” provides general information about the Mainframe Connect™ mainframe access products and an overview of CSAs and how they work.
Chapter 2, “Designing a CSA,” discusses information to consider before you design a CSA.
Chapter 3, “Writing a CSA,” explains how to write a CSA.
Chapter 4, “Compiling and Testing a CSA,” explains how to compile and test a CSA.
Chapter 5, “Troubleshooting,” explains how to troubleshoot problems in your CSA program.
Appendix A, “CSA Commands,” lists and explains the CSA commands.
Appendix B, “CLIENTC2 Sample CSA,” describes a sample CSA that retrieves results and messages to the CSA through an input pipe.
Appendix C, “CSAINDX Sample CSA,” describes a sample CSA that transfers data from DB2 through DirectConnect to Adaptive Server® Enterprise.
Appendix D, “CSARESCK Sample CSA,” describes a sample CSA that sends a group of eight INSERT statements in one request buffer to Adaptive Server Enterprise and checks error messages to determine the success of the requests.
Appendix E, “The SPAREA,” explains how CSAs use SPAREA and includes SPAREA fields and SPAREA definitions.
Appendix F, “The SQLDA,” describes how CSAs use the SQLDA.
Appendix G, “Related Products and Documentation by Component,” lists of related Sybase products, related IBM products, and Mainframe Connect™ documentation.
There is also a Glossary provided at the back of the book.
The following table describes new names for products in the 12.6 release of the Mainframe Connect Integrated Product Set.
Old product names |
New product name |
|---|---|
|
Mainframe Connect Client Option for CICS |
|
Mainframe Connect Client Option for IMS and MVS |
|
Mainframe Connect Server Option for CICS |
|
Mainframe Connect Server Option for IMS and MVS |
|
Mainframe Connect DB2 UDB Option for CICS |
|
DirectConnect for z/OS |
The old product names are used throughout this book, except for on the title page.
This book also uses the terms MVS and OS/390
where the newer term z/OS would otherwise be used.
The documentation set consists of:
The Release Bulletin for your platform – contains last-minute information that was too late to be included in the books.
A more recent version of the release bulletin may be available on the World Wide Web. To check for critical product or document information that was added after the release of the product CD, use the Sybase Product Manuals Web site.
Mainframe Connect Server Option for CICS Installation and Administration Guide – describes configuring the network, installing Open ServerConnect, setting up security, and troubleshooting for an MVS-CICS environment.
Mainframe Connect Server Option for IMS and MVS Installation and Administration Guide – describes configuring the network, setting up APPC communications, installing Open ServerConnect, setting up security, and troubleshooting for an IMS or MVS environment.
Mainframe Connect Client Option for CICS Installation and Administration Guide – describes installing and configuring Open ClientConnect, routing requests to a server, and using Sybase isql. This manual also contains instructions for using the connection router and the mainframe-based isql utility.
Mainframe Connect Client Option for IMS and MVS Installation and Administration Guide – describes installing Open ClientConnect, routing requests to a server, and using Sybase isql. This manual also contains instructions for using mainframe-based isql utility.
Mainframe Connect DB2 UDB Option for CICS Installation and Administration Guide – describes configuring the mainframe, installing Mainframe Connect, setting up security, and troubleshooting for a CICS environment.
Mainframe Connect DirectConnect for z/OS Option Installation Guide – describes installing a DirectConnect server and service libraries.
Enterprise Connect™ Data Access and Mainframe Connect Server Administration Guide for DirectConnect – describes administration of the DirectConnect server. Information about administering specific service libraries and services is provided in other DirectConnect publications.
Mainframe Connect Client Option Programmer’s Reference for PL/1 – describes writing Open ClientConnect programs that call PL/I Client-Library functions. This guide contains reference pages for Client-Library routines and descriptions of the underlying concepts for PL/I programmers.
Mainframe Connect Server Option Programmer’s Reference for PL/1 – provides reference material for writing Open ServerConnect programs that call PL/I Gateway-Library functions. This guide contains reference pages for Gateway-Library routines and descriptions of the underlying concepts for PL/I programmers.
Mainframe Connect Client Option Programmer’s Reference for COBOL – describes writing Open ClientConnect programs that call COBOL Client-Library functions. This guide contains reference pages for Client-Library routines and descriptions of the underlying concepts for COBOL programmers.
Mainframe Connect Server Option Programmer’s Reference for COBOL – provides reference material for writing Open ServerConnect programs that call COBOL Gateway-Library functions. This guide contains reference pages for Gateway-Library routines and descriptions of the underlying concepts for COBOL programmers.
Mainframe Connect Client Option Programmer’s Reference for C – describes writing Open ClientConnect programs that call C Client-Library functions. This guide contains reference pages for Client-Library routines and descriptions of the underlying concepts for C programmers.
Mainframe Connect Server Option Programmer’s Reference for Remote Stored Procedures – provides information for anyone who designs, codes, and tests remote stored procedures (RSPs).
Mainframe Connect Client Option Programmer’s Reference for Client Services Applications – provides information for anyone who designs, codes, and tests client services applications (CSAs).
Mainframe Connect DirectConnect for z/OS Option User's Guide for Transaction Router Services – describes configuring, controlling, and monitoring DirectConnect Transaction Router Service Library, as well as setting up security.
Mainframe Connect DirectConnect for z/OS Option User's Guide for DB2 Access Services (for use with MainframeConnect for DB2 UDB) – describes configuring, controlling, and monitoring DirectConnect for OS/390 Access Service, as well as setting up security.
Mainframe Connect Client Option and Server Option Open ClientConnect and Open ServerConnect Messages and Codes – provides details on messages that mainframe access components return. This guide contains all messages returned by Open ServerConnect and Open ClientConnect. (You may not have all of these products at your site.).
Use the Sybase Getting Started CD, the SyBooks™ CD, and the Sybase Product Manuals Web site to learn more about your product:
The Getting Started CD contains release bulletins and installation guides in PDF format, and may also contain other documents or updated information not included on the SyBooks CD. It is included with your software. To read or print documents on the Getting Started CD, you need Adobe Acrobat Reader, which you can download at no charge from the Adobe Web site using a link provided on the CD.
The SyBooks CD contains product manuals and is included with your software. The Eclipse-based SyBooks browser allows you to access the manuals in an easy-to-use, HTML-based format.
Some documentation may be provided in PDF format, which you can access through the PDF directory on the SyBooks CD. To read or print the PDF files, you need Adobe Acrobat Reader.
Refer to the SyBooks Installation Guide on the Getting Started CD, or the README.txt file on the SyBooks CD for instructions on installing and starting SyBooks.
The Sybase Product Manuals Web site is an online version of the SyBooks CD that you can access using a standard Web browser. In addition to product manuals, you will find links to EBFs/Maintenance, Technical Documents, Case Management, Solved Cases, newsgroups, and the Sybase Developer Network.
To access the Sybase Product Manuals Web site, go to Product Manuals.
Technical documentation at the Sybase Web site is updated frequently.
Finding the latest information on product certifications
Point your Web browser to Technical Documents.
Click Certification Report.
In the Certification Report filter select a product, platform, and timeframe and then click Go.
Click a Certification Report title to display the report.
Finding the latest information on component certifications
Point your Web browser to Availability and Certification Reports.
Either select the product family and product under Search by Base Product; or select the platform and product under Search by Platform.
Select Search to display the availability and certification report for the selection.
Creating a personalized view of the Sybase Web
site (including support pages)
Set up a MySybase profile. MySybase is a free service that allows you to create a personalized view of Sybase Web pages.
Point your Web browser to Technical Documents.
Click MySybase and create a MySybase profile.
Finding the latest information on EBFs and software
maintenance
Point your Web browser to the Sybase Support Page.
Select EBFs/Maintenance. If prompted, enter your MySybase user name and password.
Select a product.
Specify a time frame and click Go. A list of EBF/Maintenance releases is displayed.
Padlock icons indicate that you do not have download authorization for certain EBF/Maintenance releases because you are not registered as a Technical Support Contact. If you have not registered, but have valid information provided by your Sybase representative or through your support contract, click Edit Roles to add the “Technical Support Contact” role to your MySybase profile.
Click the Info icon to display the EBF/Maintenance report, or click the product description to download the software.
This section describes the syntax and style conventions used in this book.
Throughout this book, all references to Adaptive Serve
Enterprise also apply to its predecessor, SQL Server. Also, Adaptive
Server Enterprise (ASE) and Adaptive Server (AS) are used interchangeably.
The Client Option uses eight-character function names, while other versions of Client-Library use longer names. This book uses the long version of Client-Library names with one exception: the eight-character version is used in syntax statements. For example, CTBCMDPROPS has eleven letters. In the syntax statement, it is written CTBCMDPR, using eight characters. You can use either version in your code.
Table 1 explains syntax conventions used in this book.
Symbol |
Explanation |
|---|---|
( ) |
Parentheses indicate that parentheses are included as part of the command. |
{ } |
Braces indicate that you must choose at least one of the enclosed options. Do not type the braces when you type the option. |
[ ] |
Brackets indicate that you can choose one or more of the enclosed options, or none. Do not type the brackets when you type the options. |
| |
The vertical bar indicates that you can select only one of the options shown. Do not type the bar in your command. |
, |
The comma indicates that you can choose one or more of the options shown. Separate each choice by using a comma as part of the command. |
Table 2 explains style conventions used in this book.
This type of information |
Looks like this |
|---|---|
Gateway-Library function names |
TDINIT, TDRESULT |
Client-Library function names |
CTBINIT, CTBRESULTS |
Other executables (DB-Library routines, SQL commands) in text |
the dbrpcparam routine, a select statement |
Directory names, path names, and file names |
/usr/bin directory, interfaces file |
Variables |
n bytes |
Adaptive Server datatypes |
datetime, float |
Sample code |
01 BUFFER PIC S9(9) COMP SYNC. 01 BUFFER PIC X(n). |
User input |
01 BUFFER PIC X(n) |
Client-Library and Gateway-Library function argument names |
BUFFER, RETCODE |
Client-Library function arguments that are input (I) or output (O) |
COMMAND – (I) RETCODE – (O) |
Names of objects stored on the mainframe |
SYCTSAA5 |
Symbolic values used with function arguments, properties, and structure fields |
CS-UNUSED, FMT-NAME, CS-SV-FATAL |
Client-Library property names |
CS-PASSWORD, CS-USERNAME |
Client-Library and Gateway-Library datatypes |
CS-CHAR, TDSCHAR |
All other names and terms appear in this typeface.
This document is available in an HTML version that is specialized for accessibility. You can navigate the HTML with an adaptive technology such as a screen reader, or view it with a screen enlarger.
The HTML documentation has been tested for compliance with U.S. government Section 508 Accessibility requirements. Documents that comply with Section 508 generally also meet non-U.S. accessibility guidelines, such as the World Wide Web Consortium (W3C) guidelines for Web sites.
You might need to configure your accessibility tool
for optimal use. Some screen readers pronounce text based on its
case; for example, they pronounce ALL UPPERCASE TEXT as initials,
and MixedCase Text as words. You might find it helpful to configure
your tool to announce syntax conventions. Consult the documentation
for your tool.
For information about how Sybase supports accessibility, see Sybase Accessibility. The Sybase Accessibility site includes links to information on Section 508 and W3C standards.
Each Sybase installation that has purchased a support contract has one or more designated people who are authorized to contact Sybase Technical Support. If you cannot resolve a problem using the manuals or online help, please have the designated person contact Sybase Technical Support or the Sybase subsidiary in your area
