<

Go Premium for a chance to win a PS4. Enter to Win

x

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

Posted on
5,967 Points
2,670 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Join & Write a Comment

I have a large data set and a SSIS package. How can I load this file in multi threading?
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
Suggested Courses

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month