<

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

Posted on
8,024 Points
4,724 Views
3 Endorsements
Last Modified:
Experience Level: Beginner
4:58
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.
3
Author:Steve Wales
2 Comments
LVL 5

Expert Comment

by:magento
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.
0
LVL 23

Author Comment

by:Steve Wales
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 ?
0

Featured Post

Learn SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

Repair corrupted SQL Server database even if DBCC CHECKDB fails in SQL Server.  This blog describes, what to do when DBCC CHECKDB failed and printed database corruption errors.
In this article, we will see how we can fix the OLE DB connection error when connecting to an Oracle database using SQL Server Integration Services.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month