Use the following settings for ECDA:
Transaction Mode = long allocate = connect
SQL transformation = Sybase
If you are using a Mainframe Connect DirectConnect for z/OS Option database gateway for replication to a DB2 UDB for z/OS replicate database, set the following properties in the DirectConnect db2.cfg access service configuration file:
SQLTransformation=passthrough TransactionMode=long