Posted to tcl by yeeling at Wed Jul 25 16:53:46 GMT 2007view raw
- Data file: treatmentreply_845.info
- 00001 ,01-Jan-2001,3, , , ,25-Jul-2007,0,han,han
- ctl file: treatmentreply_845.ctl
- LOAD DATA
- INFILE './datfile/treatmentreply_845.info' BADFILE './datfile/treatmentreply_845.bad' DISCARDFILE './datfile/treatmentreply_845.dis'
- INSERT
- INTO TABLE cnc.treatment
- (
- studyid POSITION (1:10),
- tformdate POSITION (12:22),
- part_decno POSITION (24),
- medium_id POSITION (26),
- end_inmonths POSITION (28:29),
- contactdate POSITION (31:42),
- entrydate POSITION (44:55),
- sendmedium_yn POSITION (57))
- INTO TABLE cnc.participant
- (
- study_id POSITION (1:10),name POSITION(59:61), surname POSITION(63:65))
- Log file:
- SQL*Loader: Release 7.1.6.2.0 - Production on Wed Jul 25 17:44:51 2007
- Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.
- Control File: ./datfile/treatmentreply_845.ctl
- Data File: ./datfile/treatmentreply_845.info
- Bad File: ./datfile/treatmentreply_845.bad
- Discard File: ./datfile/treatmentreply_845.dis
- (Allow all discards)
- Number to load: ALL
- Number to skip: 0
- Errors allowed: 2000
- Bind array: 64 rows, maximum of 65536 bytes
- Continuation: none specified
- Path used: Conventional
- Silent options: FEEDBACK
- Table CNC.TREATMENT, loaded from every logical record.
- Insert option in effect for this table: INSERT
- Column Name Position Len Term Encl Datatype
- ------------------------------ ---------- ----- ---- ---- ---------------------
- STUDYID 1:10 10 CHARACTER
- TFORMDATE 12:22 11 CHARACTER
- PART_DECNO 24 1 CHARACTER
- MEDIUM_ID 26 1 CHARACTER
- END_INMONTHS 28:29 2 CHARACTER
- CONTACTDATE 31:42 12 CHARACTER
- ENTRYDATE 44:55 12 CHARACTER
- SENDMEDIUM_YN 57 1 CHARACTER
- Table CNC.PARTICIPANT, loaded from every logical record.
- Insert option in effect for this table: INSERT
- Column Name Position Len Term Encl Datatype
- ------------------------------ ---------- ----- ---- ---- ---------------------
- STUDY_ID 1:10 10 CHARACTER
- NAME 59:61 3 CHARACTER
- SURNAME 63:65 3 CHARACTER
- Record 1: Rejected - Error on table CNC.TREATMENT, column CONTACTDATE.
- ORA-01858: a non-numeric character was found where a numeric was expected
- Table CNC.TREATMENT:
- 0 Rows successfully loaded.
- 1 Row not loaded due to data errors.
- 0 Rows not loaded because all WHEN clauses were failed.
- 0 Rows not loaded because all fields were null.
- Table CNC.PARTICIPANT:
- 0 Rows successfully loaded.
- 1 Row not loaded due to data errors.
- 0 Rows not loaded because all WHEN clauses were failed.
- 0 Rows not loaded because all fields were null.
- Space allocated for bind array: 6656 bytes(64 rows)
- Space allocated for memory besides bind array: 83496 bytes
- Total logical records skipped: 0
- Total logical records read: 1
- Total logical records rejected: 1
- Total logical records discarded: 0
- Run began on Wed Jul 25 17:44:51 2007
- Run ended on Wed Jul 25 17:44:51 2007
- Elapsed time was: 00:00:00.38
- CPU time was: 00:00:00.01