DTW_TB_SETN

AIX HP-UX Linux OS/2 OS/390 OS/400 PTX SUN Win NT
X X
X X X
X X

Purpose

Assigns a name to a column heading in a Net.Data.

Format

@DTW_TB_SETN(table, name, col)

Parameters

Table 160. DTW_TB_SETN Parameters
Data Type Parameter Use Description
table table INOUT The macro table variable in which a column name will be set.
string name IN A character string that is assigned to the column heading of the column specified in col.
integer col IN The column number of the column whose heading is being set.

Return Codes

Table 161. DTW_TB_SETN 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

  1. Before calling DTW_TB_SETN(), set the number of columns in the table. 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.
  2. To delete a column heading, assign the column heading value to NULL.

Examples

Example 1: Assigns a name to column headings 1 through 3

%DEFINE myTable = %TABLE
 
@DTW_TB_SETCOLS(myTable, "3")
@DTW_TB_SETN(myTable, "Name", "1")
@DTW_TB_SETN(myTable, "Address", "2")
@DTW_TB_SETN(myTable, "Phone", "3")

Example 2: Delete the column heading for column 2. This is done by passing a variable on the function call which has not been defined. By default, this variable will have a value of NULL

%DEFINE myTable = %TABLE
 
@DTW_TB_SETN(myTable, nullVar, "2")


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