Control file [message #290465] |
Sat, 29 December 2007 01:21 |
vanathi
Messages: 74 Registered: December 2007 Location: India
|
Member |
|
|
Hi,
load data
append
into table PARTCORE3
fields terminated by "," OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS (
CONTACTCODE CHAR,
RELATIONSHIPTYPE CHAR,
PORTFOLIOCODE CHAR,
PROCESSED CONSTANT "N",
ID__ "db_seq_PART.nextval"
)
This control file's input is a csv.
Sample data is 1,zn7c001013-Owner,Owner,N7C001013.
I just need datas from the 2nd data. ie.zn7c001013-Owner.
I dont need that '1'.
Is it possible?...
Please advice.
|
|
|
|
|
|
Re: Control file [message #290493 is a reply to message #290490] |
Sat, 29 December 2007 02:40 |
vanathi
Messages: 74 Registered: December 2007 Location: India
|
Member |
|
|
load data
append
into table PARTCORE3
fields terminated by "," OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS (
Field FILLER,
CONTACTCODE CHAR,
RELATIONSHIPTYPE CHAR,
PORTFOLIOCODE CHAR,
PROCESSED CONSTANT "N",
ID__ "db_seq_PART.nextval"
)
Is this okay?...
[Updated on: Sat, 29 December 2007 02:41] Report message to a moderator
|
|
|
|
|