How to pass parameter from shell script to sql file

Kimball Hawkins Posted June 10, 0 Comments. Paul Pedant Posted June 10, 0 Comments. Not an entirely helpful approach, but it does explain why the number of options varies.

Either this SQL script would never work or the invocation is for a different script entirely. Thanks for the answer! Register or Login. Welcome back! Sign in with Email. Reset Your Password We'll send an email with a link to reset your password.

Stay ahead! Maybe this would be more parsable later:. If you set pages 0 and set heading off , your repeated calls might appear in a neat list. Or get the results as CSV with:. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 8 years, 6 months ago. Active 8 years, 6 months ago. Viewed k times. I have a shell script that calls file.

My shell script calls file. Using a shell script wrapper, you could do something like. It provides a language that is a blend of shell script and SQL. So you can get your sqsh shell script to read parameters from the command line or a file etc. Sign up to join this community. The best answers are voted up and rise to the top. Stack Overflow for Teams — Collaborate and share knowledge with a private group.

Create a free Team What is Teams? Learn more. Asked 10 years, 7 months ago. Active 8 years, 9 months ago. The sqlcmd utility accepts inputs from a batch file. The batch files simply accept a list of arguments from cmd prompt and allow the program to function based on the order of input parameter.

The bat file accepts four input parameters. The position of the input is important. The order in which the parameters are fed will have an impact on the functioning of the script. For example, consider a batch file named "sql.

BAT" that requires three input parameters. The "FOR" construct offers looping capabilities for batch files. Specifically, it allows sequencing through a list of parameters. For example, consider a SQL file named "sqlcmd.

The above example loops through all servers, execute the sqlcmd.