by I've got a view with a half-million rows in it. The view is a result of
a table join between two tables, each of a half-million rows.
We are using this to generate a pipe-delimited flatfile, by using bcp to
generate the file. Speed of generation is of the essence, as this is a
time critical batch process.
I need to do two things:
1. Apply a "where" type clause to the bcp to selectively generate
multiple files from the data
2. sort the data in the output file, using bcp (unless there's a better
method).
I've already tried to apply a sort to the view, but Sybase doesn't let
you do that. And I have no idea how to apply where clauses or sorting
to a bcp out.
Any help would be appreciated.
Thanks,
-Jeff
--
D&IS Manager Phone: (416) 979-0050 x2006
Image Impression Inc. Web: www.image-impression.com