Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Posts
    23

    Unanswered: using a shell script to retrieve and insert data into databases

    Hello,

    I am trying to write a script that retrieves data from a view in an Oracle database and then inserting that data into a Sybase database.

    I need to run this script every 5 minutes and retrieve all new data. What is the best way to do this? I have been able to write scripts that have fetched one row, but not multiple rows.

    Any hints?

  2. #2
    Join Date
    Dec 2002
    Posts
    104

    Re: using a shell script to retrieve and insert data into databases

    Originally posted by bgame
    Hello,

    I am trying to write a script that retrieves data from a view in an Oracle database and then inserting that data into a Sybase database.

    I need to run this script every 5 minutes and retrieve all new data. What is the best way to do this? I have been able to write scripts that have fetched one row, but not multiple rows.

    Any hints?
    Hello,

    I think u can take tha data out in a flat file and then with the use of format file BCP(bulk Copy) in the data into Sybase database and in unix u can make use of sleep function to introduce the wait period of 5 min.

    Hope this will work for u,
    --pooja

Posting Permissions

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