Hello, I am trying to extract big amount of data and I am getting this error: ERROR: CLI open cursor error: Could not receive the response, communication down ?? Is there any option that I need to add on my SQL pass through? proc sql; connect to odbc as hindsight (datasrc='PostgreSQL30' user=xxxxxxx password="xxxxxx" dbmax_text=12000); create table temp as select * from connection to hindsight (SELECT fact_event.fact_id,fact_event.region_cd,fact_event.transaction_dte,fact_event.roll_num, fact_event.property_cd,fact_event.property_desc,fact_event.cty_mun,value_dim.value_rounded, comp_dim.value_component_id, comp_dim.transaction_dte, comp_dim.unadjusted, comp_dim.value, comp_dim.valuation_type, comp_dim.priority, comp_dim.property_adjusted, comp_dim.component_adjusted, comp_dim.component_id, comp_dim.building_id_number, comp_dim.variables, comp_dim.active FROM hindsight_3.fact_event fact_event INNER JOIN (SELECT roll_num, max(transaction_dte) as max_transaction_dte FROM hindsight_3.fact_event fact_event WHERE fact_event.event_type='CMV' and fact_event.status_cd='A' GROUP BY roll_num) transaction_dte on fact_event.roll_num=transaction_dte.roll_num and fact_event.transaction_dte=transaction_dte.max_transaction_dte LEFT JOIN hindsight_3.property_dim property_dim ON fact_event.fact_id = property_dim.fact_id LEFT JOIN hindsight_3.value_component_dim comp_dim ON fact_event.fact_id = comp_dim.fact_id LEFT JOIN hindsight_3.value_dim value_dim ON fact_event.fact_id = value_dim.fact_id WHERE ((substring(fact_event.region_cd,1,1) = '0' and substring(fact_event.region_cd,2,1) = '09') or fact_event.region_cd = '09') and fact_event.event_type='CMV' and fact_event.status_cd='A' and property_dim.status_cd='A' ORDER BY fact_event.roll_num); quit; Thank you, Ave
... View more