aers

demo.clt

データファイルとインポート対象となるテーブルの値を変更します

load data
infile            demo13Q1.txt
into table        demo13Q1
FIELDS TERMINATED BY "$" OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS
( PRIMARYID,
  CASEID,
  CASEVERSION,
  I_F_CODE          CHAR NULLIF                I_F_CODE=BLANKS,
  EVENT_DT          CHAR NULLIF                EVENT_DT=BLANKS,
  MFR_DT            CHAR NULLIF                MFR_DT=BLANKS,
  INIT_FDA_DT       DATE "YYYYMMDD"  NULLIF    INIT_FDA_DT=BLANKS,
  FDA_DT            DATE "YYYYMMDD"  NULLIF    FDA_DT=BLANKS,
  REPT_COD          CHAR NULLIF                REPT_COD=BLANKS,
  MFR_NUM           CHAR NULLIF                MFR_NUM=BLANKS,
  MFR_SNDR          CHAR NULLIF                MFR_SNDR=BLANKS,
  AGE               CHAR NULLIF                AGE=BLANKS,
  AGE_COD           CHAR NULLIF                AGE_COD=BLANKS,
  GNDR_COD          CHAR NULLIF                GNDR_COD=BLANKS,
  E_SUB             CHAR NULLIF                E_SUB=BLANKS,
  WT                CHAR NULLIF                WT=BLANKS,
  WT_COD            CHAR NULLIF                WT_COD=BLANKS,
  REPT_DT           CHAR NULLIF                REPT_DT=BLANKS,
  TO_MFR            CHAR NULLIF                TO_MFR=BLANKS,
  OCCP_COD          CHAR NULLIF                OCCP_COD=BLANKS,
  REPORTER_COUNTRY  CHAR NULLIF                REPORTER_COUNTRY=BLANKS,
  OCCR_COUNTRY      CHAR NULLIF                OCCR_COUNTRY=BLANKS
)

drug.ctl

load data
infile     drug13Q1.txt
into table drug13Q1
FIELDS TERMINATED BY "$" OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS
( PRIMARYID,
  CASEID,
  DRUG_SEQ,
  ROLE_COD	CHAR       NULLIF ROLE_COD=BLANKS,
  DRUGNAME	CHAR(1024) NULLIF DRUGNAME=BLANKS,
  VAL_VBM	CHAR       NULLIF VAL_VBM=BLANKS,
  ROUTE		CHAR	   NULLIF ROUTE=BLANKS,
  DOSE_VBM	CHAR(300)  NULLIF DOSE_VBM=BLANKS,
  CUM_DOSE_CHR  DECIMAL EXTERNAL NULLIF CUM_DOSE_CHR=BLANKS,
  CUM_DOSE_UNIT CHAR       NULLIF CUM_DOSE_UNIT=BLANKS,
  DECHAL	CHAR	   NULLIF DECHAL=BLANKS,
  RECHAL	CHAR	   NULLIF RECHAL=BLANKS,
  LOT_NUM       CHAR(1024) NULLIF LOT_NUM=BLANKS,
  EXP_DT        CHAR       NULLIF EXP_DT=BLANKS,
  NDA_NUM       CHAR       NULLIF NDA_NUM=BLANKS,
  DOSE_AMT      CHAR       NULLIF DOSE_AMT=BLANKS,
  DOSE_UNIT     CHAR       NULLIF DOSE_UNIT=BLANKS,
  DOSE_FORM     CHAR       NULLIF DOSE_FORM=BLANKS,
  DOSE_FREQ     CHAR       NULLIF DOSE_FREQ=BLANKS
)

indi.ctl

基本小文字でINDI_PTを登録します

load data
infile     indi13Q1.txt
into table indi13Q1
FIELDS TERMINATED BY "$" TRAILING NULLCOLS
( PRIMARYID,
  CASEID,
  INDI_DRUG_SEQ,
  INDI_PT         CHAR "LOWER(:INDI_PT)"
)

outc.ctl

load data
infile     outc13Q1.txt
into table outc13Q1
FIELDS TERMINATED BY "$"
( PRIMARYID,
  CASEID,
  OUTC_CODE
)

reac.ctl

基本小文字でPTを登録します

load data
infile     reac13Q1.txt
into table reac13Q1
FIELDS TERMINATED BY "$" TRAILING NULLCOLS
( PRIMARYID,
  CASEID,
  PT	        CHAR "LOWER(:PT)"
)

rpsr.ctl

load data
infile     rpsr13Q1.txt
into table rpsr13Q1
FIELDS TERMINATED BY "$"
( PRIMARYID,
  CASEID,
  RPSR_COD
)

ther.ctl

load data
infile     ther13Q1.txt
into table ther13Q1
FIELDS TERMINATED BY "$" TRAILING NULLCOLS
( PRIMARYID,
  CASEID,
  DSG_DRUG_SEQ,
  START_DT  CHAR NULLIF START_DT=BLANKS,
  END_DT    CHAR NULLIF END_DT=BLANKS,
  DUR       DECIMAL EXTERNAL NULLIF DUR=BLANKS,
  DUR_COD   CHAR NULLIF DUR_COD=BLANKS
)

トップ   編集 添付 複製 名前変更     ヘルプ   最終更新のRSS
Last-modified: 2014-09-04 (木) 11:54:00 (2417d)