SQL Reference

DLCOMMENT

>>-DLCOMMENT--(--datalink-expression--)------------------------><
 

The schema is SYSIBM.

The DLCOMMENT function returns the comment value, if it exists, from a DATALINK value.

The argument must be an expression that results in a value with data type of 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.

Example:

• Prepare a statement to select the date, the description and the comment from the link to the ARTICLES column from the HOCKEY_GOALS table. The rows to be selected are those for goals scored by either of the Richard brothers (Maurice or Henri).

    stmtvar = "SELECT DATE_OF_GOAL, DESCRIPTION, DLCOMMENT(ARTICLES)
                 FROM HOCKEY_GOALS
                 WHERE BY_PLAYER = 'Maurice Richard' 
                 OR BY_PLAYER = 'Henri Richard' ";
    EXEC SQL PREPARE HOCKEY_STMT FROM :stmtvar;
  

• 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:

     DLCOMMENT(COLA)
  

  will return the value:

     A comment