New post
Question
· Mar 16, 2023

LOAD DATA does not insert all rows and leaves no message for failed rows

#JDBC #ODBC #SQL #InterSystems IRIS #InterSystems IRIS for Health

Hi all,

I'm trying to use LOAD DATA to insert 11k (11,377) rows of data. LOAD BULK DATA is not available for the version of IRIS I am using.

After calling LOAD DATA it says only 5,500 rows has been inserted. The LOAD DATA docs says any error rows are skipped and a count of skipped rows can be found in %SQL_Diag.Result however there are no results here. There are no errors in the xDBC error log either.

Why have over half the rows been skipped?

Product version: IRIS 2022.1
$ZV: IRIS for Windows (x86-64) 2022.1.2 (Build 574_0_22261) Tue Mar 7 2023 13:10:17 EST
Discussion (3)3
Log in or sign up to continue
Dmitry Maslennikov · Mar 17, 2023

I’m not a fun of using LOAD DATA, it’s not complete, there are some things required to be kept in mind.

now I would recommend to look at dbt tool, which has support for IRIS, and may probably support older versions too, and it works with CSV quite easy, and can create table for you as well. Have a look, and let me know if you have any issues with it. I can fix bugs in IRIS support, if you find any. For IRIS you would need use dbt-iris package 

0 0