DLURLSCHEME

The DLURLSCHEME function returns the scheme from a DataLink value with a linktype of URL. The value will always be in upper case.


>>-DLURLSCHEME--(--DataLink-expression--)----------------------><

DataLink-expression: An expression that results in a value with a built-in DataLink data type.

The result of the function is VARCHAR(20). 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.

The CCSID of the character string is the same as that of DataLink-expression.

Examples

Given a DataLink value that was inserted into column COLA of a row in table TBLA using the scalar function:
```
  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 DLURLSCHEME(COLA)
    FROM TBLA
```
Returns the value 'HTTP'.