Hi, Very Please to hear this that it should be possible if we could have such option to Call any Database Source in a lib as mention by Pawel jcompile but pawel please if u define a little brief it would be help full for all of US :-)
2009/4/9 Pawel (privately) <[email protected]> > Hi, > > Not an easy, but very good requirement. In my opinion this possible (or at > least should be). > > jcompile 4.1 jBASE compiler (not T24 EB.COMPILE wrapper of jcompile) has > ability to compile jBASIC code with SQL embedded statements. In such a way > you should be able to connect to different Oracle database / instance. > Perhaps not only Oracle database, but any other SQL-like and jBASE > supported, eg. IBM DB2, SQL server. I can also imagine that you would need > to have db client libraries installed. I belive that in your T24 Oracle > installation you already has them installed. > > I think that it is time to keep smiling to Jim to get some more detailed > hints :) > > Kind regards > Pawel > > Dnia 9-04-2009 o godz. 18:58 Mujtaba Khan napisał(a): > > Hi, > > in my view NO way .. > > as in jedi_config you can use only single SID > > 1. List current setting. > 2. Set database. > 3. Set data tablespace. > 4. Set index tablespace. > 5. Set prefetch count. > 6. Set prefetch memory. > > 9. Back to main menu. > > Select option: 1 > > * Database TNS: 'TEST'* > Data tablespace: 'TESTDATAXML' > Index tablespace: 'TESTINDEXXML' > Prefetch count: '1000' > Prefetch memory: '' > > > > > > On Thu, Apr 9, 2009 at 6:17 PM, Shiva S <[email protected]> wrote: > >> Hello Everybody, >> >> I am in a client place now where Model Bank Implementation is going on. >> DataBase is ORACLE. >> >> There is a requirement here which is stated below. >> >> As you all know data in jBASE is stored in the form of FILES where as in >> ORACLE it is stored in the form of TABLES. >> >> We have T24 - jBASE - XMLORACLE Driver - ORACLE DataBase Instance >> >> XMLORACLE Driver will take care of storing the data in ORACLE in the form >> of Tables. >> >> There is an Environmental Variable by name ORACLE_SID which is used to >> indicate the ORACLE Instance on which to update the data. I may be wrong on >> this. Please correct me on this point if i am wrong. >> >> Say suppose in a single server we have 2 ORACLE Instances. Say for >> example: >> >> * ORACLE Instance 1 - Exclusively for T24. All T24 data by default comes >> and stores here. This is the Instance specified in ORACLE_SID >> * ORACLE Instance 2 - For an External System >> >> Say that i have a requirement where i have to create a Local Template, the >> data of which has to be stored in ORACLE Instance 2. >> >> So the requirement is as below: >> >> Can T24 have access to multiple Instances of ORACLE at the same time? >> (Programatically speaking in a Single Classic Mode Session) >> >> Best Regards >> Shiva Shankaran S >> >> >> > > > > > > Kind regards > Pawel > > > > > ---------------------------------------------------- > Wyślij kurczaka na święta - Kliknij: > > http://klik.wp.pl/?adr=http://corto.www.wp.pl/as/wielkanocnykurczak.html&sid=690 > > > --~--~---------~--~----~------------~-------~--~----~ Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24 To post, send email to [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en -~----------~----~----~----~------~----~------~--~---
