Using SQL with 4GL

21. 4GL Statement Glossary : Using SQL with 4GL

Share this page

Using SQL with 4GL

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:

• create procedure

• create schema

• drop procedure

• drop schema

• get data

• put data

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:

• connect

• delete

• disconnect

• execute immediate

• execute procedure

• insert

• select

• update

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.