Function sequence error (SAS Federation Server)

[John_Wick]

Hello, experts

When I try to make a simple query select and put the result into a variable on Federation Server using DS2 code, I get the following error

EG log:

Spoiler

ERROR: Function sequence error

ERROR: GETINTEGER for column 1 failed on result set of SQL Statement: select 1 from CDM.RTDMCDM1.CI_CAMPAIGN

Federation server log:

Spoiler

2024-11-25T20:44:33,825 TRACE [00028094] App.Statement.Statement.GetDiagRecs 458:sasdmadm@saspw - IOM RETURN
0={compRef:7f0166c5e800}->Statement::GetDiagRecs():
sqlStates=[0…1]
[0]=HY000
[1]=HY010
nativeerror=[0.1]
[0]=-2038444017 [1]=-2130708356
message text=[0.1]
[[0]=GETINTEGER for column 1 failed on result set of SQL statement: select 1 as output_var from CDM.RTDMCDM1.CI_CAMPAIGN
[1]=Function sequence error
status=[0…1]
[0]=0 [1]=0

The code looks like this:

proc ds2;
data _NULL_;
  method run();
    dcl int output_var;
    dcl package sqlstmt s('SELECT 1 FROM CDM.RTDMCDM1.CI_CAMPAIGN');
    output_var = s.getInt(1);
  end;
enddata;
run;
quit;

Can you tell me what this error might be related to?

This problem is observed with functions like getInt, getchar, etc.

[John_Wick · Accepted solution]

I apologise, my mistake. The problem was that I used functions incorrectly.
To make my code work, you need to add additional lines:

proc ds2;
data _NULL_;
  method run();
    dcl int output_var;
    dcl package sqlstmt s('SELECT 1 FROM CDM.RTDMCDM1.CI_CAMPAIGN');
    s.execute();
    s.fetch();
    output_var = s.getInt(1);
  end;
enddata;
run;
quit;