Re: SQLLoad When Condition
From: George Meltser <meltser_at_aigfpc.com>
Date: Tue, 11 Jan 2000 17:27:47 -0500
Message-ID: <S7Oe4.1109$v_3.3285_at_client>
Date: Tue, 11 Jan 2000 17:27:47 -0500
Message-ID: <S7Oe4.1109$v_3.3285_at_client>
you can use:
when (1435:1435) = X'1'
markjoh_at_my-deja.com wrote in message <85fnes$bfe$1_at_nnrp1.deja.com>...
>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 - 23:27:47 CET