Progress
SQL-89
Guide and Reference


Data Definition Language

WithProgress, you can use SQL-89 data definition statements, the Progress Data Dictionary, or both to create SQL-89 tables and Progress schema.

You can use the SQL-89 Data Definition Language to create or modify a database. However, you must define a single table with a single mechanism.

Progress Software Corporation recommends that you use the Data Dictionary to define tables, even if you expect to use SQL-89 data manipulation statements against them. This establishes a consistent way to maintain the data for all the tables in your application. The only time you must use SQL-89 to define a table is to modify the privileges and change controls that SQL provides using the GRANT and REVOKE statements.

To access the data in a database, you can use SQL-89, Progress 4GL data manipulation statements, or both.

You must compile and run a Progress procedure containing SQL-89 data definition statements using the same user ID. This is checked at run time, and Progress returns an error message if different user IDs attempt to compile and run the procedure. You cannot compile or run data definition statements when the user ID is blank.

This chapter describes:


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095