Sponsored Content
Top Forums Shell Programming and Scripting Insert query with shell variable with AWK Post 302715765 by Kabira Speaking on Monday 15th of October 2012 11:03:46 AM
Old 10-15-2012
Data Back to Square One

Thanks Klashxx for instant replies.

I changed the script to look like this.

Code:
awk '{         
        nbr=split($0,arr,",")
        for(ix=1;ix<=nbr;ix++){
        print "db2 \"INSERT INTO PRICING_PRODUCT_CODES (PRODUCT_CODE, NETWORK_NAME, ACTIVE) values (\'"arr[ix]"\',\'some value\',1) " 
        print "where NOT EXISTS (select * from TABLE_NAME where PRODUCT_CODE = \'"arr[ix]"\');\"" 
    }' PRICING_PRODUCT_CODES.txt

And I got this error
Code:
0403-057 Syntax error at line 33 : `)' is not expected.

Basically, I want insert queries like this

Code:
Insert into table(col1,col2) values('valuefromfile1','staticvalue1') where ....;
Insert into table(col1,col2) values('valuefromfile2','staticvalue2') where ....;


Last edited by Kabira Speaking; 10-15-2012 at 12:05 PM.. Reason: Forgot to thank Klashxx
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk problem when attributing query to a variable

Hello, I'm trying to make a script which reads the PID of a process using awk. I've read the thread in this forum where it is explained. However, the problem i'm having is when attributing that PID value to a variable. I'm using AIX 5.3. The command is the following: :/home/user1>ps -ef |... (2 Replies)
Discussion started by: mambo
2 Replies

2. Shell Programming and Scripting

Setting variable for query using iSql / Korn Shell

Hi All- First time using iSql. I have 4 query files - some have more than 1 line of sql statements After a bit of research it appears I can just use the -i command and specify the input file. Questions: Does it matter that there are multiple queries in each file? Do I need to have... (3 Replies)
Discussion started by: Cailet
3 Replies

3. Shell Programming and Scripting

Passing a variable from shell script to mysql query?

I heard this was possible but from my research I haven't been able to figure it out yet. Seems it should be simple enough. Basically from a high level view I'm trying to accomplish... . $X='grep foo blah.log' then 'mysql command SELECT foo FROM bar WHERE ' . $X or something like that. ... (2 Replies)
Discussion started by: kero
2 Replies

4. Shell Programming and Scripting

Insert external variable in a AWK pattern

Dear all, ¿How can i insert a variable in a AWK pattern? I have almost succeeded in solving a puzzle with AWK but now i want to make a script. Let me explain. cat file.txt | awk 'BEGIN {RS="\\n\\n"} /tux/ { print "\n"$0 }' I know that this command makes right what i want to do, but mi... (8 Replies)
Discussion started by: antuan
8 Replies

5. Shell Programming and Scripting

How to use a variable in insert query?

My script contains as follows, VALUE=`sqlplus un/pwd <<EOF > OB.txt set pagesize 0 feedback off verify off heading off echo off select max(1) from table1; exit; EOF` insert into table2 values(1, 'The max value is $value',...); i need the value of VALUE to be inserted after 'The max... (2 Replies)
Discussion started by: savithavijay
2 Replies

6. Shell Programming and Scripting

Forming an insert query using awk

Hi, I'm trying to form an insert sql query using shell programming. I have table named company with four columns 'company name', 'company id', 'company code' and 'last change id' I have to read the company name, company code and last change id from a file delimited by | which has around 10... (4 Replies)
Discussion started by: rakesh_s
4 Replies

7. Shell Programming and Scripting

Using a shell script variable in a mysql query using 'LIKE'

Hello. I am writing a simple script that reads a text file and removes records from a mysql database. The items in the text file are of the format: firstname.middle.lastXXX, where XXX is a 3 digit number. The table has an email field that will match the firstname.middle.last. So, I thought I... (1 Reply)
Discussion started by: bricoleur
1 Replies

8. UNIX for Dummies Questions & Answers

insert variable into awk

I'm trying to insert a filename into awk. filename="12345.wmv" I have tried this: awk '/$filename/{print $0}' infile and this: awk -v fn=$filename '/$fn/{print $0}' infile How do I insert the variable into awk? (1 Reply)
Discussion started by: locoroco
1 Replies

9. Shell Programming and Scripting

[awk] - how to insert an external variable

I want to incorporate the variable in the for statement as a column of my processed file. In the INCORRECT example below, it is $i which corresponds to the i in my for loop: for i in x86_64 i686; do awk '{ print $1" "$4" "$5" "$i }'awk $file-$i > processed-$i.log doneThanks! (3 Replies)
Discussion started by: graysky
3 Replies

10. Shell Programming and Scripting

Passing value of variable to a query within shell script

I have a script in which i connect to database to run a query and get the result of the query to a temp file. This works fine , now what i want is there is flat file which contains the value to be used in the query. I want to read this file line by line and then run the query for each value in that... (7 Replies)
Discussion started by: gpk_newbie
7 Replies
LIVEDINGS(1)							   User Commands						      LIVEDINGS(1)

NAME
livedings - graphical frontend for mididings SYNOPSIS
livedings -p control_port -l listen_port [options] DESCRIPTION
livedings is a graphical frontend for mididings that allows users to monitor and trigger scene changes. It runs as a separate application that uses OSC to communicate with mididings. To use it, enable the OSCInterface hook in a mididings script, specifying two unused UDP ports: from mididings.extra.osc import OSCInterface hook(OSCInterface(56418, 56419)) ... Then run livedings with the same port numbers: $ livedings -p 56418 -l 56419 The first port is used by mididings to listen for commands, the second one is used to notify livedings of scene changes. OPTIONS
-h, --help show this help message and exit -p CONTROL_PORT OSC port mididings is listening on -l LISTEN_PORT OSC port for notifications from mididings -T enable custom theme and larger fonts -x WIDTH width of window in pixels (640) -y HEIGHT height of window in pixels (400) -w LIST_WIDTH width of scene list in pixels (240) -F FONT display font (Sans 14 bold) -f LIST_FONT scene list font (Sans 10) -c COLOR text color (gray50) -C COLOR_HIGHLIGHT highlight text color (black) -b COLOR_BACKGROUND background color SEE ALSO
mididings(1) AUTHOR
livedings was written by Dominic Sacre <dominic.sacre@gmx.de>. This manual page was written by Alessio Treglia <alessio@debian.org>, for the Debian project (and may be used by others). November 2010 LIVEDINGS(1)
All times are GMT -4. The time now is 03:18 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy