Re: Removing ISQL headings

Tony Heskett, in your mail you wrote: > > Many thanks, just what I wanted. You can catch the output, too : > > : > echo 'output to pipe "tr a-z A-Z" without headings > select lname, fname from employee' |> isql dbname 2>/dev/null | > pr -2 | > lp > Thats getting sick... check out this sickness! All of our "look-up" tables are preceded with "lu_" in the table name and the indexes on those tables are to be clustered every night. Here goes: Here --------- Snip Here --------- Snip Here --------- Snip Here --------- Snip # cluster_em # Automagically cluster indexes for look-up tables. # isql tracsy - <<! 2>/dev/null | isql tracsy - output to pipe "sort -u -t_ +0 -2 " without headings select "alter index", idxname, "to cluster;" from systables, sysindexes where tabname matches "lu_*" and systables.tabid = sysindexes.tabid order by idxname; ! Here --------- Snip Here --------- Snip Here --------- Snip Here --------- Snip DAS -- David A. Snyder @ UE&C - Catalytic in Philadelphia, PA UUCP: ..!uunet!trac2000!das INTERNET: das@trac2000.ueci.com