Search Results

I am able to generate the queries as desired. But I don't know how to execute them from inside the awk block?

Thanks Klashxx for instant replies.

I changed the script to look like this.

awk '{
nbr=split($0,arr,",")
for(ix=1;ix<=nbr;ix++){
print "db2 \"INSERT INTO...

I tried replacing 'awk' with 'gawk' and I get, gawk: not found. Could you please tell me what is wrong with the script I had written the first time.
awk '{ nbr=split($2,arr,","); ...

I changed the query to this

awk '{print "db2 \"INSERT INTO TABLE_NAME (PRODUCT_CODE) values ("$1",) where NOT EXISTS (select * from TABLE_NAME where PRODUCT_CODE=("$1")\""}' RS=','...

Hi,
I'm a first timer with Unix so pardon my ignorance.
I'm trying to read a comma separated file from the same folder where the script is and insert the value in a DB2 table.
I'm using AWK for...