Previous Topic: Supported FeaturesNext Topic: ASP.NET Web Client Generation


Multiple Database Support

CA Gen-generated C applications can access only one database for a given procedure step. This is due to the use of the default database handle for all embedded SQL statements.

CA Gen-generated C# applications use ADO.NET and have been designed to allow access to one or more databases within a given procedure step. Customers wishing to use this feature must create a data source for each database to be accessed by the procedure step.

Note: The commits and rollbacks of the multiple database connections may or may not be performed using a 2-phased commit facility. In the ASP.NET Web Client environment, 2-phased commit is not supported by ASP.NET or IIS. Therefore, be aware that there is a small risk of data integrity problems should an error be encountered. For the generated .NET Server environment, 2-phased commit is supported when utilizing properly configured data sources.