MloAD

UDA
Enthusiast

MloAD

Can i write a Select statement in Mload? IF not how do i assign a value from the table for Null value in the file. Thank you.
3 REPLIES
Enthusiast

Re: MloAD

No, MLOAD does not process select statements, nor does it allow subqueries in DML statements. To assign a value from a query, one method would be to execute an update statement in BTEQ. Use a correlated subquery in the update statement to select values to be applied to the target table.
Enthusiast

Re: MloAD

Yes, If i excute from BTEQ it will works fine. But my problem is I am receiving null value in the file, insted of loading null value i have to get that value from another table matching his ID and update the master table. I have update and insert statements existed in my load and currentlly it is loading null values into master table. Any help would be great. Thanx.
Enthusiast

Re: MloAD

Hi,

The best remedy as per my knowledge for this issue would be, Load the data from flat file into one staging table. Then using bteq ,we can compare the values as well as replace nulls with desired values.