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;
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
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.