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!

Answer 1

This worked for me.

import os

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