9. Using 3GL in Your Application : How You Can Use Exec 4GL Statements in 3GL Procedures
 
Share this page                  
How You Can Use Exec 4GL Statements in 3GL Procedures
A limited number of scalar data items can be passed easily between 4GL and 3GL procedures. However, if the amount of scalar data to be passed exceeds the number of parameters allowed on your system, or if you want to pass structured data such as an array or an OpenROAD object, use the C language to pass the data to an embedded SQL procedure.
To access OpenROAD structured data from 3GL, you use a set of embedded statements that have the following syntax:
exec 4gl 4gl_statement [terminator]
Note:  This syntax is similar to that used for embedded SQL statements. All 3GL routines using these exec 4gl statements can be used only in OpenROAD applications.
For more information about using exec 4gl statements (see Summary of Exec 4GL Statements), see the Language Reference Guide.
You can use an embedded procedure with OpenROAD to perform the following functions:
Getting and setting object and array attributes
Dynamically accessing object and array attributes by a describe operation using the SQLDA
Indexing into arrays to get or set objects
Inserting rows into, deleting rows from, and removing rows from arrays
Clearing arrays
Accessing global variables and constants
Sending user events to 4GL