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 = "++++"