Changes between Version 1 and Version 2 of CookBook join BDMAP_CCM


Ignore:
Timestamp:
Feb 9, 2010 8:43:55 PM (15 years ago)
Author:
cedric
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • CookBook join BDMAP_CCM

    v1 v2  
    22 
    331- Load the BDMAP database, it will be saved by Laurent using a Talend work 
     42- load the codier_csp table (it is also necessary for R treatments),the following code will create the table and copy it from the csv file (here located in base) 
    45 
     6{{{ 
     7create schema csp; 
     8drop table if exists csp.codier; 
     9create table csp.codier ("cd_id" integer, 
     10 
     11    "cd_fc_id" integer, 
     12    "cd_code" varchar(30), 
     13    "cd_libc" varchar(30), 
     14    "cd_libl" text, 
     15    "cd_chaine1" varchar(60), 
     16    "cd_chaine2" varchar(30), 
     17    "cd_num1" integer, 
     18    "cd_num2" integer, 
     19    "cd_date1" timestamp, 
     20    "cd_date2" timestamp, 
     21    "cd_dt_cre"timestamp, 
     22    "cd_dt_maj" timestamp, 
     23    "cd_qi_maj" varchar(20), 
     24    CONSTRAINT c_pk_cd_id PRIMARY KEY (cd_id) 
     25    ); 
     26 
     27copy csp.codier from 'c:/base/BDMAP_CODIER.csv' 
     28WITH DELIMITER ';' 
     29    CSV HEADER ; 
     30}}} 
     31[[file(ticket:20:BDMAP_CODIER.csv)]]