1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
| CREATE TABLE AGL_TICKET_ext ( TRT_ID NUMBER(22,0), TIC_ID NUMBER(22,0),
ATTR_TP VARCHAR2(20), SIT_CD VARCHAR2(4),
CAIS_CD VARCHAR2(3), TIC_CD VARCHAR2(20),
VTE_NO NUMBER(22,0), REF_DT DATE,
TIC_DT DATE, TIC_HEU VARCHAR2(8),
OPE_ID VARCHAR2(20), CLI_ID NUMBER(22,0),
PTS_NB NUMBER(22,0), POSTAL_CD VARCHAR2(5),
DIVERS VARCHAR2(255), SESSION_ID NUMBER(22,0),
CPT NUMBER(22,0), TIC_ORIG_NO VARCHAR2(20),
CPT_ORIG NUMBER(22,0), FISCAL_NO VARCHAR2(30),
UNITE_MON_PPALE VARCHAR2(4), GRP_CD VARCHAR2(2),
COMP_ST NUMBER(3,0)
)
ORGANIZATION EXTERNAL (TYPE ORACLE_LOADER
DEFAULT DIRECTORY DIRECTORY_OUT
ACCESS PARAMETERS ( RECORDS DELIMITED BY NEWLINE FIELDS LOAD WHEN (trt_id = 1527) TERMINATED BY ';' ENCLOSED BY '"'
( TRT_ID INTEGER EXTERNAL (22) , TIC_ID INTEGER EXTERNAL (22) ,
ATTR_TP CHAR , SIT_CD CHAR ,
CAIS_CD CHAR , TIC_CD CHAR ,
VTE_NO INTEGER EXTERNAL (22) ,
REF_DT CHAR(19) DATE_FORMAT DATE MASK "DD/MM/YYYY HH24:MI:SS" ,
TIC_DT CHAR(19) DATE_FORMAT DATE MASK "DD/MM/YYYY HH24:MI:SS" ,
TIC_HEU CHAR , OPE_ID CHAR , CLI_ID INTEGER EXTERNAL (22) ,
PTS_NB INTEGER EXTERNAL (22) , POSTAL_CD CHAR ,
DIVERS CHAR , SESSION_ID INTEGER EXTERNAL (22) ,
CPT INTEGER EXTERNAL (22) , TIC_ORIG_NO CHAR ,
CPT_ORIG INTEGER EXTERNAL (22) , FISCAL_NO CHAR ,
UNITE_MON_PPALE CHAR , GRP_CD CHAR ,
COMP_ST INTEGER EXTERNAL (22)
)) LOCATION ('CN1#AGL_TICKET#OUT#20110405#TICK_AGILGCE.dat')) REJECT LIMIT UNLIMITED; |
