DLLINKTYPE

The DLLINKTYPE function returns the link type value from a DataLink value.

Read syntax diagramSkip visual syntax diagramDLLINKTYPE (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(4). If the argument can be null, the result can be null; if the argument is null, the result is the null value.

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 DLLINKTYPE(COLA)
    FROM TBLA
    Returns the value 'URL'.