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

TERA_UNLOAD_INFO

select a.prj_grp_id

     , a.nm as prj_name

     , c.nm as block_name

     , b.outfile1

     , b.type

     , b.delim

     , b.field5

     , d.nm as ffd_name

     , d.table_nm as ffd_table_nm

     , d.sfiller1 as path_ffd

     , e.nm as ffd_col_name

     , e.col_data_type_cd

     , e.col_sep

     , e.col_loc

     , e.col_size

     , e.prec

     , e.table_field_type

     , e.table_field_name

     , e.table_precision

     , e.table_scale

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

  from prj a

     , unload2 b

     , block c

     , global_ffd d

     , global_ffd_dtl e

 where 1=1

   and a.prj_id = b.prj_id

   and a.cur_ver_id = b.prj_ver_id

   and b.prj_id = c.prj_id

   and b.prj_ver_id = c.prj_ver_id

   and b.block_id = c.block_id

   and b.ffd_id = d.ffd_id

   and d.ffd_id = e.ffd_id

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