Decision Stream Condition Node

[sappleg]

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

[UseCog]

Looks correct,other than a missing semicolon at the end of logmsg statement. You can test this by 'Test' command at the condition node.