Regarding Sqlldr

[ancys]

Posts: 3


Regarding Sqlldr
« on: Today at 05:49:45 am » Quote Modify Remove

--------------------------------------------------------------------------------
hi all

I need to read the text file and update into database

Text file samp.txt
1#arun
2#aparna

Table -Employee
Emp empname
Script
#!bin/sh
sqlldr username/password@database control=control.ctl

control.cl
load data infile 'sample.txt' into table employee fields terminated bu '#' trailing nullcols(emp.empname)

The above statements get executed
but i dont want control file to be as separate file

I want it to be part of the script
#!bin/sh
sqlldr username/password@database control=load data infile 'sample.txt' into table employee fields terminated bu '#' trailing nullcols(emp.empname)

I shows an error unexpected end of file
How to solve this

[g33k]

try to add one [enter](I mean new line before EOF). Some say there's unexpected EOF when you have

code
code
codeEOF

but
code
code
code
EOF

is OK.

[ancys]

after includng EOF after the qlldr code also it shows be some error

How to make a control file to be a part of the script

[g33k]

well can you post here what is the error message you get.

Can you of course post actual script you are trying to debug?