>The back end is some proprietary database. It's basically an unknown since we know almost nothing about it and have very little documentation on it. The database is for a product called Global Shop. They claim it is some sort of COBOL database?
>

Hi Don,

Is the back end proprietary database DB/C by any chance, using the FS3 ODBC driver? I ask because we're currently working on a project with this dinosaur back end (sequential index reads, flat files, Databus language)...uggh. :)

Did you come up with any performance tips regarding your queries? We've decided to just pull down the tables locally each night and then run our queries. Even so, pulling down the data can take quite a while for the eight or so tables we need.

Thanks,
Clay