IBM Books

Reference

DTW_TB_DELETEROW


AIX HP-UX Linux OS/2 OS/390 OS/400 SCO SUN Win NT
X 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 124. 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 125. 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 The number of parameters passed on a function call either exceeded the maximum number allowed, or was less than the minimum number required by the function.
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))


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]