Recent content by anotherProgrammer

Again, thanks for the suggestions and encouragement. The system resources exceeded happens regardless of how I download it (plain or not) - I think it is just too much data, period. Basically the management does not have a problem with the amount of time it takes to run these requests, so...

I appreciate all the suggestions that have been made so far. I have actually tried pulling the whole tables, because I agree that the lack of indexing is what kills it. However, whenever I try to download the whole table, I get a message "system resources exceeded". Even if I apply...

Thanks for the sympathy. I may try breaking it down as you suggest - the thought had crossed my mind but it seemed like too much trouble (though perhaps not more trouble than waiting 4 hours?)

Ok, nope, don't have to check for existence, these are all inner joins, and I have tried writing them that way too to see if it would be faster but it's not (well maybe in geologic time). The criteria are all really simple, like field 1 in ('A','B','C') and field 2 in (1,2,3), nothing the...

Not sure what you mean by frustrated join, but I don't actually have a join statement, it is just in the where clause, like SELECT myField FROM myTable1, myTable2 WHERE myTable1.Field=myTable2.field AND myTable.myField='B' Can't post actual SQL, I'm sure it would violate at least 57...

Yep good suggestions but I am very limited: Stringent corporate policy = no ability to control or access anything server side, don't even have access to speak to the IT folks that own the database. Also pretty crappy desktop hardware and Access 2002. Yep, really do need all 50,000 records...

I need to manipulate large db2 tables (1 to 10 million records). Example: Join three tables, get about 50,000 records based on one or two criteria from each table, put it in a local table. Right now I am using ODBC through access, but it is ridiculously slow. My attempts at using pass...