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.