Resolving common coding problems

CSAs use only DB2 input pipes. A CSA cannot use output pipes. You must use INSERT and UPDATE commands to send data to the LAN server.

When you batch SQL commands to Adaptive Server Enterprise, you can scroll through messages with the GETMSG command. However, if Adaptive Server Enterprise does a ROLLBACK, the GETMSG command results in only one message.