Database toolbox query not returning all records
4 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
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 comentarios
Sean de Wolski
el 17 de Oct. de 2012
i.e.:
e1 = fetch(blah);
e2 = fetch(blah);
e3 = fetch(blah);
isequal(e1,e2,e3)
Respuestas (0)
Ver también
Categorías
Más información sobre Database Toolbox en Help Center y File Exchange.
Productos
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!