Hi, I currently run on a free trial of SAS Viya and wish to verify that I can query my DB before we purchase. I wish to connect via JDBC and can not find a full working example of a select statement online. Can someone please assist? Attached below the example I've written by documentation I found online cas casauto;
caslib jdcaslib desc='JDBC Caslib'
dataSource=(srctype='jdbc',
url="jdbc:Sqream://3.16.23.107:5001/master",
username='sqream',
password='sqream'
class="com.sqream.jdbc.SQDriver"
classpath="/Public/SQream/SqreamJDBC.jar",
schema="public");
proc casutil;
list files incaslib="jdcaslib";
load casdata="nation" incaslib="jdcaslib" outcaslib="casuser"
casout="DBdata_from_jdcaslib";
list tables incaslib="casuser";
contents casdata="DBdata_from_jdcaslib" incaslib="casuser";
quit;
... View more