Executing a SQL Script from a Unix Shell Script and Passing Parameters

Posted on 2014-08-14

5,569 Points

2 Comments

2,270 Views

3 Endorsements

Last Modified: 2014-08-26

Experience Level: Beginner

4:58

Steve Wales

This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

Comment

Author:Steve Wales

2 Comments

LVL 5

Expert Comment

by:magento2015-02-21

Hi Steve,

Thanks for information very useful.
In the sameway can you please create a simple video which runs a procedure and store the output of the procedure in shell script to proceed further.

Thanks in advance.

LVL 22

Author Comment

by:Steve Wales2015-02-21

Not quite sure what you're looking for. You want to call a stored procedure that returns a value and then that value is captured in the shell script instead of the return value from the query as shown in the video ?

Join & Write a Comment Already a member? Login.

Suggested Videos

Title	Views	Activity
Set Up Backup with Maintenance Plans (SQL Server)	271	16h
How to Shrink a Bloated Transaction Log File (SQL Server)	483	16h
Using Transportable Tablespace Functionality in Oracle	259	16h
SQL - Updating and Deleting Data	223	16h

Five Myths of Oracle Database Backup

Article by: Acronis

When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.

Installing SQL Server vNext on Linux: Part 2

Article by: Yashwant

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.