16 1 2 Other Files

16.1.2 Other Files

Load Other Files automatically creates new field definitions as required. If the underlying database column is stored in the database as Unicode, LANSA will automatically create or reuse an appropriate field along the following guidelines:

• If the file definition already exists, and it contains any Char or String fields with the SUNI attribute, any new fields created for Unicode database columns will be created as Char, String, or CLOB fields with the SUNI attribute.

• The only exception to this rule is the IBM i native type Alpha with CCSID 1208 (UTF-8), which is always loaded as Nchar or Nvarchar.

• If it is a new file, or there are no Char or String fields with the SUNI attribute on the file, Load Other File will create Unicode fields as Nchar or Nvarchar.

Refer to 16.3.4 Other Files with SUNI Fields.

for details on how you might change existing Other Files from using SUNI fields to 16.1.1 Unicode Field Types.

Also See

16.2 Developing New Applications with Unicode

16.3 Modifying Existing Applications to use Unicode

Load Other File in the Visual LANSA Developer's Guide or Load Other File in the Technical Reference Guide.

Ý 16.1 Unicode Support in LANSA