테라스트림(TeraStream)에서 테이블 정보확인 TERA_UNLOAD_INFO
TERA_UNLOAD_INFOselect 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..
2015. 5. 21.
테라스트림(TeraStream)에서 테이블 정보확인 TERA_LOAD_INFO
TERA_LOAD_INFOselect 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_fi..
2015. 5. 21.