IBM Books

Reference

V_columnName


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

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 | Table of Contents | Index ]