MLOAD

Database

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
N/A

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

Re: MLOAD

Thank You