Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
Selects in union run only one time
From: Matteo Gattoni (matteo.gattoniicteam.it)
Date: Mon Jul 05 2004 - 09:21:01 CDT
I have problem with a query that contains 11 select in union.
The first time that I run it, all works well.
The second time it fails with error
General error;-602 POS(1) System error: AK Catalog information not found:FF0000220146002000B200.
The query is a little complicated with about 5 joins for each select in it.
It seems to have problem with cache, isn't it?
Is there some parameter settings tha could resolve my problem?
Or it's due to other matters?