Accessing SQL Defined Tables › Creating New SQL Tables

Creating New SQL Tables

Introduction

CA Culprit can create new CA IDMS/DB tables. The user simply codes familiar CA Culprit syntax, and SQL commands are generated automatically. Minimal training in Structured Query Language is needed for a CA Culprit programmer to begin creating new SQL tables.

Creating new SQL tables is a two step process: Create the table definition, and insert new data.

• During the Compile Phase of CA Culprit, information from the OUTPUT parameter and the EDIT parameters is gathered, and SQL Create Table syntax is generated. The syntax is then passed to the CA IDMS/DB database engine, and a new SQL table definition is created. A message appears on the Input Parameter Listing telling the user that the Create Table procedure is successful, and the data extraction phase begins.
• During the Output Phase the bulk insert technique is used to load data into the SQL table. CA Culprit automates this procedure completely.