SQL Reference

DLURLCOMPLETE

>>-DLURLCOMPLETE--(--datalink-expression--)--------------------><

The schema is SYSIBM.

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, then '/' and then DLURLPATH. When appropriate, the value includes a file access token.

The argument must be an expression that results in a value with data type DATALINK.

The result of the function is VARCHAR(254). If the argument can be null, the result can be null; if the argument is null, the result is the null value.

If the DATALINK value only includes the comment the result returned is a zero length string.

Example:

Given a DATALINK value that was inserted into column COLA of a row in table TBLA using the scalar function:
```
   DLVALUE('http://dlfs.almaden.ibm.com/x/y/a.b','URL','a comment')
```
then the following function operating on that value:
```
   DLURLCOMPLETE(COLA)
```
will return the value:
```
   HTTP://DLFS.ALMADEN.IBM.COM/x/y/****************;a.b
```
(where **************** represents the access token)

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

[ DB2 List of Books | Search the DB2 Books ]