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.
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.
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.