Log in

No account? Create an account

GEEK: shell script question - Open Knowledge — LiveJournal

Dec. 12th, 2007

06:22 pm - GEEK: shell script question

Previous Entry Share Next Entry

[EDIT: it's called a "here document"] Thanks variax!

Suppose you want pass in a complex query to a command line sql interpreter from within a shell script. You can do so with a command like this:

sql92 <<EOF 
    connect to db1 as LASTTRADES user eouser; 
    set format row; 
    select  p.fundkey as fundkey, 
        max(t.closed) as last_trade 
    from    mposition p, mtrade t 
    where   p.primarykey=t.positionkey 
     and    t.createdbycorporateaction=0 
    group by fundkey; 
There’s a name for the syntax of the argument: <<EOF...EOF

But for the life of me, I can’t recall it, or find it on the web. Anyone know this off hand?

Original: craschworks - comments


(Deleted comment)
[User Picture]
Date:December 13th, 2007 01:32 am (UTC)
Ah, thanks! That's it.
(Reply) (Parent) (Thread)