Written by

Senior Software Engineer
MOD
Question Ashok Kumar T · May 13, 2024

SQL LOAD DATA ISSUES

Hello Community,

I'm trying to load a file by execute this LOAD DATA SQL command in both studio and SQL-SMP I got the below error.

///sample executed queriesClassMethod ExecutedQueries()
{
    /// executed queries - 1
 LOAD DATA FROM FILE 'C:\\FHIRFILE\mycont.csv' COLUMNS ( C_COUNTRY VARCHAR ( 40 ) , C_CODE VARCHAR ( 20 ) ) INTO SAMPLE . COUNTRIES ( COUNTRY , CODE ) VALUES ( C_COUNTRY , C_CODE )
    /// executed queries - 2
LOAD DATA FROM FILE 'C:\FHIRFILE\mycont.csv' INTO SAMPLE . COUNTRIES ( COUNTRY , CODE )
    
}

sample data

$ZV: IRIS for Windows (x86-64) 2024.1 (Build 263) Wed Mar 13 2024 16:01:00 EDT

Comments

Enrico Parisi · May 13, 2024

In order to use LOAD DATA you need to check that the Java external language gateway is properly configured and working.

0
Robert Cemper · May 13, 2024

LOAD DATA requires activation of JavaGateway.

>> active in docker community version by default

0
Ashok Kumar T  May 13, 2024 to Robert Cemper

Thanks @Robert

It's working after enabled the %JavaServer in external language. 

0