2006/2/11, Rami AL-SAHHAR <[EMAIL PROTECTED]>: > Thanks Robert, > > The file contains SQL insert statements only generated by TOAD from Oracle > 9iDB. > > Actaully , I've fixed this issue by manually editing the SQL file and > putting the statement seprator in a new line instead of end of the statement > as before , that's why it is not recognized it seems by SQLCLI program, but > this is too much effort to do it , any suggestion ?
IIRC I had similar problems with executing scripts via sqlcli. It's a bit clumsy. If you need to modify larger scripts, Perl, Ruby and Python are your friends (or even sed and awk). > P.S : I even used -m to enforce multipline statements , but still not > working. Do I have to go and read about Loader ?I heard about it but no idea > what it does It loads CSV data from and to a MaxDB database. You can even dump databases and have it dump DDL as well as data. robert -- Have a look: http://www.flickr.com/photos/fussel-foto/ -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
