topic Re: ERROR: CLI open cursor error: ODBC Driver NonStop SQL message in SAS Programming

ERROR: CLI open cursor error: ODBC Driver NonStop SQL message

chennupriya — Wed, 09 Oct 2019 20:39:43 GMT

Hi ,

I am running below program and I am getting error when I run with table b

proc sql;

CONNECT TO ODBC AS tg (DSN = "Test" UID=test2 PWD=&xy);

CREATE TABLE testing AS

SELECT * FROM CONNECTION TO tg (

SELECT a.apple as apple

b.sgsystem as id,

count(*) as hh

FROM zx as a

Gc as b

WHERE a.pol = b.pol

AND a.key = b.key

GROUP BY apple,id );

DISCONNECT FROM tg;

QUIT;

ERROR: CLI open cursor error: [Tandem][ODBC Driver][NonStop SQL] NonStop SQL message (8013) :

Internal error: Unable to increase the size of the SQL executor's extended segment. The

current segment size is 133693440 bytes.illegal <count> specified

Can anyone please help

Thank you so much

Re: ERROR: CLI open cursor error: ODBC Driver NonStop SQL message

Reeza — Wed, 09 Oct 2019 20:44:28 GMT

I would interpret that error to be that the data you're pulling is larger than the space they've allotted you on the server. Can you check with your IT teams if they have size limits on your account?

Re: ERROR: CLI open cursor error: ODBC Driver NonStop SQL message

chennupriya — Thu, 17 Oct 2019 17:30:09 GMT

Thank you for the help . I can check and see 🙂