Restriction: This topic applies only when the AppMaster Builder AddPack has been installed, and applies only to Windows platforms.
- Database Type
- This output-only field reflects your database type.
- Program Function
- Select database action/control action associations for the call. from one of the following:
- Paragraph Name
- Shows the default name of the user database call paragraph if you set the Program Function to
*User. Type a new name if you want to override the default name. If you override the default paragraph name, you must write a paragraph
of that name to replace the default paragraph.
- Nesting Level
- Specify the nesting level of a loop call.
- Scrollable Rec
- placeLoop calls only. Check this if you plan to map the records of the outermost loop–a level 0 loop–to a repeated record
block. The default is the first loop. Override to specify any loop.
- Details On
- Click this to see additional attributes.
- Query Type
- Specify whether the call is a:
- Query
- Default for all targets. For
SQL, select
Query to define a call that consists of one Select clause. To define an SQL Join call, select
Query and define multiple query calls.
- Subselect
- For
SQL only. Select this to define a Subselect clause. You define a Subselect separately from a Query, placeUnion, or Join call,
and then include the Subselect in your call when you qualify it.
- placeUnion
- For
SQL only. Select to define a Union call.
- Union All
- Check this to include duplicate records in an SQL Union result.
- Literal
- Type a prefix to identify SQL Union statements.