Salesforce

SQL Where Clause (Magic xpa 4.x)

« Go Back

Information

 
Created BySalesforce Service User
Approval Process StatusPublished
Objective
Description

SQL Where Clause (Magic xpa 4.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.

For Space databases, when using a constant value in the SQL Where clause, it will be trimmed according to the SQL type. If no SQL type is defined, the value will be trimmed for Unicode columns and will not be trimmed for Alpha columns.

The SQL Range is not supported for local data sources.

Related Topics

Reference
Attachment 
Attachment