Tried with the trace option. is there any other tracing option available to get more information on this ERROR? 32 proc sql; 33 select count(*) from RSHIFT.ev_rebate_application; 6 1590596507 no_name 0 SQL (2) REDSHIFT_2: Prepared: on connection 1 7 1590596507 no_name 0 SQL (2) SELECT * FROM "shelecv".EV_REBATE_APPLICATION 8 1590596507 no_name 0 SQL (2) 9 1590596507 no_name 0 SQL (2) ERROR: CLI prepare error: [SAS][ODBC Redshift Wire Protocol driver]Socket closed. SQL statement: SELECT * FROM "shelecv".EV_REBATE_APPLICATION. NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 34 quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.01 seconds
... View more