Programming IDMS SQL

The topics in this section are for CA IDMS users responsible for designing and developing application programs using embedded SQL.
idms
The topics in this section are for CA IDMS users responsible for designing and developing application programs using embedded SQL. It documents aspects of CA IDMS that are specific to application programming with SQL, including pre-compiler options and data type conversions between the database and the program language. These topics are for a user with application programming experience and a working knowledge of SQL. Users should also be familiar with concepts of CA IDMS.
How Examples are Presented
All program examples are in COBOL, unless otherwise indicated.
Most examples of access to an SQL-defined database refer to a test database of employee information that is supplied as part of CA IDMS installation. The term CA IDMS refers to any one of the following components:
  • CA IDMS/DB—The database management system
  • CA IDMS/DC—The data communications system and proprietary teleprocessing monitor
  • CA IDMS UCF—The universal communications facility for accessing CA IDMS database and data communications services through another teleprocessing monitor, such as CICS
  • CA IDMS DDS—The distributed database system
The actual product names are used for CA IDMS/DB, CA IDMS/DC, CA IDMS UCF, DC/UCF, and CA IDMS DDS to identify the specific CA IDMS component only when it is important to your understanding of the product.