Experts Exchange

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

Posted on 2014-08-14

8,024 Points

2 Comments

4,724 Views

3 Endorsements

Last Modified: 2014-08-26

Experience Level: Beginner

4:58

Steve Wales

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.

Author:Steve Wales

2 Comments

LVL 5

Expert Comment

by:magento2015-02-21

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.

LVL 23

Author Comment

by:Steve Wales2015-02-21

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 ?

Featured Post

Suggested Videos

Title	Views	Activity
Restore Database from RMAN Backup (Oracle)	895	4d
Basic Housekeeping for SQL Server	894	2019-07-05
SQL - Selecting Rows and Columns	589	2h
Importing a DynamoDB Table From an S3 Export	1,180	2d

Repair Corrupted Database If DBCC Checkdb Failed

Article by: SysTools

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.