How to run a SQL script in Intersystems Cache?

Question

I have a script in a file (mysqlscript.sql) that is basically a bunch of inserts/updates/deletes separated by GO statements

insert into ....
GO
update .....
GO

How do I run this script?

Be careful about differences between SQL dialects. You can encounter some problems even if you find out how to run the script. — Vlasec, Jul 08 '13 at 10:00

score 1 · Accepted Answer · answered Jul 04 '13 at 04:42

1

You can try to use $system.SQL.ImportDir()
And of course, you can read your file and execute each sql-query in your programm.

answered Jul 04 '13 at 04:42

DAiMor

score 0 · Answer 2 · answered Oct 29 '13 at 07:23

0

The tool Caché Monitor use GO as statement separator and connects to InterSystems Caché. With this tool you can execute your script.

answered Oct 29 '13 at 07:23

Andreas

2 Answers2