Before you write a CSA, you have several decisions to make and environmental issues to consider:
What functions will the CSA perform?
Will the CSA access Adaptive Server Enterprise, remote databases, or both?
What kind of SQL transformation and datatype conversions will be applied?
Will the CSA access temporary storage or transient data queues?
Will the CSA link to other programs or functions?
What kind of error handling will the CSA require?