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

[chennupriya]

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

[Reeza]

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?

[chennupriya]

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