Since MS-Access "Text" data types can have a maximum length of 255 characters, Memo types must be used for fields whose expected data will exceed 255 characters. By default, Scriptoria assigns DB2 "CLOB" types, however long characters objects are high-overhead types. With DB2 VARCHAR types can be assigned lengths of up to 32K. When the maximum length of Memo fields is relatively small (less than 1K or 2K), using VARCHAR types can be used instead of long character types to improve the efficiency of the DB2 data model.
The following form is displayed after clicking the Memo Assignments button from the Assign DB2 Data Types form.
Table Name: Access table.
Memo Field: Name of the Memo field.
Maximum Data Length: The largest length of data stored in the Memo field.
Change to VARCHAR: Check this box to assign a varchar/nvarchar type to the associated MS-SQL column.
VARCHAR Length: The length to be assigned to the VARCHAR column.
This button is not shown on the form above. The Get Memo Fields caption is replaced by the Assign Types caption and the list of Access fields like the one shown above is displayed after the Memo analysis is performed.
Press this button to assign the selected fields with their corresponding DB2 VARCHAR type and lengths.