Re: Typical Problem With HPL

When you define the mapping, leave the two fields alone and map only the four fields you have on the file. Make sure the other two columns can accept nulls, if not you may have to revert to a two stage process - load data into a staging table with four columns, then run an SQL INSERT statement that uses default non-null values for the two columns. Hope that helps, Arun T.Suresh Kumar wrote: > Hello > I have a situation like below. > I have a data dump in an ASCII file for a table with 4 fields. > But I want to load this data into a table that contains 6 > fields. > How can I do this thru High Performance Loader. > I need to send Default values to them thru HPL. How can I do > this ? > > Please give me reply ASAP. > > Wishes > Suresh