11-28-2016 03:22 PM
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;
1380 connect to greenplm (user=xxxxx password=XXXXXXXXXXX dsn=gpdl_prd);
1382 select * from connection to greenplm
1383 (Greenplum:QLStatistics "","wcdl_pharm","NET_PAID_VW");
NOTE: No rows were selected.
1384 disconnect from greenplm;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.27 seconds
cpu time 0.06 seconds
11-30-2016 11:47 AM - edited 11-30-2016 11:51 AM
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;
12-01-2016 07:05 PM