topic Re: rsubmit fedsql in SAS Programming

rsubmit fedsql

mansour_ib_sas — Mon, 29 Oct 2018 18:39:03 GMT

Hello,

I use for the first time fedsql with rsubmit.

I have i my log this error

proc fedsql;
ERROR: General error ORA-01017: invalid username/password; logon denied
ERROR: TKTS initialization failed.

I use this request

%let srv_c=xxxxxxxx port;
%let user_c = xxxxxxx ; 
%let pwd_c = xxxxxxxx ;
 

options comamid=tcp remote=srv_c;
signon user="&user_c"   password="&pwd_c" ;

rsubmit srv_c ;
option obs=max nosyntaxcheck;

libname myora oracle PATH="xxxxxx"  SCHEMA="xxxxxxxx" USER="xxxxxxxxxxxxxxxxxxxx" PASSWORD="xxxxxxxxxxxxxxxxx" access=readonly defer=yes ;

endrsubmit ;

libname myora server = srv_c;


rsubmit;

proc fedsql;

create table table as select a.*
from myora.table as a

;
quit;

endrsubmit;

can you help me

thank you

Re: rsubmit fedsql

LinusH — Mon, 29 Oct 2018 20:10:58 GMT

Well, it looks like you have not correct credentials.

Or is there something in the set-up that tells that there something different...?

Re: rsubmit fedsql

mansour_ib_sas — Tue, 30 Oct 2018 09:17:29 GMT

Thank you,

I remake the test:

proc fedsql;
select sex, avg(height) as avg_height, avg(weight) as avg_weight from
sashelp.class group by sex;
quit;

Log:

1 proc fedsql;
NOTE: Writing HTML Body file: sashtml.htm
2 select sex, avg(height) as avg_height, avg(weight) as avg_weight from
3 sashelp.class group by sex;
ERROR: Table "SASHELP.CLASS" does not exist or cannot be accessed
ERROR: BASE driver, schema name SASHELP was not found for this connection
4 quit;

With rsubmit:

rsubmit;

proc fedsql;
select sex, avg(height) as avg_height, avg(weight) as avg_weight from
sashelp.class group by sex;
quit;

endrsubmit;

Log:

455 proc fedsql;
ERROR: General error ORA-28000: the account is locked
ERROR: TKTS initialization failed.
456 select sex, avg(height) as avg_height, avg(weight) as avg_weight from
457 sashelp.class group by sex;
458 quit;

Re: rsubmit fedsql

mansour_ib_sas — Tue, 30 Oct 2018 09:47:01 GMT

This now, work normaly

libname tt 'C:\'; 
data tt.test;
set sashelp.class;run;

proc fedsql;
create table test1 as 
select * from tt.test;
quit;

Re: rsubmit fedsql

SylviaPowell — Wed, 14 Nov 2018 22:47:22 GMT

The SASHELP library is not available to PROC FEDSQL or PROC DS2. The FedSQL and DS2 languages run outside of the SAS supervisor kernel, so cannot access SASHELP. They are also not affected by most SAS system options.