Re: question about chunking sql uploads

[Frank Bax]

At 02:07 PM 4/25/05, Scott Gifford wrote:

>SGreen@stripped writes:
>
> > Frank Bax <fbax@stripped> wrote on 04/25/2005 11:47:12 AM:
> >> Or simply use "split", default is 1000 lines, but can be changed via
> >> command line.
>
>That's a start, but the files each need to be a valid SQL statement,
>so that's not enough; a little fixup needs to happen at the beginning
>and end of each file.


OP did not say that the SQL statements crossed over a newline; but if they 
do, it is a trivial sequence of shell commands to "fix" them so that they 
are one line each.