Run a Teradata MLOAD command in Windows command prompt, but use Python to trigger it

Question

I used to execute the MLOAD process by opening a command prompt and then typing MLOAD < MLOAD_FILE.txt. How do I do it using Python?

Assume that the MLOAD_FILE.txt is under directory C:\\Users\\MLOAD_FILES.

Thanks!

Possible duplicate of [Calling an external command in Python](http://stackoverflow.com/questions/89228/calling-an-external-command-in-python) — Martin Tournoij, Jan 07 '17 at 14:06

Prayson W. Daniel · Answer 1 · 2017-08-03T08:14:16.563

0

This worked for me.

import os

os.system("MLOAD < 'C:\\Users\\MLOAD_FILES.txt'")

edited Aug 03 '17 at 08:14

answered Apr 19 '17 at 11:26

Prayson W. Daniel

1 Answers1