Hi Guys,
I am new to Cognos and trying to insert a condition node to my ETL build. Could someone please confirm if following is the correct syntax to run and compare the sql results:
$U_DAY_SID := LOOKUP('TARGET','SELECT MIN(DAY_SID)+1 FROM DIM_DAYZ WHERE PER_OFF=0');
$U_SYS_DATE := LOOKUP('TARGET','SELECT TO_CHAR(SYSDATE,'YYYYMMDD') FROM DUAL');
IF $U_DAY_SID = $U_SYSDATE THEN RETURN TRUE
ELSE
BEGIN
LOGMSG('Dates don't match')
RETURN FALSE;
END
Looks correct,other than a missing semicolon at the end of logmsg statement. You can test this by 'Test' command at the condition node.