V_columnName

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

Purpose

The value for the specified column name for the current row. The variable is not set for undefined column names. A query containing two column names with the same name gives unpredictable results. Consider using an AS clause in your SQL to rename duplicate column names.

You can reference V_columnName only within a ROW block.

Net.Data assigns the variable for each column in the table; use the variable in a variable reference, specifying the name of the column you want to reference. To use this variable outside the block, assign the value of V_columnName to a previously defined global variable or an OUT or INOUT function parameter variable.

Values

V_columnName

Table 1. V_columnName Values
Values Description
columnName The column name in current row of the database table.

Examples

Example 1: Using V_columnName as a variable reference

%FUNCTION(DTW_SQL) myQuery() {
 SELECT NAME, ADDRESS from $(qtable)
 %REPORT{
 
 %ROW{
 
 Value of NAME column in row $(ROW_NUM) is $(V_NAME).<br />
 %}
 %}
 %}


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