I'm trying some pass-through code without success. I was able to find Oracle indexes with pass-through code, but perhaps I should not assume this is also possible with Greenplum. The log below shows what I tried:
Thanks for any help.
1378 proc sql;
1379
1380 connect to greenplm (user=xxxxx password=XXXXXXXXXXX dsn=gpdl_prd);
1381
1382 select * from connection to greenplm
1383 (Greenplum::SQLStatistics "","wcdl_pharm","NET_PAID_VW");
NOTE: No rows were selected.
1384 disconnect from greenplm;
1385 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.27 seconds
cpu time 0.06 seconds
Hi @waterfall,
Could there be a problem with the schema and tablename? Are you sure that table exists?
This works for me...
libname gplum greenplm server='greenplum.somecompany.com' database=indb schema=myuser user=myuser password=password; data work.testdata; do i = 1 to 100; x='aaaaaaaaaaaaaaaaaaaaaaaaaaaaa'; y='bbbbbbbbbbbbbbbbbbbbbbbbbbbbb'; z='ccccccccccccccccccccccccccccc'; output; end; run; proc append base=gplum.testdata data=work.testdata; run; proc sql; connect using gplum; select * from connection to gplum (Greenplum::SQLStatistics "", "myuser","testdata"); quit;
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.