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