Output Fixed (Deprecated) - Data360_Analyze - Latest

Properties

File

Click the folder icon and browse to the file to which you want to output the data, then click Choose.

To create a new file, click the folder icon and navigate to the folder where you want to output the file, then enter a name for the file in the Filename field and click Choose.

A value is required for this property.

FieldPositions

Specify a colon-separated field specification. Each entry is of the form: name,start position,size.

For example: FirstName,0,10:LastName,10,20:Salary,30,10.

A value is required for this property.

RecordDelimiter

Optionally specify a string or character that will separate consecutive rows or records in the output file.

Use \n for newline (Unix style), \r\n for carriage return newline (Windows style).

The default value is blank, in which case there will be no delimiter used, only the record width.

WriteHeader

Optionally specify whether to write a single record header row of the field names (truncated to field width if necessary).

The default value is False.

RecordWidth

Optionally specify the size of each record in bytes.

If unspecified, the record will be as long as the largest (start+size) specification in the FieldPositions.

Padding

Optionally specify a byte value used to pad data in fields that are not long enough for their specification. Use \<octal> notation to specify non-printable characters, for example, \0 is NUL, \40 is space.

The default value is \0.

NullValue

Optionally specify what to output when the value of a field is NULL.

The default value is blank.

LongField

Optionally specify the behavior if the data in a field is longer than the field specification. Choose from:

• Truncate - Truncates the field.
• Truncate and Log - Truncates the field and records this action in the log file.
• Error - An error is generated.

The default value is Truncate.

Inputs and outputs

Inputs: in1.

Outputs: None.