> I'm trying to automate a process to move all data from > the tables in one database to another, but I've hit a snag. > The database itself is named the same, and I can't find any > reference information on how to refer to two different > databases that have the same name at the same time. I know > that I can alias a table with no problem, but can I also > alias a database? > > Any suggestions on how best to accomplish this, short of > changing the database name in the newer application, would be > greatly appreciated. >
You can open the databases in separate Session objects that have their own data sessions since SET DATABASE is scoped to the current data session. Using SCATTER NAME, you can create each record as an object for loading (GATHER NAME) into the new table/db. Scott _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
