· Jan 23, 2023

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
Discussion (4)2
Log in or sign up to continue