BookmarkSubscribeRSS Feed
waterfall
Calcite | Level 5

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

 

 

 

2 REPLIES 2
JBailey
Barite | Level 11

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;

 

LinusH
Tourmaline | Level 20
I just want to stress that anything that is specified within a connection to block is database specific, you will probably be better off asking this at a Greenplum forum.
Data never sleeps

sas-innovate-wordmark-2025-midnight.png

Register Today!

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.


Register now!

How to connect to databases in SAS Viya

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.

Discussion stats
  • 2 replies
  • 1012 views
  • 0 likes
  • 3 in conversation