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.