NULL_RPT_FIELD

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





X


Purpose

Specifies a string the user can provide to the DTW_SQL language environment to represent NULL values that are returned in an SQL result set.

Specify the value of this variable using a DEFINE statement or with the @DTW_ASSIGN() function.

Values

NULL_RPT_FIELD="null_char"

Table 19. NULL_RPT_FIELD Values
Values Description
null_char Specifies a string to represent NULL values that are returned in an SQL result set. The default is an empty string.

Examples

Example 1: Specifies a string representing NULL values in the SQL language environment

%DEFINE NULL_RPT_FIELD = "++++"


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