home *** CD-ROM | disk | FTP | other *** search
/ Liren Large Software Subsidy 5 / 05.iso / a / a523 / 3.ddi / CASE1.CTL < prev    next >
Encoding:
Text File  |  1987-08-13  |  277 b   |  14 lines
  1. LOAD DATA
  2. INFILE *
  3. INTO TABLE DEPT
  4. FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
  5. (DEPTNO, DNAME, LOC)
  6. BEGINDATA
  7. 12,RESEARCH,"SARATOGA"
  8. 10,"ACCOUNTING",CLEVELAND
  9. 11,"ART",SALEM
  10. 13,FINANCE,"BOSTON"
  11. 21,"SALES",PHILA.
  12. 22,"SALES",ROCHESTER
  13. 42,"INT'L","SAN FRAN"
  14.