Macro SQL query bidirectional options
In the SQL wizard for bidirectional languages (Arabic and Hebrew),
specific bidirectional properties need to be set. You can access these
settings by clicking the Advanced button
in the Advanced Macro editor panel.
This panel is visible only if your workstation is configured for a
bidirectional language. The following settings are available:
- Host-File Type
- This option specifies whether the Host file should be saved in logical or visual format. The default is Visual. (This option is not enabled for the JDBC driver from the AS/400® Toolbox for Java™).
- Local-File Type
- This option 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. (This option is not enabled for the JDBC driver from the AS/400® Toolbox for Java™.)
- Local-File Orientation
- Specifies whether local files are 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, Lam followed by Alef if there is space after Lam-Alef character.
- 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 Lam-Alef character. This option is enabled for Arabic systems only. The default is on. (This option is not enabled for the JDBC driver from the AS/400® Toolbox for Java™.).
- 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. (This option is not enabled for the JDBC driver from the AS/400® Toolbox for Java™).
- Round Trip
- Controls how bidirectional text mixed with numerals is processed.
- Numerals Shape
- Specifies the shape of the numeral on Host file at SQL wizard statement; the numeral shape can be (NOMINAL, NATIONAL and CONTEXTUAL). This option is enabled for Arabic systems only. The default is NOMINAL. (This option is not enabled for the JDBC driver from the AS/400® Toolbox for Java™).