We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

dbaccess script

cbones
cbones asked
on
Medium Priority
610 Views
Last Modified: 2012-05-11
I am looking to automate a query in our database using dbaccess.  I have the start of the file and the query but am not sure how to automate this.  My files starts with:

dbaccess -qn  (this brings me to start my select statement but I've been looking around the internet and don't see how to add the select statement in so it automatically runs.  Manually everything works fine).  Also, I would like to save this query to a file on the server.

Any help would be appreciated.
Comment
Watch Question

Can you put your commands in a file or to run from the command line, try:
dbaccess dbname << select here

Here's some links that might help.

http://www.dbforums.com/informix/1200536-query-informix-table-command-line.html
http://www.dbforums.com/informix/1650938-dbaccess-command-line-help-newbie.html
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.