AnsweredAssumed Answered

IF workflow and VARA EXEC

Question asked by AndreasSchwarzinger608619 on Feb 6, 2018
Latest reply on Feb 6, 2018 by Claus_Jambrich_5663

Hello,
I'm not sure how best to describe my problem, but I'll start once.
If I have forgotten something, I will answer your questions

I have a VARA EXEC that issues a SQL JOB with a statement to determine the number of rows in a table. this works fine.
Now I want to build a IF wokflow with this number as a decision criterion.

I can not do that, i always start the true branch.

IF

{VARA.EXEC.DXE.DQ001,,1}>0

THEN

publish value {VARA.EXEC.DXE.DQ001,,1} as RRC#

FINALLY Execute TRUE branch with alias RECORDS FOUND

ELSE

publish value {VARA.EXEC.DXE.DQ001,,1} as RRC#

FINALLY Execute FALSE branch with alias  NO RECORDS FOUND

2018-02-06 14:13:57 - U00020206 Variable '&J_TBL#' was stored with value 'LDS_FIN_P_HAUSHALTSJAHRE_TMP'. 2018-02-06 14:13:57 - U00020206 Variable '&J_TST#' was stored with value ''2018-01-04 06:00:19''. 2018-02-06 14:13:58 - U00020206 Variable '&RRC#' was stored with value ''. 2018-02-06 14:13:58 - U00020206 Variable '&J_TBL#' was stored with value 'LDS_FIN_P_HAUSHALTSJAHRE_TMP'. 2018-02-06 14:13:58 - U00020206 Variable '&J_TST#' was stored with value ''2018-01-04 06:00:19''. 2018-02-06 14:13:58 - IF {VARA.EXEC.DXE.DQ001,,1} > 0 2018-02-06 14:13:58 -    True 2018-02-06 14:13:58 - THEN set object variable RRC# to {VARA.EXEC.DXE.DQ001,,1} in scope 2018-02-06 14:13:58 - U00020230 Value '&RRC#' in object: 'XC_INC.ACTION.PUBLISH_VALUE',
line: '00013' (RunID: '0199361069') was changed from '' to '{VARA.EXEC.DXE.DQ001,,1}'
 using the command :SET/PUBLISH_VALUE. 2018-02-06 14:13:58 - FINALLY Execute TRUE branch with alias RECORDS FOUND 2018-02-06 14:13:58 - U00007000 'JOBS.UNIX.DXE.HW' activated with RunID '0199346298'.

thank you for your help
andreas

Outcomes