Sponsored Content
Top Forums Shell Programming and Scripting How to extract queries using UNIX shell script? Post 302365141 by panyam on Monday 26th of October 2009 06:14:09 AM
Old 10-26-2009
Works only according to the data you posted :
Code:
awk '$0 ~ /INSERT/ {flag=1;} /UPDATE/ {flag=1;} $0 ~ /)/ { flag=0 ;va=va"\n"$0;next} {if(flag==1) {va=va"\n"$0} } END {print va }' input_file.txt

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

shell script queries: $home; broadcast ping

Dear all, This is the Bionic Fysh again. I have two quick questions: 1- when writing shell scripts, how does one allow the tilda ~ into the script ? e.g ls ~; ls ~me; user=you; ls ~$user (N.B I think that for this one you need: ls `~$user`) 2- In FreeBSD 4.0, I would like for a... (6 Replies)
Discussion started by: bionicfysh
6 Replies

2. Shell Programming and Scripting

How to extract data using UNIX shell script?

Hello All, I am starting with UNIX. Any help is highly appreciated. How to extract data using UNIX shell script? And how do you export data using UNIX shell scripts into Microsoft Excel format? Thank you. (3 Replies)
Discussion started by: desiondarun
3 Replies

3. UNIX for Dummies Questions & Answers

shell script for sql queries

Hi All, I have written 4 sql queries . Now I want to write one SHELL SCRIPTING program for all these queries... i.e 1.select * from head; 2. select * from detail; 3. delete from head; 4. delete from detail; Please let me know how to write a shell script... Thank you (1 Reply)
Discussion started by: user71408
1 Replies

4. HP-UX

extract field of characters after a specific pattern - using UNIX shell script

Hello, Below is my input file's content ( in HP-UX platform ): ABCD120672-B21 1 ABCD142257-002 1 ABCD142257-003 1 ABCD142257-006 1 From the above, I just want to get the field of 13 characters that comes after 'ABCD' i.e '120672-B21'... . Could... (2 Replies)
Discussion started by: jansat
2 Replies

5. Shell Programming and Scripting

Multiple MySql queries in shell script?

Hi guys, i know how to run a single query using mysql embedded in a shell script as follows: `mysql -umyuser -pmypass --host myhost database<<SQL ${query}; quit SQL` However, how would i be able to run several queries within the same connection? The reason for this is i am creating... (3 Replies)
Discussion started by: muay_tb
3 Replies

6. Shell Programming and Scripting

Nested SQL queries within Shell script

Hi, Would someone know if I can fire nested sql queries in a shell script? Basically what I am trying to do is as follows: my_sql=$(sqlplus -s /nolog<<EOF|sed -e "s/Connected. *//g" connect... (2 Replies)
Discussion started by: shrutihardas
2 Replies

7. Shell Programming and Scripting

Executing set of sql queries from shell script

Hi All, I tried executing set of queries from shell script but not able to capture the input query in the log file. The code looks something similar to below sqlplus user/pwd@dbname << EOF > output.log $(<inputfile.txt) EOF The above code is capturing the output of queries into... (9 Replies)
Discussion started by: loggedin.ksh
9 Replies

8. Shell Programming and Scripting

How can i run sql queries from UNIX shell script and retrieve data into text docs of UNIX?

Please share the doc asap as very urgently required. (1 Reply)
Discussion started by: 24ajay
1 Replies

9. Shell Programming and Scripting

run sql queries from UNIX shell script.

How can i run sql queries from UNIX shell script and retrieve data into text docs of UNIX? :confused: (1 Reply)
Discussion started by: 24ajay
1 Replies

10. Shell Programming and Scripting

Issue on executing db2 queries through shell script

hi i am trying to execute db2 queries through shell script. it's working fine but for few queries is not working ( those queries are taking time so the script is not waiting to get the complete the execution of that query ) could you please any one help me on this is there any wait... (1 Reply)
Discussion started by: bhaskar v
1 Replies
CROSSPOST(8)						      System Manager's Manual						      CROSSPOST(8)

NAME
crosspost - create the links for cross posted articles SYNOPSIS
crosspost [ -D dir ] [ -s ] [ file... ] DESCRIPTION
Crosspost reads group and article number data from files or standard input if none are specified. (A single dash in the file list means to read standard input.) It uses this information to create the hard, or symbolic, links for cross posted articles. Crosspost is designed to be used by InterNetNews to create the links as the articles come in. Normally innd creates the links but by having crosspost create the links innd spends less time waiting for disk IO. In this mode one would start innd(8) using the ``-L'' flag. Crosspost expects input in the form: group.name/123 group2.name/456 group3.name/789 with one line per article. Any dots in the input are translated into "/" to translate the news group into a pathname. The first field is assumed to be the name of an existing copy of the article. Crosspost will attempt to link all the subsequent entries to the first using hard links if possible or symbolic links if that fails. By default, crosspost processes its input as an INN channel feed written as a ``WR'' entry in the newsfeeds(5) file, for example: crosspost:*:Tc,Ap,WR:/usr/lib/news/bin/crosspost To process the history file and re-create all the links for all articles use: awk <history -F' ' '(NF > 2){print $3}' | crosspost (where the -F is followed by a tab character.) The ``-D'' flag can be used to specify where the article spool is stored. The default directory is /var/spool/news. By default crosspost will fsync(2) each article after updating the links. The ``-s'' flag can be used to prevent this. HISTORY
Written by Jerry Aguirre <jerry@ATC.Olivetti.Com>. SEE ALSO
newsfeeds(5), innd(8). CROSSPOST(8)
All times are GMT -4. The time now is 07:16 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy