At first, the method of storing the data in the SQL server was problematic. Sybase at the time, had no immediate solutions and using Open-Client/DB Library was a minimal solution because of the cost, and the learning curve required to program the libraries to insert data. Because of this a system was developed which scans a storage area and applies tab delimited files to the SQL server using a method known as bulk-copy. Over the years this system has been developed into what we affectionately refer to as The Update System. The update system has been modified to run stored procedures following an update, check for deadlocks and handle them, allow for static or dynamic index recreation, keep automatic time-stamping of table loads and many other items.
For More information select one of the links below.
Back to the ACS Sybase Archive