sqlload question

From: Larry Claman <claman_at_copley.csc.mckinsey.com>
Date: Wed, 31 Mar 1993 00:50:59 GMT
Message-ID: <C4qAD0.B2x_at_copley.csc.mckinsey.com>


Hello. Can anyone help me me with the following sqlload problem: I have file that is comma delimited. I only want to load (for example) fields 1 and 3 into my oracle table. Is there an sqlload .ctl syntax that will let me skip field 2? Or am I stuck "awking" the file?

For example, suppose my file is:
name, city, state

and my oracle table is:
name_column char(10), state_column char(2)

How do create a .ctl file to load name and state into name_column and state_column, without loading city?

Thanks for your help!

	-Larry Claman
	 claman_at_copley.csc.mckinsey.com
Received on Wed Mar 31 1993 - 02:50:59 CEST

Original text of this message