"CLI cursor extended fetch error: Numeric value out of range" in Netezza

asimraja — Wed, 11 Jan 2017 00:51:56 GMT

Hi,

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!

Code:

====

proc sql;
connect to Netezza(server = ***** database = **** user = **** password = ****);
create table temp_loan_ds as
select * from connection to Netezza
(
select *
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;
quit;

;

Error

====

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

Re: "CLI cursor extended fetch error: Numeric value out of range" in Netezza

Patrick — Wed, 11 Jan 2017 01:19:32 GMT

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.

topic Re: "CLI cursor extended fetch error: Numeric value out of range" in Netezza in SAS Programming

"CLI cursor extended fetch error: Numeric value out of range" in Netezza

Re: "CLI cursor extended fetch error: Numeric value out of range" in Netezza