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?
You can use regular
< redirection to
<MapDHome>/bin/mapdql -p password db -u user < myscript.sql