Progress
SQL-89
Guide and Reference
Progress 4GL Extensions to Progress/SQL
Progress/SQL supports the following Progress 4GL language elements:
- The Progress format phrases FORMAT, LABEL, and COLUMN-LABEL in the Progress/SQL CREATE TABLE, ALTER TABLE, and SELECT statements. These phrases control the display format and labels for data displayed on the screen or in printed reports.
- The frame phrase (WITH) in Progress/SQL queries. This phrase determines frame attributes.
- The Progress DATE and LOGICAL data types.
- Progress procedure variables and field values (retrieved by previous queries) in Progress/SQL statements.
- Subscripts for access to existing array fields created with Progress. (You cannot create array fields with Progress/SQL.)
- The BEGINS operator in a WHERE clause.
- The plus sign (+) for character string concatenation.
- Identifiers greater than 18 characters; Progress/SQL supports identifiers of up to 32 characters.
- Enhancements to the CONNECT statements to support DataServers.
- The record locking descriptions (FOR READ ONLY and FOR UPDATE) on the DECLARE CURSOR statement.
- Several DDL statements: ALTER TABLE, CREATE INDEX, DROP INDEX, DROP TABLE, and DROP VIEW.
NOTE
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |