Page History
9.219 TRANSFORM_LIST
| Note |
|---|
| Note: Built-In Function Rules Usage Rules Usage Options |
Transforms the current contents of one or more working lists into a disk file.
It is designed to facilitate the transfer of information between Visual LANSA applications and other products (e.g: spreadsheets).
See also
Arguments
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 |
IBM i.) C - Columnized File (Numeric Fields Have Leading Signs) with signs. D - Columnized File (Numeric Fields do NOT have Signs) without signs. 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'.
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 ',').
| 1 | 1 | ||||
7 | A | Opt | '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. |
Return Values
No | Type | Req/ Opt | Description | Min Len | Max Len | Min Dec | Max Dec |
|---|---|---|---|---|---|---|---|
1 | A | Req | Return Code. OK - File Created. | 2 | 2 |
Technical Notes - TRANSFORM_LIST
...
Data Target <- - - - - - - - - - - - Data Source - - - - - - - - - - - - - >
PC SQL Table | PC Disk File | IBM i File | |
PC SQL Table | N/A | Yes | Yes |
PC Disk File | Yes | N/A | Yes |
IBM i File | Yes | Yes | N/A |