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.
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.