01-10-2017 07:43 PM - edited 01-10-2017 07:51 PM
I'm trying to execute a pass-through query for Netezza. (see my code snippet below) but I'm getting the an error (see below).
I'm able to run this query without any issues in a Netezza SQL client. Can you please guide me what could be the issue? Thank you very much in advance!
connect to Netezza(server = ***** database = **** user = **** password = ****);
create table temp_loan_ds as
select * from connection to Netezza
from portfolio_instrument pi
join payment_structure ps on
(pi.portfolio_date = ps.portfolio_date
and pi.portfolio_id = ps.portfolio_id
and pi.instrument_id = ps.instrument_id
and pi.instrument_key = ps.instrument_key)
where pi.portfolio_date = &portfolio_dt.
and pi.fnm_ln_id in ('1234')
disconnect from Netezza;
ERROR: CLI cursor extended fetch error: Numeric value out of range : Numeric value out of range : Numeric value out of range : Numeric value out of range : Numeric value out of range : Numeric value out of range
01-10-2017 08:19 PM
Not exactly what you're doing but it could be something along the line of http://support.sas.com/kb/50/236.html
For testing purposes: Instead of using macro variable &portfolio_dt. use the value of this macro var hard coded as a string to ensure that this bit is working as expected.