IBM Books

Reference

DTW_TB_DELETECOL


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 columns from a Net.data table.

Format

@DTW_TB_DELETECOL(table, after_col, cols)

Parameters

Table 122. DTW_TB_DELETECOL Parameters

Data Type Parameter Use Description
table table INOUT The macro table variable from which columns are to be deleted.
integer after_col IN The number of the column after which subsequent columns are to be delted. To delete the first column, specify 0.
integer cols IN The number of columns to delete from table.

Return Codes

Table 123. DTW_TB_DELETECOL 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.

Examples

Example 1: Deletes the third and fourth columns from the table

%DEFINE myTable = %TABLE
 
@DTW_TB_DELETECOL(myTable, "3", "2")

Example 2: Deletes the first column from the table

%DEFINE myTable = %TABLE
 
@DTW_TB_DELETECOL(myTable, "0", "1")


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