Shell Programming and Scripting

I am afraid I don't understand awk well enough to do the following.

I have a file with a bunch of select statements where the a line starts off with this pattern:
"Last parsed SQL statement :", then continues with the select statement. At the first blank space I'd like it to stop, print that entire select statement, and then ignore the rest of the file until it comes to the next select.
Only print the select statements, and add a newline between each one.

Some of these selects are duplicates it would be nice if the dups could be removed, but not as necessary.
The file pattern is like this:

Last parsed SQL statement :
select and then a multi line query
the rest of the query
....

Informix Dynamic Server Version 10.00.FC5 -- On-Line -- Up 2 days 21:32:45 -- 19055584 Kbytes

Sess SQL Current Iso Lock SQL ISAM F.E.
Id Stmt type Database Lvl Mode ERR ERR Vers Explain
1060733 - sentryprod NL Not Wait 0 0 9.03 Off

Last parsed SQL statement :
select and then a multi line query
the rest of the query
....

Any help is greatly appreciated !

Thanks,
floyd

Please provide a more realistic data rather than "..." and "rest of query" etc
We need to know where it ends and how does the next line looks like and all.

A guess work... Try this...

Code:

awk '/Last parsed/,/^ *$/{if(!/Last parsed/)print}' infile

--ahamed

Here is a more exact model of what the file looks like.
I just replaced the actual sql with jibberish.

Last parsed SQL statement :
update sometable set somecolumn=somevalue where
somevalue in (select somecolumn from sometable where
somevalue='something' )


IBM Informix Dynamic Server Version 10.00.FC5 -- On-Line -- Up 2 days 21:32:45 -- 19055584 Kbytes

Sess SQL Current Iso Lock SQL ISAM F.E.
Id Stmt type Database Lvl Mode ERR ERR Vers Explain
1060733 - sentryprod NL Not Wait 0 0 9.03 Off

Last parsed SQL statement :
select somthing from some table where something=something and
something else=something else


IBM Informix Dynamic Server Version 10.00.FC5 -- On-Line -- Up 2 days 21:32:45 -- 19055584 Kbytes
...
....

Did you try the code in post#2? And do you want only the select statements or all the statements?

--ahamed

I am stupid. I didn't think that would work, because it looked like all you were printing was the line where Last parsed was.
Shows you how little I understand awk.

So I just tried your exact code and it looks like it gave me exactly what I want.
Thank you !! I will attempt to study that.

Do you know if there is a way to use awk to remove the duplicate sql statements ?

Removing duplicate is possible, but you need to tell us or show us how the statements look like. For e.g. do they have the exact syntax and spacing etc.

Paste an input with duplicate sql statements and we'll give it a try!

--ahamed