In a 4GL program, you can use interactive SQL statements as well as those that can be used with a distributed database. All statements have the same syntax as the corresponding interactive SQL statement, with the exceptions noted below. You can use 4GL names to specify many components in SQL statements. For rules on using 4GL names, see 4GL Names.

The following statements are not supported in 4GL:

The following statements have syntax or usage in 4GL that is different from interactive SQL. See the statement descriptions in this chapter for detailed information:

4GL supports Ingres SQL data types, with a few exceptions. For more information about 4GL data types, see the section, Data Types for Simple Local Variables and Hidden Columns.