Hello All,
I am extracting a part of file. the file looks as follows
USING CHARACTER SET UTF8 DEFINE JOB
(
DEFINE SCHEMA Flat_File_Schema
(
cntnt_id VARCHAR(10)
);
DEFINE OPERATOR o_mload
TYPE update
SCHEMA *
ATTRIBUTES
(
VARCHAR TdpId = @TdpId
);
DEFINE OPERATOR o_tpump
TYPE stream
SCHEMA *
ATTRIBUTES
(
VARCHAR TdpId = @TdpId
);
DEFINE OPERATOR o_bteq
TYPE inserter
SCHEMA *
ATTRIBUTES
(
VARCHAR TdpId = @TdpId
);
DEFINE OPERATOR o_fastload
TYPE load
SCHEMA *
ATTRIBUTES
(
VARCHAR TdpId = @TdpId
,VARCHAR UserName = @UserName
);
DEFINE OPERATOR Read_Operator
TYPE DATACONNECTOR PRODUCER
SCHEMA Flat_File_Schema
ATTRIBUTES
(
VARCHAR FileName = @FileName
);
APPLY
( 'INSERT INTO cntnt_cat_itm (
cntnt_id
,cat_itm_nm
,prnt_cat_itm_nm
,updt_dt_tm
,load_dt_tm
,src_tbl_nm
,trans_type_cd
,jrnl_seq_nbr
,commit_locl_tm_zn
,batch_dt
,batch_id
) VALUES
(
:cntnt_id
);'
)
IGNORE DUPLICATE ROWS
SELECT * FROM OPERATOR (Read_Operator[@ReadInst]);
);
I want to extract the part of file highlighted in green color,
I did it this way
awk '/DEFINE SCHEMA/,/\)\;/ {if (NF==2) print}' filename
Now I want to replace the first word of each line in extract with values increamenting t1 as filler, t2 as filler, t3 as filler
so in this case the output should look like this
t1 as filler VARCHAR
There will more more line in extract instead of only one as shown here
Please help me getting this.