Using the SQLQuery action with bidirectional languages

For bidirectional languages (Arabic and Hebrew), some specific properties must be set for SQLQuery to work correctly. An Advanced button appears in the AME to access the options. The Advanced button is visible only if your workstation is configured for a bidirectional language.

The additional properties are:

Host-File Type: Specifies whether the host file should be saved in logical or visual format. The default is Visual.
Local-File Type: Specifies whether local files are in logical or visual format. The default is Logical.
Host-File Orientation: Specifies whether the host file should be saved in left-to-right or right-to-left format. The default is Left-to-Right.
Lam-Alef Expansion: Specifies the behavior of the Lam-Alef characters. When receiving Arabic data from the host through the SQL wizard statement, the character Lam-Alef is expanded into two characters, if there is space after the Lam-Alef character: Lam followed by Alef.
Lam-Alef Compression: Specifies the behavior of the Lam-Alef characters. When sending Arabic data to the host through the SQL wizard statement, the characters Lam followed by Alef are compressed into one character and space is added after the Lam-Alef character. This option is enabled for Arabic systems only. The default is on.
Numerals Shape: Specifies the shape of the numeral on the host file at the SQL wizard statement; the numeral shape could be NOMINAL, NATIONAL or CONTEXTUAL. This option is enabled for Arabic systems only. The default is NOMINAL.
Round Trip: Specifies the behavior of numerals, disabling the reversal of the numerals if preceded by Arabic/Hebrew characters. The default is on.
Symmetric Swapping: Specifies the behavior of the symmetric characters, such as brackets; the inversion of the screen causes directional characters to be replaced by their counterparts. The default is on.

For more information, see SQLQuery action (<sqlquery> element).