Customers frequently use CSAs to transfer data between databases, such as DB2 and Adaptive Server Enterprise. For example, you can write a CSA to execute a nightly transfer operation or to periodically poll Adaptive Server Enterprises for changes that were made to the database tables during the day or week.
You can write a CSA to run:
A SELECT statement against Adaptive Server Enterprise and place the results in DB2, a VSAM dataset, or a temporary storage queue
A SELECT statement and perform application processing on the result rows
An UPDATE, INSERT, or other non-SELECT statement against the remote database
A TRANSFER statement to move data between any two databases. See “Transferring data: about the CSAINDX sample code” for more information.
You can also use a CSA to initiate a transfer of data between two platforms, neither of which is the platform on which the CSA is running. For example, a CSA running under MVS-CICS could transfer data between Adaptive Server Enterprise and DB2 in another MVS region. Transfers require DirectConnect to be running.