Upgrading from Earlier Releases › Upgrading from CA Plex r5.5 › Java Functions Upgrade Requirements › Java and C# Exec SQL Action Diagram Source Code

Java and C# Exec SQL Action Diagram Source Code

In CA Plex r7.1, r7.0, r6.1, and r6.0, the Java and C# generators generate all Exec SQL statements as prepared statements by default. The SRC SQL statement type SYS triple can be used to indicate source code objects that must not be generated with prepared statements.

Generating prepared statements may improve performance and scalability in cases where the same SQL statement is executed repeatedly. However, the results may also depend on application and DBMS-specific factors. CA recommends benchmarking with different values for SRC SQL statement type SYS for determining the optimum setting in each case.

Also, generating prepared statements assumes that all parameters to the Exec SQL statement correspond to columns in a table. This assumption is not always true because the Exec SQL statement can be used to implement a wide variety of SQL code. The SRC SQL statement type SYS triple can be used to indicate source code objects that should not be generated with prepared statements. When upgrading Java applications from r5.5 or earlier, it may be necessary to add such triples to some source code objects to avoid errors.

This change does not affect Exec SQL usage with C++.