home *** CD-ROM | disk | FTP | other *** search
/ Liren Large Software Subsidy 5 / 05.iso / a / a524 / 39.ddi / demo / case1.ctl < prev    next >
Encoding:
Text File  |  1991-03-04  |  347 b   |  17 lines
  1. -- 
  2. -- $Header: case1.ctl,v 10010.5 88/01/14 14:40:01 hdai Exp $ case1.ctl 
  3. -- 
  4. LOAD DATA
  5. INFILE * 
  6. INTO TABLE DEPT    
  7. FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
  8. (DEPTNO, DNAME, LOC)
  9. BEGINDATA
  10. 12,RESEARCH,"SARATOGA"     
  11. 10,"ACCOUNTING",CLEVELAND
  12. 11,"ART",SALEM
  13. 13,FINANCE,"BOSTON"
  14. 21,"SALES",PHILA.
  15. 22,"SALES",ROCHESTER
  16. 42,"INT'L","SAN FRAN"
  17.