Cart
[Home] [By Thread] [By Date] [Recent Entries]
Stef wrote:
Hello Barry,Sybase has a bulk load utility called bcp (at least that is what it used to be called). If you can get your data into a set of INSERT statements you can create a file that bcp can use. If your update operation is complex - referential constraints, lookups, unusual condition handling - you may be better served with a hybrid approach. You could load your data into a set of staging tables then process it with a stored procedure or program to get it into its final form. This last step has nothing to do with XSL but the overall approach is not that atypical: process your XML using XSL then let another more task-specific tool process the output. I have done exactly this with Oracle as the target but a Sybase-based approach would only differ in the detailed syntax. Barry
|
