How to Import Table using Exported .txt file.

Question

Question

Harshdeep Acharya · Jan 17, 2023

#InterSystems IRIS #InterSystems IRIS for Health

Hi Team,

Can You please provide the solution of my problem ASAP as below :

How can I import the table using InterSystems Command Line from Terminal based on exported tablename.txt file?

Please provide the command if available.

Note : As I am not able to Login into Management Portal.

Thanks,

Harshdeep Acharya

Product version: IRIS 2021.2

Discussion (3)1

Log in or sign up to continue

score 0 · Answer 1 · 2023-01-17T11:50:48-05:00

from the command line you may start SQL shell > DO $SYSTEM.SQL.Shell()
and then use LOAD DATA as described here LOAD DATA

score 0 · Answer 2 · 2023-01-18T04:18:07-05:00

Hello Robert,

Thanks for the reply.

I am following your provided solution But, It is throwing an error as below:

ERROR #5007: Directory name 'D:\Intersystem\IRISHealth\Mgr\DATA FROM FILE 'D:\Intersystem\IRISHealth\Mgr\' is invalid
Statement file invalid or empty.

Please advise.

Thanks,

Harshdeep Acharya

score 0 · Answer 3 · 2023-01-18T06:34:57-05:00

You should really read the docs in detail

LOAD DATA ......<filename>
'D:\Intersystem\IRISHealth\Mgr\' is just a directory, not a file
and you need all access rights
I would expect something like 'D:\Intersystem\IRISHealth\Mgr\tablename.txt'

Did you use $system.SQL.Shell() to launch it ?