AIX | HP-UX | Linux | OS/2 | OS/390 | OS/400 | PTX | SUN | Win NT |
X | X | X | X | X | X | X | X | X |
Purpose
Writes the contents of a Net.Data table to the end of a text file.
Format
@DTWF_APPEND(filename, transform, delimiter, table, retry, rows)
@DTWF_APPEND(filename, transform, delimiter, table, retry)
@DTWF_APPEND(filename, transform, delimiter, table)
Parameters
Table 168. DTWF_APPEND Parameters
Data Type | Parameter | Use | Description |
---|---|---|---|
string | filename | INOUT | The name of the file to which the variable's contents are being added. On successful completion of the call, this parameter returns the fully qualified file name. |
string | transform | IN | The format of the file:
|
string | delimiter | IN | A character string to indicate the ends of values. This parameter is case sensitive. Ignored if transform is ASCIITEXT. |
table | table | IN | The table variable from which the records are read.
For non-OS/400 users: The maximum length of a row in an FFI table is 16383 characters. This limit includes a null character for each column in the Net.Data macro table. |
integer | retry | IN | The number of times to retry if the file cannot be appended to immediately. The default is not to retry. |
integer | rows | IN | The maximum number of rows from table to append. The default is to append all the rows. Specifying 0 appends all rows. |
Return Codes
Table 169. DTWF_APPEND Return Codes
Return Code | Explanation |
---|---|
-1001 | The server could not process a Net.Data request to allocate memory. |
1001 | An input parameter contained a NULL value. |
1002 | An input parameter contained a string value which consisted of the null-terminating character. |
1003 | An incorrect number of parameters were passed on a function call. |
1004 | A parameter passed on a function call, required to be a Net.Data macro table variable, was of a different variable type. |
1005 | A parameter passed on a function call, required to be a string variable, was of a different variable type. |
1006 | A literal string was passed on a function call for a parameter which was required to be an output parameter. |
1007 | A parameter contains a value which is not valid. |
2000 | A flat file interface built-in function could not find the specified file. |
2003 | A flat file interface built-in function could not read a row of data into a table variable because the number of bytes in the row exceeded the maximum supported number of bytes. |
2004 | A flat file interface built-in function was attempting to find a file, but encountered a path in the FFI_PATH configuration file variable that was longer than the maximum supported number of bytes, which is 4095. |
2005 | A call to a system function failed. |
2006 | A flat file interface built-in function could not access the specified file because it was in use by this or another process and could not be shared in the specified mode. |
Usage Notes
The current contents of a file affect the results of using DTWF_APPEND, especially the contents of the last column of the last row. If a new-line character follows the last column value of the last row of the file, appended data is placed in a new row. Otherwise, appended data becomes part of the last row of the file. If the file to be appended does not exist, a file is created.
Examples
Example 1:
%DEFINE { myFile = "c:/private/myfile" myTable = %TABLE %} @DTWF_APPEND(myFile, "DELIMITED", " ;", myTable)
Example 2:
%DEFINE { myFile = "c:/private/myfile" myTable = %TABLE %} @DTWF_APPEND(myFile, "ASCIITEXT", " ;", myTable)
Example 3:
%DEFINE { myFile = "c:/private/myfile" myTable = %TABLE %} @DTWF_APPEND(myFile, "ASCIITEXT", " ;", myTable, "0", "10")