Written by

Senior Developer at Greater Manchester Mental Health Services
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

Comments

Robert Cemper · Mar 15, 2022

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

0
Andy Stobirski  Mar 15, 2022 to Robert Cemper

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

Thanks for taking the time to answer!

0