Defining table/column relations on existing tables.

[fmp]

Open Unix 8, Progress 9.1D, NT4

Accessing an existing Progress DB via "Merant 3.60 Progress SQL92" ODBC.

Table relationships are not defined, software access controlled relationships.

In building 'joined' SQL views we require table relationships to be defined.

Using SQL create table with column contraints we can define references.

Since tables already exist, however, and are filled with data I don't want to 'drop table' and 'create table'. Especially since I don't want to use SQL to manimulate tables only to select for reporting.

Does anyone know of any tools/commands with SQL92/Progress/Other for filling the constraints references after tables are already defined and filled.
Or other tools for manimulating the SQL92 sceama after data is already in the DB.

Thanks. fmp.

 

[fmp]

Progress Support answered my question...

Use this as an example and refer to the SQL92 Guide and Reference for valid SQL statements that you are allowed to use.

CREATE VIEW custOrd AS
SELECT cust.custnum,ord.ordernum
FROM pub.cust, pub.ord where cust.custnum = ord.ordernum;