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

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

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
  • 1224 views
  • 0 likes
  • 3 in conversation