Desktop productivity for business analysts and programmers

CONNECTION PARAMETERS NEEDED

Reply
N/A
Posts: 0

CONNECTION PARAMETERS NEEDED

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?)
Esteemed Advisor
Posts: 5,198

Re: CONNECTION PARAMETERS NEEDED

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
Data never sleeps
N/A
Posts: 0

Re: CONNECTION PARAMETERS NEEDED

...........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.
Ask a Question
Discussion stats
  • 2 replies
  • 77 views
  • 0 likes
  • 2 in conversation