SQL Anywhere database - Re: SQL statement to enumerate all tables in a db and insert/modify

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: SQL statement to enumerate all tables in a db and insert/modify

Greg Fenton

2005-05-27, 3:23 am

AM wrote:
> I need to create a sql statement to enumerate all tables in
> a database and then copy data from a proxy table to the
> standard table.
>

Which version (and bulid number) of SQLAnywhere are you using? (e.g. use
the command "dbeng9 -v" for SQLAnywhere 9.x)

Is there are reason that you cannot use the sa_migrate() system
procedure (and associated "sub-procedures") ? What you are trying to do
sounds *exactly* like what they are designed to do.

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

Sponsored Links