Previous Topic Next topic Print topic


Attributes

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.
Previous Topic Next topic Print topic