Salesforce

SQL Where Clause (Magic xpa 2.x)

« Go Back

Information

 
Created ByKnowledge Migration User
Approval Process StatusPublished
Objective
Description

SQL Where Clause (Magic xpa 2.x)

The SQL Where Clause allows you to use the SQL-specific Where clauses in addition to the Where clauses generated automatically by Magic xpa, without the need to use Direct SQL tasks.

This is an interface for writing Ranges based on SQL syntax using Magic xpa variables. This range will be concatenated to the Magic xpa Where clause defined in the Range dialog box.

An SQL Where form will enable the programmer to specify a range, and to view the full Where clause that will be generated by Magic xpa.

Database specific

For IBM i databases, the Open Query File tab is seen instead of the SQL Where tab.

The SQL Range is not supported for local data sources.

Related Topics

Reference
Attachment 
Attachment