Hello all, I've recently begun to study the sapdb and so far I really like it. We are looking to move off of MS-SQL Server but I just don't feel MySQL has all the features we need so I'm glad to have found sapdb.
I have been working with the loadercli and reading the archives on it. I just wanted to double-check some of the functionality so I don't go off and code something that is already there. When importing csv files, if *any* field is delimited by double quotes then *all* fields need to be delimited by double quotes. Is my understanding correct? For instance, exporting from SQL Server will put double quotes around varchar fields while not double quoting int, datetime, etc. fields. I then have to transform the data somehow in order to be able to import with the loadercli tool if I don't want to write an app to insert the rows one-by-one, correct? The app I'm developing needs to do an import at least once a week of over 1GB of data from separate csv files that come to us with certain fields delimited by double quotes and others not. I have no control over how the data is exported so I just want to be sure I have the correct understanding. Thanks! Derek Hamilton _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
