CONNECTION PARAMETERS NEEDED

[deleted_user]

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?)

[LinusH]

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

[deleted_user]

...........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.