Import IXF File Type Modifiers -- Fields and controls

" " Accept code page mismatches and suppress translation (FORCEIN)
" " Drop existing indexes and create new ones (INDEXIXF)
" " Load each row without checking target length (NOCHECKLENGTHS)
" " Index schema
" " OK
" " Cancel



" " Accept code page mismatches and suppress translation (FORCEIN)

Select this check box to accept data from the input file even if code page mismatches occur and to suppress translation between code pages.

" " Drop existing indexes and create new ones (INDEXIXF)

Select this check box to drop all indexes defined in the table that you selected and create new ones from the index definitions in the input file. This option can be used only when the contents of a table are being replaced. It cannot be used with a view or when columns are inserted.

" " Load each row without checking target length (NOCHECKLENGTHS)

By default, target fields for fixed-length fields in IXF files are checked to verify that they are large enough for the data. Select this check box to specify that target fields are not to be checked and that an attempt be made to load each row.

" " Index schema

Use this box to specify the schema of the table that you're creating. The initial value in this box is the user ID under which you connected to the database. To specify a schema with a name that's different than this ID, use one of these methods: