Home Man
Today's Posts

AIX is IBM's industry-leading UNIX operating system that meets the demands of applications that businesses rely upon in today's marketplace.

Connect to database server and execute sql


Login to Reply

Thread Tools Search this Thread
# 1  
Old 05-13-2018
Connect to database server and execute sql

I have a requirement and below is the detail.
  1. Create a shell script and needs to run in server "a".
  2. Connect to teradata database server "b".
  3. execute the .sql file from server "a" [sql file has only a select query]
  4. Save the output of the query to a file in server "a"
  5. Schedule this shell script to run every day for every 4 hours
  6. trigger email to specific ids once the .sh execution completes
# 2  
Old 05-13-2018
Welcome to the forum.

Unfortunately, your request is quite generic, fuzzy. Any previous attempts on a solution from your side?

Please become accustomed to provide decent context info of your problem.

It is always helpful to carefully and detailedly phrase a request, and to support it with system info like OS and shell, related environment (variables, options), preferred tools, adequate (representative) sample input and desired output data and the logics connecting the two including your own attempts at a solution, and, if existent, system (error) messages verbatim, to avoid ambiguities and keep people from guessing.
Login to Reply

« Previous Thread | Next Thread »
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
Sudo connect to a remote server and execute scripts in remote server masubram Shell Programming and Scripting 6 07-30-2016 07:23 AM
Connect to database through FTP server sparks UNIX for Advanced & Expert Users 4 11-27-2015 04:14 AM
Shell Linux to connect to a database and execute store procedure manichino74 Shell Programming and Scripting 3 07-01-2010 05:46 AM
Different way to connect to database ans execute sql query gauravgarg Shell Programming and Scripting 6 04-30-2010 05:41 AM
Script to connect to a remote server and execute scripts sgbhat Shell Programming and Scripting 5 09-02-2009 05:53 AM
Connect to differect server and execute the script vasuarjula Shell Programming and Scripting 6 08-13-2009 11:17 PM
how you connect to a database ramneek IP Networking 3 09-05-2005 07:25 AM
How to connect database in TC Senthil Programming 5 06-25-2005 10:58 AM
┐can i connect from a .sh or .sc to a database? DebianJ Shell Programming and Scripting 1 05-03-2005 06:09 PM
┐how can I connect C to a database? DebianJ Programming 0 05-03-2005 09:58 AM

All times are GMT -4. The time now is 02:24 AM.

Unix & Linux Forums Content Copyrightę1993-2018. All Rights Reserved.
Show Password