Still its not working.

I think its because of looping. Since I am using the same field in the where condition , that may be the issue.

Any idea?

date is the datatype.

Around 10K data .

Error: [C:\Program Files (x86)\Synametrics Technologies\WinSQL\Winsql.exe]
[SQLCODE: <-105>:<Field validation failed in UPDATE>]
[Location: <ServerLoop>]
[%msg: <Field 'SQLUser.RB_ResEffDateSessPayorRestr.RESTR_DateTo' (value '2039-01-07 00:00:00') failed validation>] (State:S1000, Native Code: 69)
 

Many Thanks . It worked very well.

I used this one only

update RB_ResEffDateSessPayorRestr set RESTR_DATETo=to_date(DATEADD('year',1,RESTR_DATETo),'YYYY-MM-DD') where YEAR(RESTR_DATETo)=2020

Hi Eduard,

 I am writing a routine to extract data from database and scheduled for a particular day. Recently I came across that the data is going beyond the csv limit.

Thanks

Jude

Could you please send me a sample code.

Many thanks 

Hi,

       I need to write to different csv files based on a column data. So I need to check the column data before writing to file.

Here is the code to write the data to file.

while (ind '= ""){
set row = ^CacheTemp(repid,"MAIN",ind)
use filemain write row,!
; Get next row index for MAIN report
set ind = $order(^CacheTemp(repid,"MAIN",ind))
} close filemain
}

Thanks

Jude

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

thanks

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

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

Thanks

Which format do you want ? 

Could you please check what I did is correct ?

thanks

Still the issue exist .Its not pool connection issue.

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

.

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

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

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.

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

Thanks