Conditional in Netezza Connector

kld05 · Post by **kld05** » Sat Sep 06, 2014 12:54 pm

Is it possible use a conditional in the connector stage to execute a different query based the value of a variable? The BEGIN WORK clause is throwing an error when I try.

chulett · Post by **chulett** » Sat Sep 06, 2014 2:20 pm

Not sure but might depend on your definition of 'conditional' - can you give us some examples of what you'd want to do based on a variable? What would vary? Do they all have the same metadata?

<edit: removed bogus target suggestion>

kld05 · Post by **kld05** » Sun Sep 07, 2014 8:22 am

I am trying to implement something similar to the following logic which works in Sybase. The metadata is identical.

IF <Condition>

BEGIN

Sql1

END

ELSE

BEGIN

Sql2

END