Unix/Linux Go Back    

AIX 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


Thread Tools Search this Thread Display Modes
Old Unix and Linux 1 Week Ago   -   Original Discussion by MadhuSeven
MadhuSeven's Unix or Linux Image
MadhuSeven MadhuSeven is offline
Registered User
Join Date: May 2018
Last Activity: 13 May 2018, 10:12 AM EDT
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
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
Sponsored Links
Old Unix and Linux 1 Week Ago   -   Original Discussion by MadhuSeven
RudiC's Unix or Linux Image
RudiC RudiC is online now Forum Staff  
Join Date: Jul 2012
Last Activity: 23 May 2018, 12:21 PM EDT
Location: Aachen, Germany
Posts: 12,737
Thanks: 413
Thanked 3,913 Times in 3,599 Posts
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.
Sponsored Links

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Linux More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
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
Connect to differect server and execute the script vasuarjula Shell Programming and Scripting 6 08-13-2009 11:17 PM
Connect From VB to SQL Server Than Chanroeun Solaris 0 08-04-2006 11:48 AM

All times are GMT -4. The time now is 12:26 PM.