topic Re: Testing teradata connection or any server connection in SAS Programming

Testing teradata connection or any server connection

nbonda — Tue, 20 Aug 2019 16:38:39 GMT

I am trying to extract some data from Teradata but before executing code I would like to test server connection.

I want to execute code only when server is up.

Is there any SAS statement/function that can be used to test server connection in batch mode.

Re: Testing teradata connection or any server connection

Tom — Tue, 20 Aug 2019 17:23:03 GMT

How are you connecting to the server?

The LIBNAME statement will set the macro varaible SYSLIBRC which you can then check.

libname td teradata ..... ;
%if (&syslibrc) %then %do;
  %put ERROR: Could not connect to Teradata ;
%end;
%else %do;
  ... run extract code ...
%end;

Re: Testing teradata connection or any server connection

r_behata — Tue, 20 Aug 2019 17:45:34 GMT

PROC SQL;
    
     CONNECT TO TERADATA(DATABASE=<dbname>  USER=<user> PASSWORD=<pwd>);

     CREATE TABLE temp AS
     SELECT * FROM CONNECTION TO TERADATA
     (SELECT * from <table_name> 
       sample 0
) ;
        DISCONNECT FROM TERADATA;
QUIT;

Try this if you are using SQL Pass through to teradata