PRODUCTS

DOWNLOAD

BUY

LEARN

SUPPORT

COMPANY

Cart

[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] Re: XML to Database Inserts via XSLT Play the video Subject: Re: XML to Database Inserts via XSLT From: Barry Lay <blay@xxxxxxxxxxxxxxxxxxx> Date: Wed, 09 Mar 2005 19:50:54 -0500 Stef wrote: Hello Barry, I do not disagree with you, but (sadly ?) the database that is used here is Sybase, and not even an 'upto date' version either (12.0). I am not at liberty to change the underlying database technology sadly, but, them's the breaks. 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 Current Thread RE: XML to Database Inserts via XSLT, (continued) Michael Kay - 9 Mar 2005 22:40:27 -0000 Brian Chrisman - 10 Mar 2005 07:40:46 -0000 Barry Lay - 9 Mar 2005 21:21:58 -0000 Stef - 9 Mar 2005 21:57:13 -0000 Barry Lay - 10 Mar 2005 00:51:16 -0000 <= Aron Bock - 10 Mar 2005 04:12:54 -0000 Stef - 10 Mar 2005 16:46:33 -0000 Wendell Piez - 10 Mar 2005 17:23:02 -0000 <- Previous Index Next -> Re: XML to Database Inserts v, Stef Thread RE: XML to Database Inserts v, Aron Bock Re: if condition, Wendell Piez Date Re: XSLt in RDBMs engine? (wa, Barry Lay Month

PURCHASE STYLUS STUDIO ONLINE TODAY! Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE! Accelerate XML development with our award-winning XML IDE - Download a free trial today! Don't miss another message! Subscribe to this list today. Email First Name Last Name Company Subscribe in XML format RSS 2.0 Atom 0.3

Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.