G
Guest
I have two databases linked by ODBC to two separate file libraries on an
AS-400. The file structure in both libraries is exactly the same, but the
data is different. I only want to maintain one database, so I usually update
database 1 and then copy any of the queries, reports, etc. over to the second
database. The problem is that when I copy a query, the table links point to
the original library. Is there any way to copy a database or query to
another database and have it automatically update the machine source, as long
as the field names within the machine source are the same?
AS-400. The file structure in both libraries is exactly the same, but the
data is different. I only want to maintain one database, so I usually update
database 1 and then copy any of the queries, reports, etc. over to the second
database. The problem is that when I copy a query, the table links point to
the original library. Is there any way to copy a database or query to
another database and have it automatically update the machine source, as long
as the field names within the machine source are the same?