Hi,
I’m new on Clover, and I was trying to pass the count of one table into a graph parameter (i.e. $count) then use that parameter to do further logic check.
However I tried many ways (including DBExecute and DBInputTable) and always get error like “Optimizing connection failed: The CLOSE_CURSORS_AT_COMMIT option is not currently supported by the setHoldability method.”
Let’s assume the count query is: select count(*) from table1 where condition1=‘A’
and I want the value to be passed to $count.
Would you please advise how I should do it?
In SSIS I use to have: Select “count”=count(*) from table1 where condition1=‘A’, but this doesn’t seem to work here.
Thanks a lot