<

Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x

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

Posted on
5,816 Points
2,516 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
Comment
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

10 Questions to Ask when Buying Backup Software

Choosing the right backup solution for your organization can be a daunting task. To make the selection process easier, ask solution providers these 10 key questions.

Join & Write a Comment

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month