테라스트림(TeraStream)에서 테이블 정보확인 TERA_LOAD_INFO

TERA_LOAD_INFO

select a.prj_grp_id

     , a.nm as prj_name

     , b.log_file as ctl_log_file

     , b.bad_file as ctl_bad_file

     , b.data_file as ctl_data_file

     , b.load_type_cd as ctl_load_type_cd -- 1:APPEND,2:TRUNCATE

     , c.nm as ffd_name

     , c.table_nm as ffd_table_nm

     , c.sfiller1 as path_ffd

     , d.nm as ffd_col_name

     , d.col_data_type_cd

     , d.col_sep

     , d.col_loc

     , d.col_size

     , d.prec

     , d.table_field_type

     , d.table_field_name

     , d.table_precision

     , d.table_scale

     , d.table_PK_nullability -- 0:nullable,2:pk,1:not null

  from prj a

     , loading2 b

     , global_ffd c

     , global_ffd_dtl d

 where 1=1

   and a.prj_id = b.prj_id

   and a.cur_ver_id = b.prj_ver_id

   and b.ffd_id = c.ffd_id

   and c.ffd_id = d.ffd_id

   and a.prj_grp_id in (100,101,103,105,106,109,110)

-- prj_grp_id 는 프로젝트마다 틀리니 해당 프로젝트의 prj_grp_id 를 확인하자