Can we execute .SQL commands on MAPDQL client?


#1

I have stored the sql commands to create multiple tables and import data into those tables in a single .SQL file. Is there a way by which I can just execute this SQL file using MapDQL client?


#2

Hi

You can use regular < redirection to mapdql eg:

<MapDHome>/bin/mapdql -p password db -u user < myscript.sql

regards