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
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 /> %} %} %}