Re: using a shell script to retrieve and insert data into databases
Originally posted by bgame
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.
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.