Versions Compared

Old Version 3

changes.mady.by.user Fabiola Arias Navia

Saved on

compared with

New Version Current

changes.mady.by.user Fabiola Arias Navia

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

No

Type

Req/ Opt

Description

Min Len

Max Len

Min Dec

Max Dec

1

L

Req

Name of the primary working list that is to be transformed into a disk file.

Note: If this list contains fields of type Binary or VarBinary, the Built-In Function will end in error.





2

A

Req

Name of file to be replaced or created by this Built-In Function.

1

256



3

A

Opt

Output File Format.

A - Normal Delimited File.

B - DBF File. (Not available on IBM i.)

C - Columnized File (Numeric Fields Have Leading Signs) with signs.

D - Columnized File (Numeric Fields do NOT have Signs) without signs.

O - Comma Delimited File.

S – Comma Delimited File: The same format as type O files except that there are no blanks for invalid characters if the Method of handling invalid characters is R.

T - Horizontal Tab Delimited Files.

Output File Formats A, C, D, O, S and T support UTF-8 format. This is indicated by appending a 'U' to this argument (i.e. Format). For example, UTF-8 output for format O would have an Output File Format of 'OU'.

Note
Note: CU and DU column widths are double the field width in order to accommodate the extra bytes that UTF-8 may require.

The default value is 'A'.

1

3



4

A

Opt

Method of handling invalid characters encountered within alphanumeric fields.

'B' - Replace by blank character.

'I' - Ignore. Include character.

'R' - Remove from output.

The default value is 'B'.

1

1



5

A

Opt

Include Carriage Return at the end of each record.

'N'- Do not include carriage  return.

'T' - Include carriage return and also truncate all blank data from the end of the record.

'Y'- Include carriage return.

The default is 'Y'.

1

1



6

A

Opt

Decimal Point to be used . The allowable values are:

'R'- Remove the decimal point from all numeric representations. This will shorten the length of numeric fields that have decimal positions by 1 character. Only valid with file formats C and D.

other - The value to be used as a decimal point character.

The default is the currently defined system decimal point (i.e. '.' or ',').

Note
Note: The use of European style ',' decimal points may create problems in files formats that also use commas to delimit fields.

1

1



7

A

Opt

Close Output File Option.

'Y'- Close the file at completion.

'N'- Do not close the file at  completion.

The default is 'Y'.

1

1



8 - 17

L

Opt

Allows up to 10 Appendage Working Lists to be specified. Refer to the following notes for more details.

Valid only if the primary working list is an RDML list.





...