<

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

Posted on
8,364 Points
5,066 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

Suggested Videos

Are you ready for a Linked Table Manager (LTM): - with a sizable form - which identifies which connections are valid and how many tables are associated with the connection - which doesn't ask you to select the BE multiple times when you've ident…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month