×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Executing SQL from command line?

Executing SQL from command line?

Executing SQL from command line?

(OP)
I'm trying to figure out if/how I can execute sql to an informix DB from the command line.  I know I can dbaccess dbname filename, but I don't want to have a file...I just want to specify the sql to execute right there from the command line so there's no file to keep up with.  Any ideas?

RE: Executing SQL from command line?

llevity:

The informix dbaccess and isql utilities were written as pipes, so if you don't want to use files you can use "here" documents:

dbaccess -e testdb <<EDS
select * from test_table
<<EDS

or

echo "select * from test_table"|dbaccess -e testdb

of you can even take advantage of shell variables:

export DBNAME=testdb

echo "select * from test_table"|dbaccess -e "$DBNAME"

Also, you might put dbaccess in it's own shell script.  Call the script x.ss:

dbaccess -e testdb <<EDS
$1
EDs

and call it this way:

x.ss "select * from test_table"

Regards,

Ed
Schaefer

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close