DATA Step, Macro, Functions and more

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

Reply
Contributor
Posts: 30

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

[ Edited ]

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

Respected Advisor
Posts: 3,886

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

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.

 

 

Ask a Question
Discussion stats
  • 1 reply
  • 500 views
  • 0 likes
  • 2 in conversation