New post
Question
Harshdeep Acharya · Jan 17

How to Import Table using Exported .txt file.

#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
0
0 93
Discussion (3)1
Log in or sign up to continue
Robert Cemper · Jan 17

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

0 0
Harshdeep Acharya · Jan 18

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

0 0
Robert Cemper · Jan 18

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 ?

0 0