Libname Engine (from Fraktal SAS Programming): Unterschied zwischen den Versionen

Aus phenixxenia.org
Zur Navigation springen Zur Suche springen
K
K
Zeile 8: Zeile 8:
 
|übersicht=DBMS Interaction (from Fraktal SAS Programming)
 
|übersicht=DBMS Interaction (from Fraktal SAS Programming)
 
}}
 
}}
 +
 +
It's awesome easy, to connect to your DBMS data using the SAS libref statement with a suitable qualifier '''''"oracle"'''''. Since Oracle data are not kept on some file system path but are managed by a running server process on some hardware on the network, the '''''"path"''''' parameter supplies the name of the process on the network you are having access to. Credentials are passed to the database server process using '''''"user"''''' and '''''"password"''''' parameters accordingly:
  
 
  libname ORA oracle user="&USER." password="&ORAPW." path="&ORADB." schema="ops$&SYSUSERID." dbindex=yes ORACLE_73_OR_ABOVE=YES dbserver_max_bytes=1 dbmax_text=32000;
 
  libname ORA oracle user="&USER." password="&ORAPW." path="&ORADB." schema="ops$&SYSUSERID." dbindex=yes ORACLE_73_OR_ABOVE=YES dbserver_max_bytes=1 dbmax_text=32000;

Version vom 30. Juni 2014, 16:43 Uhr

Zurück

Übersicht

Vorwärts

It's awesome easy, to connect to your DBMS data using the SAS libref statement with a suitable qualifier "oracle". Since Oracle data are not kept on some file system path but are managed by a running server process on some hardware on the network, the "path" parameter supplies the name of the process on the network you are having access to. Credentials are passed to the database server process using "user" and "password" parameters accordingly:

libname ORA oracle user="&USER." password="&ORAPW." path="&ORADB." schema="ops$&SYSUSERID." dbindex=yes ORACLE_73_OR_ABOVE=YES dbserver_max_bytes=1 dbmax_text=32000;

Zurück

Übersicht

Vorwärts