Differences

This shows you the differences between two versions of the page.

Link to this comparison view

integration:rawdata:delimited:example [2012/10/26 15:34]
127.0.0.1 external edit
integration:rawdata:delimited:example [2016/06/28 22:38] (current)
Line 40: Line 40:
 -> ; -> ;
 -> create table          "COUNTRIES" -> create table          "COUNTRIES"
->>  options              "DELMITED COLUMN=',' RECORD='\r\n' QUOTES"+>>  options              "DELIMITED COLUMN=',' RECORD='\r\n' QUOTES"
 >>  physical             "dat/countries.csv" >>  physical             "dat/countries.csv"
 >>  ( >>  (
Line 57: Line 57:
 -> ; -> ;
 -> create table          "STATES" -> create table          "STATES"
->>  options              "DELMITED COLUMN='\t' RECORD='\r\n' QUOTES"+>>  options              "DELIMITED COLUMN='\t' RECORD='\r\n' QUOTES"
 >>  physical             "dat/states.txt" >>  physical             "dat/states.txt"
 >>  ( >>  (
Line 74: Line 74:
 -> ; -> ;
 -> create table          "GENDERS" -> create table          "GENDERS"
->>  options              "DELMITED COLUMN='|' RECORD='\r\n' QUOTES"+>>  options              "DELIMITED COLUMN='|' RECORD='\r\n' QUOTES"
 >>  physical             "dat/genders.txt" >>  physical             "dat/genders.txt"
 >>  ( >>  (
 
Back to top
integration/rawdata/delimited/example.txt ยท Last modified: 2016/06/28 22:38 (external edit)
 
 
chimeric.de = chi`s home Valid CSS Driven by DokuWiki do yourself a favour and use a real browser - get firefox!! Recent changes RSS feed Valid XHTML 1.0