DLURLSERVER
The DLURLSERVER function returns the file server from a DataLink value with a linktype of URL. The value will always be in upper case.
- DataLink-expression
- An expression that results in a value with a built-in DataLink data type.
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 with a length attribute of that is equal to the length attribute of the argument.
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:
then the following function operating on that value:INSERT INTO TABLA VALUES( DLVALUE('http://dlfs.almaden.ibm.com/x/y/a.b','URL','A comment') )
Returns the value 'DLFS.ALMADEN.IBM.COM'.SELECT DLURLSERVER(COLA) FROM TBLA