Home » RDBMS Server » Server Utilities » Delimited file load - URGENT
Delimited file load - URGENT [message #70434] Thu, 13 June 2002 06:35 Go to next message
Anush
Messages: 1
Registered: June 2002
Junior Member
Hi,
I have the following questions on loading a table with data from a comma delimited file.
ex.
Table:
col1,
col2,
col3,
col4,
col5

Data:
1,2,3,4,5
2,3,4,5,6

Here is the mapping:
col1 -> sequence no (generated)
col2->field1
col3-> field2 or substr(field3,10,8) depending on the value of field1
col4 -> sysdate
col5 -> field4

Can anyone please give me the code to the control file.
Well, I'm used to fixed lenght files where I can map to any field by position, I have no idea how this can be done in delimited file.

Thanks in advance.

Report message to a moderator

Re: Delimited file load - URGENT [message #70436 is a reply to message #70434] Thu, 13 June 2002 12:22 Go to previous message
AL
Messages: 24
Registered: October 2000
Junior Member
load data
infile '/path/xxx.dat'
append
into table x
(SEA_INT_ORG_ID POSITION(01:02),
CONV_AFFILIATE_ID CONSTANT 0 )

Report message to a moderator

Previous Topic: Re: OCP Exam Papers
Next Topic: How to define date format such as 2002-6-14 12:30:44?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Apr 29 04:54:53 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.