G-day all I was wondering. I want to know how most of ya-all handle this type of situation. We have a 2 databases we need to keep in sync (Actually same SCHEMA/db/tables/etc). To do this we unload the data at one place using the OUTPUT _to filename_ using the UNLOAD DATA command into a file and then FTP the file to another location and RUN _the file_ to load it back into the same database/table structure at the second location.
What happens is we have two users involved in this process. One keys in the data, and when she is satsified she prints a hardcopy, and this marks the data (one column) for the effected records for them to be sent. Then the first user contacts a more experienced user who then runs a routine to UNLOAD the data into files and FTP's them. What happens is that the user who is suppose to send them sometimes goofs, or when second user is gone someone else does this wrong or ???? and the UNLOAD sequence gets run more than once creating a file with no records overwriting the first file before it get's FTP'd. I am kinda thinking along the lines of a unique file naming schema, but this presents a real pain in coding a way to look for what has been loaded and what has not, and looking for file names or at least it seems so. I have also wondered about loading and unloading from different tables and figuring out some kind of tracking method, but have not done a lot of research in this area yet. I was wondering what methods are used by you all with great success? Thanks Jim Limburg __________________________________________________ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
