Posted to tcl by yeeling at Wed Jul 25 16:53:46 GMT 2007view raw

  1. Data file: treatmentreply_845.info
  2. 00001 ,01-Jan-2001,3, , , ,25-Jul-2007,0,han,han
  3.  
  4. ctl file: treatmentreply_845.ctl
  5. LOAD DATA
  6. INFILE './datfile/treatmentreply_845.info' BADFILE './datfile/treatmentreply_845.bad' DISCARDFILE './datfile/treatmentreply_845.dis'
  7. INSERT
  8. INTO TABLE cnc.treatment
  9. (
  10. studyid POSITION (1:10),
  11. tformdate POSITION (12:22),
  12. part_decno POSITION (24),
  13. medium_id POSITION (26),
  14. end_inmonths POSITION (28:29),
  15. contactdate POSITION (31:42),
  16. entrydate POSITION (44:55),
  17. sendmedium_yn POSITION (57))
  18. INTO TABLE cnc.participant
  19. (
  20. study_id POSITION (1:10),name POSITION(59:61), surname POSITION(63:65))
  21.  
  22.  
  23. Log file:
  24. SQL*Loader: Release 7.1.6.2.0 - Production on Wed Jul 25 17:44:51 2007
  25.  
  26. Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.
  27.  
  28. Control File: ./datfile/treatmentreply_845.ctl
  29. Data File: ./datfile/treatmentreply_845.info
  30. Bad File: ./datfile/treatmentreply_845.bad
  31. Discard File: ./datfile/treatmentreply_845.dis
  32. (Allow all discards)
  33.  
  34. Number to load: ALL
  35. Number to skip: 0
  36. Errors allowed: 2000
  37. Bind array: 64 rows, maximum of 65536 bytes
  38. Continuation: none specified
  39. Path used: Conventional
  40. Silent options: FEEDBACK
  41.  
  42. Table CNC.TREATMENT, loaded from every logical record.
  43. Insert option in effect for this table: INSERT
  44.  
  45. Column Name Position Len Term Encl Datatype
  46. ------------------------------ ---------- ----- ---- ---- ---------------------
  47. STUDYID 1:10 10 CHARACTER
  48. TFORMDATE 12:22 11 CHARACTER
  49. PART_DECNO 24 1 CHARACTER
  50. MEDIUM_ID 26 1 CHARACTER
  51. END_INMONTHS 28:29 2 CHARACTER
  52. CONTACTDATE 31:42 12 CHARACTER
  53. ENTRYDATE 44:55 12 CHARACTER
  54. SENDMEDIUM_YN 57 1 CHARACTER
  55.  
  56. Table CNC.PARTICIPANT, loaded from every logical record.
  57. Insert option in effect for this table: INSERT
  58.  
  59. Column Name Position Len Term Encl Datatype
  60. ------------------------------ ---------- ----- ---- ---- ---------------------
  61. STUDY_ID 1:10 10 CHARACTER
  62. NAME 59:61 3 CHARACTER
  63. SURNAME 63:65 3 CHARACTER
  64.  
  65. Record 1: Rejected - Error on table CNC.TREATMENT, column CONTACTDATE.
  66. ORA-01858: a non-numeric character was found where a numeric was expected
  67.  
  68.  
  69. Table CNC.TREATMENT:
  70. 0 Rows successfully loaded.
  71. 1 Row not loaded due to data errors.
  72. 0 Rows not loaded because all WHEN clauses were failed.
  73. 0 Rows not loaded because all fields were null.
  74.  
  75.  
  76. Table CNC.PARTICIPANT:
  77. 0 Rows successfully loaded.
  78. 1 Row not loaded due to data errors.
  79. 0 Rows not loaded because all WHEN clauses were failed.
  80. 0 Rows not loaded because all fields were null.
  81.  
  82.  
  83. Space allocated for bind array: 6656 bytes(64 rows)
  84. Space allocated for memory besides bind array: 83496 bytes
  85.  
  86. Total logical records skipped: 0
  87. Total logical records read: 1
  88. Total logical records rejected: 1
  89. Total logical records discarded: 0
  90.  
  91. Run began on Wed Jul 25 17:44:51 2007
  92. Run ended on Wed Jul 25 17:44:51 2007
  93.  
  94. Elapsed time was: 00:00:00.38
  95. CPU time was: 00:00:00.01
  96.