MLOAD

Database
Enthusiast

MLOAD

I would like to know if in a MLOAD script we can do the following in a single script

1. Create a table
2. Load the table from a file.
3. From that table have to insert to another table.
4. The above insert is done if records not present , if present then a update is done.

The above four steps can it be written in a single MLOAD script.
2 REPLIES
Enthusiast

Re: MLOAD

Hi,

The answers to your questions

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.

Regards,
Novice
Enthusiast

Re: MLOAD

Thank You