DEL Options

Use the DEL Options window to specify options for loading data from delimited ASCII (DEL) files.

Fields and controls

• Retrieve large objects (LOBs) from the specified paths (LOBSINFILE)
• LOB paths
• Add
• Change
• Remove
• Move Up
• Move Down
• Do not recognize character x'1A' as the end-of-file character (NOEOFCHAR)
• Suppress warnings about rejected rows (NOROWWARNINGS)
• Insert an implied decimal point on decimal data (IMPLIEDDECIMAL)
• Perform reduced sanity checking on user supplied column values (FASTPARSE)
• Use default values on defaultable columns when missing input data (USEDEFAULTS)
• Use ISO date format (DATESISO)
• Prefix positive decimal values with a blank (DECPLUSBLANK)
• Preserve leading and trailing blanks in each field (KEEPBLANKS)
• Suppress recognition of double character delimiters (NODOUBLEDEL)
• Prioritize character string delimiter over record delimiter (DELPRIORITYCHAR)
• Column delimiter
• Character string delimiter
• Decimal point character
• Percentage of free space in each data page (PAGEFREESPACE)
• Percentage of total free space reserved in the table (TOTALFREESPACE)
• Code page of data in input data set (CODEPAGE)
• Exception file to which rejected rows are written (DUMPFILE)
• Custom date format
• Custom time format
• Custom timestamp format
• OK
• Cancel