Hi ,  I set up the environment variables including the Java_ home and class path but still its showing the above error.

Thanks

I tried to use the Save To command but I am getting an error as shown in the screen shot attached. Could you

please tell me how to solve this error.

Appreciate if anyone can give any advise. 

Thanks

This is the way how I use to_char in sql statement

TO_CHAR(58105,'DDMMYYYY')

I am extracting the data to excel file and I can see the column is assigned as a General and not a number. does it make any difference ?

Thanks

Hi Ben, This is not working fully. I mean to say MM is displaying with 0 but DD is not displaying with 0.

For instance, it displays as 1082000 and it should be 01082000.

Thanks

Jude

Please find the ODBC error below.

2023-07-24 02:05:48 [SQLCODE: <-400>:<Fatal error occurred>] [Error: <<READ>ServerLoop+18^%SYS.DBSRV>] [Location: <ServerLoop>] [Client info: <Username: , Node Name:  IP Address: , Executable Name: , Internal Function: DQ>] [%protocol: <57>] $Id: //adhocs-iris/2020.1.0.215.0/TRAKCARE_001/kernel/common/src/aclass.c#1 $ 24006 0

.

Hi @Luis Angel Pérez Ramos 
                                             , I tried that option but still It got failed.

Any other advise ?

Thanks

Hi @Robert Cemper ,
They are running the queries in a serial mode , ie one after the other. They are using this to load data into SSIS database. But once they reach some of the tables , it will show this error.  This is running fine for 150 tables but the error is showing only for 10 tables.

Hi @Luis Angel Pérez Ramos 
                                             , I tried that option but still It got failed.

Any other advise ?

Thanks

Still the issue exist . Can anyone advise how to fix the issue.

Still the issue exist .Its not pool connection issue.

Hi, Where we can check the amount of connection ? Is it something like a sql timeout ?

Is there any place to give access ?

Thanks for your help.

Could you please check what I did is correct ?

thanks

Which format do you want ? 

Thanks Alex & Muhammad.

Yes. Since it’s a long query , I don’t have an option to include a sub query. 

Thanks

Extract data from cache db. Need to run the sql query.

I am looking something similar like that but based on a particular table column data.

thanks