SQL Reference

DLLINKTYPE

>>-DLLINKTYPE--(--datalink-expression--)-----------------------><
 

The schema is SYSIBM.

The DLLINKTYPE function returns the linktype value from a DATALINK value.

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

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

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:

     DLLINKTYPE(COLA)
  

  will return the value:

     URL
  

[ DB2 List of Books | Search the DB2 Books ]