SQLLoad When Condition
From: <markjoh_at_my-deja.com>
Date: Tue, 11 Jan 2000 16:58:13 GMT
Message-ID: <85fnes$bfe$1_at_nnrp1.deja.com>
[Quoted] I have a 1Gig data file I am loading data from. I want to load only the records where the data in position 1435 is a 1. This field is not one of the fields in the table I am loading. Can I do a "When" condition on a piece of data that I am not loading to the table? If so could anyone give me the syntax for the WHEN clause in the control file?
Date: Tue, 11 Jan 2000 16:58:13 GMT
Message-ID: <85fnes$bfe$1_at_nnrp1.deja.com>
[Quoted] I have a 1Gig data file I am loading data from. I want to load only the records where the data in position 1435 is a 1. This field is not one of the fields in the table I am loading. Can I do a "When" condition on a piece of data that I am not loading to the table? If so could anyone give me the syntax for the WHEN clause in the control file?
Thanks for the help!
Mark
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Tue Jan 11 2000 - 17:58:13 CET