/* NOTE:
 * The jars or directories containing the java classes
 * org.postgresql.Driver and DataStepJdbcWrapper
 * _must_ be listed in the environment variable
 * CLASSPATH _prior_ to the SAS session being started.
 */

%include "sas/gateway-macros.sas";

%let jdbc_server_policy = gateway.policy;
%let jdbc_driver = org.postgresql.Driver;
%let db_url = jdbc:postgresql://www.devenezia.com:5434/sesug03demo;
%let username = sesug03demo ;
%let password = D3m0oeoe;
%let cHandle =;
%let sHandle =;

options mprint;

%startServer (
  policy = &jdbc_server_policy
)

%getConnectionHandle (
  driver = &jdbc_driver
, url = &db_url
, user = &username
, pass = &password
, cHandle_mv = cHandle
);

%put cHandle = &cHandle ;

%jdbcLoadTable (cHandle=&cHandle, data=sashelp.zipcode, obs=20);
%jdbcQuery (cHandle=&cHandle, sql=SELECT * FROM ZIPCODE, out=WORK.ZIPCODE);

options nocenter;

proc print data=jdbc_columns;
proc print data=zipcode;
run;

%closeConnection ( cHandle = &cHandle );