Question
Andy Stobirski · Mar 15, 2022

How to use LOAD DATA

How do I use the LOAD DATA command as described here.

I have the following LOAD DATA statement:

LOAD DATA FROM FILE 'E://Temp/Values.txt'

into PARIS.UAGU_MNDOOUT1 (AHSU_ID, AHSU_UAG_ID)

Where do I run it? It doesn't work in the SQL Gateway, in the terminal, in an embedded SQL command.

What am I missing?

Product version: IRIS 2020.1
$ZV: IRIS for Windows (x86-64) 2020.1 (Build 215U) Mon Mar 30 2020 20:14:33 EDT
0
0 202
Discussion (2)1
Log in or sign up to continue

LOAD DATA was released with IRIS 2021.2 and was unknown before
Your version is 2020.1  only.
Sorry

Aha - that makes a lot of sense! Why didn't I see that! blush

Thanks for taking the time to answer!