TEXTLINE Input Format Parameters

The TEXTLINE input format supports the following parameters:

iCodepage
  Values: codepage ID (number)
  Default: 0
  Description: Codepage of the text file.
  Details: 0 is the system codepage, -1 is UNICODE.
  Example: -iCodepage:1245
 
recurse
  Values: recursion level (number)
  Default: 0
  Description: Max subdirectory recursion level.
  Details: 0 disables subdirectory recursion; -1 enables unlimited recursion.
  Example: -recurse:-1
 
splitLongLines
  Values: ON | OFF
  Default: OFF
  Description: Split lines when longer than maximum allowed.
  Details: When a text line is longer than 128K characters, the TEXTLINE input format truncates the line and either discards the remaining of the line (when this parameter is set to "OFF"), or processes the remainder of the line as a new line (when this parameter is set to "ON").
  Example: -dQuotes:ON
 
iCheckpoint
  Values: checkpoint filename
  Default: not specified
  Description: Load and save checkpoint information to this file.
  Details: This parameter enables the "Incremental Parsing" feature that allows sequential executions of the same query to only process new log entries that have been logged since the last execution. For more information, see Parsing Input Incrementally.
  Example: -iCheckpoint:C:\Temp\myCheckpoint.lpc
 

© 2004 Microsoft Corporation. All rights reserved.