New post
Question
Virat Sharma · Jan 23

SQL Query getting timeout in management portal

#Databases #SQL #Caché #InterSystems IRIS

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
1
0 124
Discussion (6)2
Log in or sign up to continue
Lucas Fernandes · Jan 23

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/)

2 0
Robert Cemper · Jan 23

In IRIS you have in SMP the option to run your Query in background and bypass the timeout.

3 0
Vic Sun · Jan 25

Ah good catch. I run EM releases so I hadn't seen this was out yet.

0 0