SQL Query getting timeout in management portal
Hi All,
I am a beginner in cache. I need to extract data from multiple tables (4-5) tables based on an SQL query . The data is more than 9 lakhs of records (i checked using count). The total number columns is 16.
When I am running this SQL query through management portal, I am getting time out exception. Could you please suggest how I can retrieve those records. Which way will be good (Dynamic query using %SQL.Statement or Embedded SQL (not known to me) or Writing to a global will help or not).
I tried using CSV but there are few columns that contain comma and because of which I cannot use CSV file.
In last I need to take output in an excel
Thanks in advance!!
Comments
In Caché, as an alternative to Portal, you can use Terminal and run:
SAMPLES>do $SYSTEM.SQL.Shell()
SQL Command Line Shell
----------------------------------------------------
Or the %SQL.Statement
Or try an external tool like dbeaver (https://dbeaver.io/)
In IRIS you have in SMP the option to run your Query in background and bypass the timeout.
How do you do that?
I didn't find an option for this but the release note says that as of 2019.3 IRIS queries run in the background.