a.SQL文件内容为:
{ TABLE "cdw".c_bmdm row size = 75 number of columns = 4 index size = 12 }
{ unload file name = c_bmd00100.unl number of rows = 394 }
create table "cdw".c_bmdm
(
bmdm char(7) not null ,
name char(60)
default '' not null ,
kind char(1)
default '' not null ,
branchid char(7)
default '' not null ,
primary key (bmdm)
);
getfile.awk脚本为:
BEGIN{
flag=0;
}
{
if(($1=="{")&&($2=="TABLE")&&($3==t_name))
{
flag=1;
}
if(($1=="{")&&($2=="unload")&&($3=="file")&&($4=="name")&&($5=="=")&&(flag==1))
{
unloadfilename=$6;
printf(unloadfilename);
flag=0;
}
}
end{};
为得到c_bmdm 表的对应的数据文件:
awk -v t_name="/"cdw/".c_bmdm " -f getfile.awk "a.sql