Forms-Based Application Development Tools User Guide > Part 5: 4GL > 4GL Statement Glossary > Using SQL with 4GL
Was this helpful?
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.
Last modified date: 01/30/2023