<

Improve company productivity with a Business Account.Sign Up

x

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

Posted on
6,329 Points
3,029 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

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

Join & Write a Comment

MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
An introductory discussion about Oracle Analytic Functions which are used to calculate or compute Aggregate values, based on a group of rows.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month