DLVALUE

Click to skip syntax diagram
Read syntax diagramSkip visual syntax diagram>>-DLVALUE--(--data-location--+-------------------------------------------+--)-><
                              '-,--linktype-string--+-------------------+-'
                                                    '-,--comment-string-'
 

The DLVALUE function returns a DataLink value. When the function is on the right hand side of a SET clause in an UPDATE statement or is in a VALUES clause in an INSERT statement, it usually also creates a link to a file. However, if only a comment is specified (in which case the data-location is a zero-length string), the DataLink value is created with empty linkage attributes so there is no file link.

data-location
If the link type is URL, then this is a character string expression that contains a complete URL value. If the expression is not an empty string, it must include the URL scheme and URL server. The actual length of the character string expression must be less than or equal to 32718 characters.
linktype-string
An optional character string expression that specifies the link type of the DataLink value. The only valid value is 'URL'.
comment-string
An optional character string expression that provides a comment or additional location information. The actual length of the character string expression must be less than or equal to 254 characters.

The comment-string cannot be the null value. If a comment-string is not specified, the comment-string is the empty string.

If the first argument can be null, the result can be null; if the first argument is null, the result is the null value.

The result of the function is a DataLink value.

The CCSID of the DataLink is the same as that of data-location except in the following cases:

When defining a DataLink value using this function, consider the maximum length of the target of the value. For example, if a column is defined as DataLink(200), then the maximum length of the data-location plus the comment is 200 bytes.

Examples


43.
If the CCSID of comment string is 5026 or 930, the CCSID of the results will be 939.