Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Hi All,
I have a select statement which acts a little weird. It is a select into a cursor like this one:
Select A.RecID, B.Date
From TableA A
Join TableB B on A.RecID = B.RecID
Group By A.RecID
Order By A.RecID
Into Cursor tmpCur
I excecute this statement different sets of data. Every set is bigger than the one before. This statement gives me a cursor with the name tmpCur until the set of data makes the select take about 110 seconds. At this point the select stil works but the resultset is called something like GC4SBG4Q. If I make this statement into a View like this:
CREATE SQL VIEW tmpCur AS ;
Select A.RecID, B.Date
From TableA A
Join TableB B on A.RecID = B.RecID
Group By A.RecID
Order By A.RecID
And perform the same tests by executing Use tmpCur on the different sets of data the result is the same. If the select takes over 110 seconds the resulting cursor isn't called tmpCur but something like GC4SBG4Q again.
This looks like some time out problem, but the select still work fine. What could this be??
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement