| Batch/Control File hangs [message #368195] |
Thu, 28 September 2000 07:12  |
Pam Nicanor
Messages: 2
Registered: September 2000
|
Junior Member |
|
|
When i run the script below the screen says "Load completed - logical record count 5" and it just hangs. It successfully inserts the data into the specified table but I have to press CTL+Break and type Y to terminate the batch job to be able to exit the SQLLDR. I'm just wondering if there's command to exit a batchfile or it automatically finishes loading the data. Or is it my control file that needs to be adjusted?
Here's my batchfile script.
@ECHO OFF
SET ORACLE_SID=MFPDTST
CD\ORANT\BIN
SQLLDR80 USERID=UAT_1/UAT_1@MFPDTST CONTROL=CTLFILE.CTL BAD=BADFILE.BAD LOG=LOGFILE.LOG DIRECT=TRUE
PLUS80 UAT_1/UAT_1@MFPDTST
And here's my control file script:
LOAD DATA
INFILE '\ORANT\BIN\TESTDATA.TXT'
BADFILE '\ORANT\BIN\BADFILE.BAD'
DISCARDFILE '\ORANT\BIN\DSCRDFILE.DSC'
TRUNCATE INTO TABLE TBL_LOAD
WHEN STUD_NO <> "*" AND STUD_NO <> "STUD_"
(stud_no POSITION(02:06) ,
stud_nm POSITION(08:23) ,
stud_dt POSITION(25:32) ,
stud_fee POSITION(35:45) ,
stud_ag POSITION(50:69) ,
stud_br POSITION(75:84),
stud_cd CONSTANT "PCD")
Here's a sample data:
62497 PAM NICANOR 19780131 1000.25 MICHAEL SCHUMACHER BELGIUM
Thanks in advance.
|
|
|
|
|
|
| Re: Batch/Control File hangs [message #368200 is a reply to message #368195] |
Thu, 28 September 2000 15:22  |
ulli
Messages: 24
Registered: September 1999
|
Junior Member |
|
|
Hi Pam,
what is the plus80 doing? The plus80 needs an 'exit' at the end of executing a script or the process will hung after finishing ( when executing in a batch ).
Regards Ulli
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
