User guide

NonStop dba/m Database Manager for NonStop SQL/MP User’s Guide 522632-004 8-13
4. In the Replace spaces pane, specify whether spaces should be replaced
with zeroes or with defaults by clicking either on With Zeroes or on
With Defaults.
5. Turn the unstructured-disk-file option on or off by clicking on
Unstructured.
6. Turn the up shift option on or off by clicking on Upshift.
7. To copy null values from Enscribe files to null values in an SQL table,
click on Use SQL Nulls.
8. In the First pane, click on one of the following:
• OrdinalRecNum. Then enter the number of records to be skipped in
the OrdinalRecNum field.
• RecordSpec. Then enter the primary-key value for the starting
record of an unstructured, relative or entry-sequenced file in the
RecordSpec field.
• KeyValue. Then enter the approximate position of the starting
record for key-sequenced files in the KeyValue field.
• KeySpecifier. Then enter the positions of the record with the
specified alternate key value in the KeyValue field.
Define Input-File Options
Set input-file options using the In Option pane, as shown in Figure 8-16.
Not all options are applicable to all object types.
Figure 8-16. In Option Pane.
To define input-file options
1. Enter the input block length in the Blockin field.