SQL Pass-Through

SQL Pass-Through
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
/* Consulta de passagem com usuário AUTHDOMAIN */
proc sql;
    connect to db2 (DATABASE=banco AUTHDOMAIN=usuario);
    create table dados as 
    select * from connection to db2 (
        SELECT *
        FROM tabela;
    ) a;
quit;


/* Consulta de passagem com usuário com usuário e senha */
proc sql;
    connect to postgres (
        server='192.168.0.1' 
        port=5432 
        user=postgres 
        password=senha
        db=banco
    );
    create table dados as 
    select * from connection to postgres (
        select * from tabela;
    ) a;
quit;