Pular para conteúdo

2021

  • 1 min de leitura

Criando LIBNAMEs

Conectando LIBNAMEs
1
2
3
4
5
6
/* Conectando com AUTHDOMAIN */
LIBNAME SCHEMA01 DB2 DATABASE=DB01 SCHEMA=SCHEMA01 AUTHDOMAIN=USUARIO;


/* Conectando sem AUTHDOMAIN */
LIBNAME PGCDS postgres SERVER='192.168.0.1' DATABASE='database' PORT='5432' USER='usuario' PASS='senha' schema='schema01';
  • 1 min de leitura

Consulta de Passagem - SQL Pass-trough

Consulta de passagem com AUTHDOMAIN
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
proc sql;
    connect to db2 (DATABASE=DB01 AUTHDOMAIN=USUARIO);
    create table dados as 
    select * from connection to db2 (
        SELECT 
        *
        FROM schema.tabela 
        WHERE data_ref = current_date;
    ) a;
    disconnect from db2;
quit;

``` SAS title="Consulta de passagem sem AUTHDOMAIN" linenums="1" proc sql; connect to postgres (server='192.168.0.1' port=5432 user=usuario password=senha db=banco); create table dados as select * from connection to postgres ( select * from schema.tabela; ) a; disconnect from postgres; quit;