Toad World® Forums

use of variable

Hello all,

Could you please say to me how i can declare variables into sql optimizer for sap ase

Many thanks.

Olivier

Hi Olivier,

You don’t really need to declare bind variables when you optimize a SQL that uses bind variables. The product will detect bind variables in a SQL automatically and prompt you for values when you test run it or optimize it. In other words, you just need to put your SELECT statement in and hit the optimize button, then you will be prompted for bind variables.

Thanks,

Alex

Hi,

Thank you very much Alex

I’ll test that.

Thanks

Olivier

How i declare the variable in sql