topic CONNECTION PARAMETERS NEEDED in SAS Enterprise Guide

CONNECTION PARAMETERS NEEDED

deleted_user — Thu, 16 Apr 2009 06:24:13 GMT

Hi SAS Coders,
i m stuck up with a problem. actually i have an oracle table. CAn some one provide me the code so that i can fetch its connection parameters. Actually, i need these connection parameters for using the pass through technique...
Pls help( Guess metadata_getattr functions will be used...but how?)

Re: CONNECTION PARAMETERS NEEDED

LinusH — Thu, 16 Apr 2009 06:48:58 GMT

Yes, you can probably do it. We have an autoexec that collects metadata information so that we can assign META libname dynamically using this method. Unfortunately there is no good documentation around this area, but this paper from Global Forum 09 is a good starting point:

http://support.sas.com/resources/papers/proceedings09/095-2009.pdf

/Linus

Re: CONNECTION PARAMETERS NEEDED

deleted_user — Wed, 29 Apr 2009 13:54:17 GMT

...........Or I could blow my own trumpet and recommend this paper http://www2.sas.com/proceedings/forum2008/134-2008.pdf

You should start with the metadata type 'DatabaseSchema', From there you should find everything you need.