Client Services Applications (CSAs) are customer-written, CICS or batch programs, that can access LAN-based DBMS systems using SQL. CSAs are initiated from the mainframe, and allow mainframe applications to both retrieve result sets, and to update data on the LAN.
The Java CSA Server runs on any Java-enabled platform, and provides the connectivity between the CSAs on the mainframe, and the LAN-based DBMS systems.
When the CSA Server receives an SQL request from the mainframe application, EBCDIC to ASCII conversion is perfomed, and the request is passed to the target database for execution. The request is processed using the standard JDBC interface provided by the database vendor.
As data is returned to the CSA Server, ASCII to EBCDIC conversion is performed, and the LAN datatypes are converted into their equivalent S/390 datatypes. The data, along with any SQL codes and messages are transmitted to the requesting mainframe application.