CA Gen 8.5 Changes Until the Release of CA Gen Interim Enhancement 1 › Access to Product Documentation

Access to Product Documentation

The CA Gen guides are now available through electronic downloads from http://ca.com/support and on wiki - https://wiki.ca.com/display/GEN85/CA+Gen+Home.

BLOBs

With CA Gen Release 8.5, the second phase of BLOB support provides the ability to store BLOBs in a database, fetch BLOBs from a database, and to include BLOBs in views so that they can be passed around in the generated application (including external action blocks). This functionality does not include presenting or collecting BLOB data at the user interface, the file system interface, or any other system interface.

Because most of the CA Gen target databases support the BLOB data type, you can now leverage that support within your applications.

Some points to consider when using BLOBs in CA Gen Release 8.5 include:

• One or more BLOB attributes can be included in views that are defined as IMPORT, EXPORT, ENTITY ACTION, or LOCAL.
• The BLOB attributes are always variable length.
• The BLOB attributes are specified as optional or mandatory the same way as other attribute types.
• The BLOB views are passed to and from procedure steps and action blocks (including external action blocks).
• Operations on BLOBs in the action diagrams are limited to setting their value to NULL or to the value of another BLOB and comparing them to NULL.
• BLOBs are supported on the following technologies:
  • Windows / C / Oracle, DB2, SQL Server (ODBC)
  • UNIX, LINUX / C / Oracle, DB2
  • CLR / C# / ADO.NET - Oracle, DB2, SQL Server
  • JVM / JAVA / JDBC - Oracle, DB2, SQL Server
• BLOB attribute views can be used in all SQL statements (CREATE, READ, UPDATE, DELETE) and in non-SQL statements (SET, USE…) that operate on entity views.

Notes:

• BLOB attribute views are not placed on a screen or a window/dialog.
• BLOB attribute views are not used as identifiers nor they be used as classifying attributes in a partitioning.
• Non-BLOB attribute views cannot be set to BLOB attribute view values and BLOB attribute views cannot be set to non-BLOB attribute view values.