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

AIX


Reply    
 
Thread Tools Search this Thread Display Modes
    #1  
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
    #2  
Old Unix and Linux 1 Week Ago   -   Original Discussion by MadhuSeven
RudiC's Unix or Linux Image
RudiC RudiC is offline Forum Staff  
Moderator
 
Join Date: Jul 2012
Last Activity: 23 May 2018, 12:42 PM EDT
Location: Aachen, Germany
Posts: 12,740
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
Reply

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:44 PM.