The DLCOMMENT function returns the comment value, if it exists, from a DataLink value.
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.
The CCSID of the character string is the same as that of DataLink-expression.
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;
INSERT INTO TBLA VALUES (DLVALUE('http://dlfs.almaden.ibm.com/x/y/a.b','URL','A comment'))then the following function operating on that value:
SELECT DLCOMMENT(COLA) FROM TBLAReturns the value 'A comment'.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.