1. Create a table - Yes, Mload does support Create table statement to create new tables. 2. Load the table from a file - Yes 3. From that table have to insert to another table- No Mload utilty is to load files into table and not to load table to table( use Bteq utility to do this task) 4. The above insert is done if records not present , if present then a update is done - Yes, mload supports upsert statements.
The above four steps can it be written in a single MLOAD script.