Database toolbox query not returning all records

I have a fairly simply SQL query that I am running using the database toolbox connecting to a DB2 datasource. For some reason my query returns different results (usually partial results) each time I run it. It never seems to time out or have any errors. When the query runs properly I get 400,000+ records. As I run the query testing the result, often times I will get 2000-5000 records or so. Seemingly no pattern to the random return of different results. Also, I tried setting the timeout of the SQL query to 100 seconds and that didn't seem to have any impact.
conn = database('Database','UN','pwd');
e = exec(conn,'SELECT ALL END_DT,NASDAQ_SYMBOL,LIPPER_CLASS FROM LIPPER.LIPPER_WEEKLY WHERE END_DT > ''2008-12-31'' AND LIPPER_CLASS IN (''MLCE'',''MTAG'',''MTAM'',''MTAC'') AND NASDAQ_SYMBOL <> '''' AND UNIVERSE = ''EQ'' ',100);
e = fetch(e);
I'm fairly puzzled here, any help would be appreciated.
Thanks, Brian

3 Kommentare

If you run the exact same query three times in a row, do you get different results each time?
i.e.:
e1 = fetch(blah);
e2 = fetch(blah);
e3 = fetch(blah);
isequal(e1,e2,e3)
Brian
Brian am 17 Okt. 2012
Yes I do, it seems almost completely random. One time I'll get 400000+ records, one time I'll get 5500 and the third time I'll get No Data.

Melden Sie sich an, um zu kommentieren.

Antworten (0)

Produkte

Gefragt:

am 17 Okt. 2012

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by