InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comWed, 03 Dec 2008 20:05:58 GMT20http://www.teradata.com/teradataforum/Topic7520-1-1.aspxHi,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.Thu, 13 Mar 2008 04:54:13 GMTdhirajpalsehttp://www.teradata.com/teradataforum/Topic7520-1-1.aspxYes, 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.Fri, 18 May 2007 15:41:43 GMTRao gahntahttp://www.teradata.com/teradataforum/Topic7520-1-1.aspxNo, 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.Fri, 18 May 2007 15:26:28 GMTJim Chapmanhttp://www.teradata.com/teradataforum/Topic7520-1-1.aspxCan 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.Fri, 18 May 2007 15:15:02 GMTRao gahnta