AIX | HP-UX | Linux | OS/2 | OS/390 | OS/400 | SCO | 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.
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> %} %} %}