I have a challenging issue that I am facing below
I have the below text in a file:
create table "ctronsys".activity_codes
(
code_list_id varchar(8),
code_id varchar(10),
record_type varchar(1),
active_status_ind varchar(1),
security_level varchar(1),
short_description varchar(10),
long_description varchar(30),
record_class varchar(1),
owner_id varchar(4),
modify_user_id varchar(3),
modify_date date,
create_user_id varchar(3),
create_date date
) in datadbs extent size 16 next size 16 lock mode row;
My aim is to grep for the below line in the text file:
create table "ctronsys".activity_codes
and using the above to retrieve the line below:
) in datadbs extent size 16 next size 16 lock mode row;
Note that the number of lines to search below is not specific according to table structures
I have the below command, which allows me to print a column within a line above the grepped line using awk, however this only prints a single column within that line whereas I would like to print the entire line:
cat table_structure | awk -v key="datadbs" '/^create/ {val=$3} $3 == key {print val;}'