Hi Scott:
Thanks so much for the info on the scoping aspect of the database.
That's about the closest thing I've read yet to being able to "alias" the
DBC. This just may be possible after all.
Jon
----- Original Message -----
From: "Scott King"
Sent: Tuesday, October 02, 2007 7:05 AM
Subject: RE: Trying to find programmatic ways to copy data from one
databasetoanother
> > 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.
