$ cat list
SCHEMA1 TABLE1
SCHEMA2 TABLE2
SCHEMA3 TABLE3
SCHEMA4 TABLE4
SCHEMA5 TABLE5
没有引号
==========================================================================================================
$ cat list | awk '{print "select char(tabschema,20),char(tabname, 60),char(colnames,200) from syscat.indexes where tabschema="$1" and tabname="$2" and UNIQUERULE='P';"}'
select char(tabschema,20),char(tabname, 60),char(colnames,200) from syscat.indexes where tabschema=SCHEMA1 and tabname=TABLE1 and UNIQUERULE=P;
select char(tabschema,20),char(tabname, 60),char(colnames,200) from syscat.indexes where tabschema=SCHEMA2 and tabname=TABLE2 and UNIQUERULE=P;
select char(tabschema,20),char(tabname, 60),char(colnames,200) from syscat.indexes where tabschema=SCHEMA3 and tabname=TABLE3 and UNIQUERULE=P;
select char(tabschema,20),char(tabname, 60),char(colnames,200) from syscat.indexes where tabschema=SCHEMA4 and tabname=TABLE4 and UNIQUERULE=P;
select char(tabschema,20),char(tabname, 60),char(colnames,200) from syscat.indexes where tabschema=SCHEMA5 and tabname=TABLE5 and UNIQUERULE=P;
加个单引号
==========================================================================================================
$ cat list | awk -v x="'" '{print "select char(tabschema, 20), char(tabname, 60), char(colnames, 200) from syscat.indexes where tabschema="x$1x" and tabname =" x$2x" and uniquerule = "x"P"x";"}'
select char(tabschema, 20), char(tabname, 60), char(colnames, 200) from syscat.indexes where tabschema='SCHEMA1' and tabname ='TABLE1' and uniquerule = 'P';
select char(tabschema, 20), char(tabname, 60), char(colnames, 200) from syscat.indexes where tabschema='SCHEMA2' and tabname ='TABLE2' and uniquerule = 'P';
select char(tabschema, 20), char(tabname, 60), char(colnames, 200) from syscat.indexes where tabschema='SCHEMA3' and tabname ='TABLE3' and uniquerule = 'P';
select char(tabschema, 20), char(tabname, 60), char(colnames, 200) from syscat.indexes where tabschema='SCHEMA4' and tabname ='TABLE4' and uniquerule = 'P';
select char(tabschema, 20), char(tabname, 60), char(colnames, 200) from syscat.indexes where tabschema='SCHEMA5' and tabname ='TABLE5' and uniquerule = 'P';
$ cat list | awk -v x="\'" '{print "select char(tabschema, 20), char(tabname, 60), char(colnames, 200) from syscat.indexes where tabschema="x$1x" and tabname =" x$2x";"}'
select char(tabschema, 20), char(tabname, 60), char(colnames, 200) from syscat.indexes where tabschema='SCHEMA1' and tabname ='TABLE1';
select char(tabschema, 20), char(tabname, 60), char(colnames, 200) from syscat.indexes where tabschema='SCHEMA2' and tabname ='TABLE2';
select char(tabschema, 20), char(tabname, 60), char(colnames, 200) from syscat.indexes where tabschema='SCHEMA3' and tabname ='TABLE3';
select char(tabschema, 20), char(tabname, 60), char(colnames, 200) from syscat.indexes where tabschema='SCHEMA4' and tabname ='TABLE4';
select char(tabschema, 20), char(tabname, 60), char(colnames, 200) from syscat.indexes where tabschema='SCHEMA5' and tabname ='TABLE5';
加个双引号
===================================================================================================================================
$ cat list | awk -v x='"' '{print "select char(tabschema, 20), char(tabname, 60), char(colnames,200) from syscat.indexes where tabschema="x$1x" and tabname="x$2x";"}'
select char(tabschema, 20), char(tabname, 60), char(colnames,200) from syscat.indexes where tabschema="SCHEMA1" and tabname="TABLE1";
select char(tabschema, 20), char(tabname, 60), char(colnames,200) from syscat.indexes where tabschema="SCHEMA2" and tabname="TABLE2";
select char(tabschema, 20), char(tabname, 60), char(colnames,200) from syscat.indexes where tabschema="SCHEMA3" and tabname="TABLE3";
select char(tabschema, 20), char(tabname, 60), char(colnames,200) from syscat.indexes where tabschema="SCHEMA4" and tabname="TABLE4";
select char(tabschema, 20), char(tabname, 60), char(colnames,200) from syscat.indexes where tabschema="SCHEMA5" and tabname="TABLE5";
$ cat list | awk -v x="\"" '{print "select char(tabschema, 20), char(tabname, 60), char(colnames, 200) from syscat.indexes where tabschema="x$1x" and tabname =" x$2x";"}'
select char(tabschema, 20), char(tabname, 60), char(colnames, 200) from syscat.indexes where tabschema="SCHEMA1" and tabname ="TABLE1";
select char(tabschema, 20), char(tabname, 60), char(colnames, 200) from syscat.indexes where tabschema="SCHEMA2" and tabname ="TABLE2";
select char(tabschema, 20), char(tabname, 60), char(colnames, 200) from syscat.indexes where tabschema="SCHEMA3" and tabname ="TABLE3";
select char(tabschema, 20), char(tabname, 60), char(colnames, 200) from syscat.indexes where tabschema="SCHEMA4" and tabname ="TABLE4";
select char(tabschema, 20), char(tabname, 60), char(colnames, 200) from syscat.indexes where tabschema="SCHEMA5" and tabname ="TABLE5";
=======================================================================================================================================