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!!
Product version: Caché 2018.1
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.
https://docs.intersystems.com/irisforhealth20222/csp/docbook/DocBook.UI.Page.cls?KEY=HXIHRN_new20201#HXIHRN_new20201_sql
see this posting
https://community.intersystems.com/post/system-process-and-session-information-triggers#comment-212291
docs:
https://docs.intersystems.com/iris20223/csp/docbook/DocBook.UI.Page.cls?KEY=GSQL_smp#GSQL_smp_executequeryopts
Ah good catch. I run EM releases so I hadn't seen this was out yet.
Social networks
InterSystems resources
Log in or sign up
Log in or create a new account to continue
Log in or sign up
Log in or create a new account to continue
Log in or sign up
Log in or create a new account to continue