The DLURLCOMPLETE function returns the complete URL value from a DataLink value with a link type of URL. The value is the same as what would be returned by the concatenation of DLURLSCHEME with '://', then DLURLSERVER, and then DLURLPATH. If the DataLink has an attribute of FILE LINK CONTROL and READ PERMISSION DB, the value includes a file access token.
If the argument can be null, the result can be null; if the argument is null, the result is the null value.
The result of the function is a varying-length string. The length attribute depends on the attributes of the DataLink:
If the DataLink value only includes the comment, the result returned is a zero length string.
The CCSID of the character string is the same as that of DataLink-expression.
INSERT INTO TABLA VALUES( DLVALUE('http://dlfs.almaden.ibm.com/x/y/a.b','URL','A comment') )then the following function operating on that value:
SELECT DLURLCOMPLETE(COLA) FROM TBLAReturns the value 'HTTP://DLFS.ALMADEN.IBM.COM/x/y/****************;a.b', where **************** represents the access token.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.