Hello Team ,
am a new user and trying to execute below sample DB2 program from SAS
proc sql;
connect to DB2
(
READ_ISOLATION_LEVEL=UR DATAsrc=Test AUTHDOMAIN="Test schema"
);
%let out_sql_code =0;
%let out_sql_state =0;
create table sasresults as select * from connection to db2
(call "temp".Test_DB2program_test (0,:out_sql_code,:out_sql_state));
disconnect from db2 ;
quit;
even if , am passing correct parameters while calling DB2 procedure , am still getting below error
error: cli execute error: [ibm][cli driver] cli0100e wrong number of parameters. sqlstate=07001
Can some one help how to fix this,
If you are running using FROM CONNECTION TO ... ( ) then the stuff in () has to return a TABLE.
If it doesn't then use EXECUTE BY ... () instead to run the stuff in ().
If you are running using FROM CONNECTION TO ... ( ) then the stuff in () has to return a TABLE.
If it doesn't then use EXECUTE BY ... () instead to run the stuff in ().
Thanks TOM ,
works with execute By .
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.