Communication flow  At the server

Chapter 1: Understanding the Client Option

At the mainframe

A Client Option application calls a pre-written procedure, such as a stored procedure or an Open Server application. All calls from the Client Option to remote nodes are processed using TCP/IP. For requests to an Open Server, the client can access any data available to the Open Server application.

The called procedure or transaction executes and returns results to the calling Client Option application, which can use the results for local processing. If the client has permission, the client transaction can update data at remote sites by inserting, modifying, and deleting entries in database tables or other data storage systems.

isql utility

The Client Option includes isql, a utility that allows users to send SQL language commands using TSO. Users specify the server, user ID, password and the input file containing the SQL statements. For more information about using isql with the Client Option, see Chapter 4, “Using isql.”

Server-Host Mapping Table

For TCP/IP, the Client Option includes a Server-Host Mapping Table that allows you to define servers for two-tier environments. For more information, see Appendix A, “Customization Options.”





Copyright © 2005. Sybase Inc. All rights reserved. At the server

View this book as PDF