Linux

Thanks Franklin ,
I think you meant this when you wrote first .

awk '/^GRANT/ && !/DIM_PROVIDER/{sub("DIM_PROVIDER","VW_DIM_PROVIDER")}1' dim_provider.sql > newfile

It works absolutely fine if I use only dim_provider file . But I am having issues with the larger code in which I pass the table name as $TN and the schemaname is ${target_schema} .
Can I substitute these parameters something like this ???

awk '/^GRANT/ && !/$TN/{sub(${target_schema}.,${target_schema}."VW_")}1' ${target_schema}.$TN.${ecmdate}.sql > $tmpfile_cln

but code is not working .When I run it as sh -x <script name> <dbname > <source schema > <target schema >

awk /^GRANT/ && !/$TN/{sub(${target_schema}.,${target_schema}."VW_")}1 OPSDM002.fact_physician.20080530.sql
+ 1> /tmp/tmpfile_cln
syntax error The source line is 1.
The error context is
/^GRANT/ && >>> !/$TN/{sub(${ <<<
awk: The statement cannot be correctly parsed.
The source line is 1.
awk: Quitting
The source line is 1.

Help please !
Thanks

Oops i meant this code is working fine only for dim_provider.sql file .

awk '/^GRANT/ && !/DIM_PROVIDER/{sub("OPSDM002.","OPSDM002.VW_")}1' dim_provider.sql > dim_provider.sql1

Rest of the question is same like above .

But I am having issues with the larger code in which I pass the table name as $TN and the schemaname is ${target_schema} .
Can I substitute these parameters something like this ???

awk '/^GRANT/ && !/$TN/{sub(${target_schema}.,${target_schema}."VW_")}1' ${target_schema}.$TN.${ecmdate}.sql > $tmpfile_cln

but code is not working .When I run it as sh -x <script name> <dbname > <source schema > <target schema >

awk /^GRANT/ && !/$TN/{sub(${target_schema}.,${target_schema}."VW_")}1 OPSDM002.fact_physician.20080530.sql
+ 1> /tmp/tmpfile_cln
syntax error The source line is 1.
The error context is
/^GRANT/ && >>> !/$TN/{sub(${ <<<
awk: The statement cannot be correctly parsed.
The source line is 1.
awk: Quitting
The source line is 1.

Help please !
Thanks

How do I make this code dynamic ?

I hope i am not confusing anymore .

Thanks ,

You can use shell variables as follow:

Regards

Mr Franklin ,
I am having issues with unix . Please help me here once again as i add more awk to my code . It is sh -x

+ awk -v tn=fact_physician -v ts=OPSDM002 /^GRANT/ && !/$tn/{sub($ts,$ts."VW_")}1 OPSDM002.fact_physician.20080530.sql
+ 1> /tmp/tmpfile_cln
syntax error The source line is 1.
The error context is
/^GRANT/ && >>> !/$tn/{sub($ts,$ts. <<< "VW_")}1
awk: The statement cannot be correctly parsed.
The source line is 1.


The code part is

awk -v tn="$TN" -v ts="$target_schema" '/^GRANT/ && !/$tn/{sub($ts,$ts."VW_")}1' ${target_schema}.$TN.${ecmdate}.sql > $tmpfile_cln

even without double quotes , the output file is of size 0 .

Thanks again ,

Dont use a "$" before variables within the awk command:

Code:

awk -v tn="$TN" -v ts="$target_schema" '/^GRANT/ && !/tn/{sub(ts,ts."VW_")}1' ${target_schema}.$TN.${ecmdate}.sql > $tmpfile_cln

Regards

Its not working either .

+ awk -v tn=fact_physician -v ts=OPSDM002 /^GRANT/ && !/tn/{sub(ts,ts."VW_")}1 OPSDM002.fact_physician.20080530.sql
+ 1> /tmp/tmpfile_cln
syntax error The source line is 1.
The error context is
/^GRANT/ && >>> !/tn/{sub(ts,ts. <<< "VW_")}1
awk: The statement cannot be correctly parsed.
The source line is 1.

code is

awk -v tn="$TN" -v ts="$target_schema" '/^GRANT/ && !/tn/{sub(ts,ts."VW_")}1' ${target_schema}.$TN.${ecmdate}.sql > $tmpfile_cln

Thanks,

It should work, try nawk or /usr/xpg4/bin/awk on Solaris.

Regards