Home » RDBMS Server » Server Utilities » Batch/Control File hangs
Batch/Control File hangs [message #368195] Thu, 28 September 2000 07:12 Go to next message
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 #368197 is a reply to message #368195] Thu, 28 September 2000 09:00 Go to previous messageGo to next message
Lee
Messages: 56
Registered: May 1999
Member
Try writing "exit" in the batch file after the loader command
Re: Batch/Control File hangs [message #368200 is a reply to message #368195] Thu, 28 September 2000 15:22 Go to previous message
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
Previous Topic: importing data from flatfile or xml
Next Topic: Datawarehouse database requirements
Goto Forum:
  


Current Time: Fri Mar 29 06:33:18 CDT 2024