The SQL Manager prepares, optionally stores, and executes SQL statements. The SQL Manager is integrated with the Multi-User Facility and is accessed by the CA Datacom/DB SQL Preprocessor and by other DATACOM products such as the CA Datacom Datadictionary and CA Dataquery. The following diagram approximates how the SQL Manager processes an application with embedded SQL statements.
Interactive SQL is supported by CA Dataquery, with capabilities to create and populate tables using standard SQL statements. See the CA Dataquery documentation for information on how this product uses SQL.
The CA Datacom Datadictionaryy supports the definition of tables and views using SQL statements, allowing you to take advantage of the standardization that SQL provides. You can also use the CA Datacom Datadictionary menu-driven method to define database structures, as an alternative to SQL, and update the SQL defined databases with additional information that is not currently available in SQL. In addition, the CA Datacom Datadictionary provides many capabilities not available through SQL. For example, text classifications allow you to store text about your SQL tables, views and columns in addition to that specified in the COMMENT ON statement. Certain attributes for SQL tables and columns can be modified directly through CA Datacom Datadictionary without limiting the ability to access these occurrences through SQL.
Note: For more information about these capabilities, see the CA Datacom Datadictionary Online Reference Guide.
|
Copyright © 2014 CA.
All rights reserved.
|
|