'Is it possible to pre-assign a macro statement within netezza SQL?

Is it possible to pre-assign a macro statement within netezza SQL? For example:

select *
from database
where date between $start and $end

In this example $start and $end are both macro variables. If I run this statement, the so-called Query Parameter Edit opens and asks for both a value and a type.

Is it possible to pre determine/fill-in the value as the type?

Thanks!

sqlnetezza


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions