Substitution variables - using DECLARE
Check the documentation for Netezza. AFAIK, Netezza's SQL is based on PostgreSQL.
If you cannot find documents for Netezza, check PostgreSQL.
>It's NetezzaSQL. The 2 options I described would have worked with TransactSQL or
PL/SQL.
>I cannot find a different syntax for Netezza SQL.
>
>>The answer to this question depends upon the back-end you are using. Refer to the
>>documentation
>of
your back-end. For example, if you are using SQL Server, you should
>>be using the syntax for TransactSQL and if you are using Oracle, it should be PL/SQL
>>
>>JB
>>
>>>What
>>is
>the
correct syntax for creating a substitution variable?
>>>I tried
>>>declare mo integer;
>>>set mo=08;
>>>and
>>>declare @mo as integer;
>>>set @mo=08;
>>>and it does not work.
>>>Thanks.
