Search results

  1. F

    Defining table/column relations on existing tables.

    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;
  2. F

    Defining table/column relations on existing tables.

    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...
    • fmp
    • Thread
    • Replies: 1
    • Forum: SQL-92
  3. F

    JDBC connection to Progress database

    Try adding <owner>. to your table_name. ie... select * from pub.table_name fmp
Top