Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Location
    Montreal, Canada
    Posts
    151

    Unanswered: Data intergrety between 2 enviroments

    we have a table that after being loaded we bulk copy it to a as400 table and then truncate the sql server table.. lets say the 400 shuts down my transaction pile ups so iam thinking lets put the transaction in a temp table and then roll another job every 10 minute to check on the as400 if it exist if it dosent then insert the record is there a way to pass a query to the as400 from sql or to conect on a as400 and query the databse

  2. #2
    Join Date
    May 2002
    Location
    Cape Town , South Africa
    Posts
    30

    Talking as400 table

    HIllcat

    Does your As400 server switch off alot , do you know which times this server is availiable..if yes then i would suggest you create and shedule a job to transfer the sql data to the as400 table(s) during the uptime period by using DTS.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •