教你快速掌握Informix SQL的11个使用技巧

WHERE datecol >= "this/date" AND datecol 
<= "that/date"  要比  WHERE datecol BETWEEN 
"this/date" AND "that/date" 慢。

# update_em  

# Run UPDATE STATISTICS on a table by table basis  

#  DATABASE=$1  

if [ -z "$DATABASE" ]  

then  

echo "usage: update_em dbname" >&2  

exit 1  

fi  

isql $DATABASE - < dev/null | isql $DATABASE -  

output to pipe "cat" without headings  

select "update statistics for table ", tabname, ";"  

from systables where tabid >= 100 order by tabname;  

EOF 

exit 0

# Generate the data  

isql -qr <<!>stage.rep 2>$stage.err  

database $database;  

select ...  

!  

# Check for errors  

if grep -i "error" $stage.err >/dev/null  

then 

...error_handler...  

fi

CREATE VIEW tst (cout) AS  

SELECT ship_charge - totval  

FROM orders WHERE ship_charge > 0;

SELECT firstname, lastname, city, state  

FROM bigdatabase  

WHERE state = "TX"