Re: from the command line
Posted in 1995
Harvey T. Moose (harvey@boi.hp.com) wrote:
: Hi, I'm kind of new to Informix. Is there a way to run an isql form or report
: from the command line?
: thank you.
For you shell users, I'll repost my aliases.rc file that lets you talk to
dbaccess (or isql) directly from the command line. Set the $DB environmental
variable before creating these aliases.
alias alter "echo 'alter \\!:*;' | $INFORMIXDIR/bin/isql $DB"
alias create "echo 'create \\!:*;' | $INFORMIXDIR/bin/isql $DB"
alias delete "echo 'delete \\!:*;' | $INFORMIXDIR/bin/isql $DB"
alias drop "echo 'drop \\!:*;' | $INFORMIXDIR/bin/isql $DB"
alias grant "echo 'grant \\!:*;' | $INFORMIXDIR/bin/isql $DB"
alias insert "echo 'insert \\!:*;' | $INFORMIXDIR/bin/isql $DB"
alias rename "echo 'rename \\!:*;' | $INFORMIXDIR/bin/isql $DB"
alias revoke "echo 'revoke \\!:*;' | $INFORMIXDIR/bin/isql $DB"
alias select "echo 'select \\!:*;' | $INFORMIXDIR/bin/isql $DB"
alias update "echo 'update \\!:*;' | $INFORMIXDIR/bin/isql $DB"
alias info "echo 'info \\!:*;' | $INFORMIXDIR/bin/isql $DB"
(substitute "dbaccess" for "isql" if you don't have isql.
Joe
--
---------------------------------------------------------------------------
Joe Lumbley(jlumbley@netcom.com) Dallas, Texas
----------------------------------------------------------------------------