Previous Topic: Upload a Table Procedure to CA IDMSNext Topic: Table Procedure Examples, Design, and Use


Upload CREATE TABLE Syntax to Ingres II

After you generate a table procedure specification, you can upload the SQL CREATE TABLE syntax to an Ingres II database.

To upload CREATE TABLE syntax to an Ingres II database

  1. If a table procedure specification is open, select File Close to close it.
  2. If necessary, select File Connect to Database to connect to the data source that defines the Ingres II database.
  3. Select Upload SQL from the File menu to upload the CREATE TABLE syntax. Select a file with type "Ingres 1.x table SQL", extension .SQ2 or a file with type "Ingres 2.x table SQL", extension .SQ3.