AIX | HP-UX | Linux | OS/2 | OS/390 | OS/400 | PTX | SUN | Win NT |
X | X |
| X | X | X | X | X | X |
Purpose
Deletes one or more rows from a Net.Data table.
Format
@DTW_TB_DELETEROW(table, start_row, rows)
Parameters
Table 126. DTW_TB_DELETEROW Parameters
Data Type | Parameter | Use | Description |
---|---|---|---|
table | table | INOUT | The macro table variable from which rows are to be deleted. |
integer | start_row | IN | The row number of the first row in table to delete. |
integer | rows | IN | The number of rows to delete from table. |
Return Codes
Table 127. DTW_TB_DELETEROW 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. |
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. |
1007 | A parameter contains a value which is not valid. |
1008 | A parameter is outside of table bounds. |
Usage Notes
The number of columns in the table must be set before calling DTW_TB_DELETEROW(). You can set the number of columns with the DTW_TB_SETCOLS() or DTW_TB_INSERTCOL() functions, or by passing the table to a language environment to be set.
Examples
Example 1: Deletes five rows starting at row 10 of a table
%DEFINE myTable = %TABLE @DTW_TB_DELETEROW(myTable, "10", "5")
Example 2: Deletes all of the rows of a table
%DEFINE myTable = %TABLE @DTW_TB_DELETEROW(myTable, "1", @DTW_TB_rROWS(myTable))