Sponsored Content
Top Forums Shell Programming and Scripting Windows script to shell script Post 303015051 by shefali1908 on Tuesday 27th of March 2018 01:39:15 AM
Old 03-27-2018
Windows script to shell script

Code:
SETLOCAL  	
REM execute merged script into DB
IF "%EnvName%"=="DEV" (
echo This is Dev

for /f "tokens=2 delims=^=" %%l in ('findstr "Server_%EnvName%" "%~dp0%configFilePath%"') do (
SET serv=!serv!%%l
echo "Server Name !serv!"
)

for /f "tokens=2 delims=^=" %%m in ('findstr "User_%EnvName%" "%~dp0%configFilePath%"') do (
SET usrName=!usrName!%%m
echo "USER Name !usrName!"
)

for /f "tokens=2 delims=^=" %%n in ('findstr "Pwd_%EnvName%" "%~dp0%configFilePath%"') do (
SET pwd=!pwd!%%n
echo "Password !pwd!"
)

for /f "tokens=2 delims=^=" %%n in ('findstr "DB_%EnvName%" "%~dp0%configFilePath%"') do (
SET db=!db!%%n
echo "Database !db!"
)

rem Execute for ddldml scripts first then SP.
sqlcmd -S !serv! -U !usrName! -P !pwd! -d !db! -i "%~dp0SourceCode\Output\MergedDDLAndDMLFile.sql"
sqlcmd -S !serv! -U !usrName! -P !pwd! -d !db! -i "%~dp0SourceCode\Output\MergedStoredProcs_!stamp!.sql"
echo SQLCommend ended successfully.
endlocal

Moderator's Comments:
Mod Comment Welcome on board, please use code tags for your code and data, thanks

Last edited by vbe; 03-27-2018 at 03:44 AM.. Reason: code tags
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How to execute a shell script from Windows

I like to start a korn job remotely, from windows. I tried REXEC and that is not what I want. Need help !!!! thanks (4 Replies)
Discussion started by: kyawlin
4 Replies

2. UNIX for Advanced & Expert Users

Executing shell script from Windows FTP

Hello, Any inputs on the possibility of executing a shell script on unix box from Windows FTP TIA (1 Reply)
Discussion started by: B2BIntegrator
1 Replies

3. Shell Programming and Scripting

Renaming putty windows with a shell script

i frequently have to open multiple putty windows to ssh into a unix server running HP-UX 11.23. Since i use some of the windows for dedicated processes i would like to rename them (the caption displayed in the titlebar) to something more convenient than the standard <Host>.<Server>.com While... (4 Replies)
Discussion started by: orno
4 Replies

4. UNIX for Advanced & Expert Users

Executing a shell script from windows;script present in unix

I need to execute a shell script kept in unix machine from windows. User id, password area available. For eg. There's a shell script wich moves all the logs kept in my home directory to a directory named LOGS. Now i need to get this done through windows; either using a batch file, or java... (4 Replies)
Discussion started by: rajneesh_kapoor
4 Replies

5. UNIX for Dummies Questions & Answers

Shell script in windows

I use windows and I wanted to know how I can use shell script in windows. I saw windows power shell but the commands they use seem to be different from those I know as a newbie. For example I wanted to change the permission of a file using chmod, but it doesn't recognise such a command. So I would... (12 Replies)
Discussion started by: #moveon
12 Replies

6. Shell Programming and Scripting

Change the Windows Batch script to UNIX shell script.

Hi, When I run the below script in UNIX it's throwing syntax errors. Actually it's a windows batch script. Could anyone change the below Windows Batch script to UNIX shell script... Script: REM :: File Name : Refresh_OTL.bat REM :: Parameters : %1 - Region REM :: : %2 - Cube Type REM ::... (5 Replies)
Discussion started by: tomailraj
5 Replies

7. UNIX for Advanced & Expert Users

ftp in shell script from linux to windows XP

Hi, I have 9 different linux based servers and i am automating there healthcheckup by doing ssh and fetching deviations out of it in a single text file. I am doing so by using ssh keygen. I am done with the above part . Now i want to ftp that text file to my windows XP desktop and i want to... (4 Replies)
Discussion started by: gemnian.g
4 Replies

8. Shell Programming and Scripting

Unix shell script to Copy files from one Windows server to another Windows server.

Can anybody please help me on how to code for the below requirement: I need to write a shell script (on different unix server) to copy files from multiple folders (ex. BRN-000001) from one windows server (\\boldls-mwe-dev4)to a different windows server(\\rrwin-ewhd04.ecomad.int). This shell... (4 Replies)
Discussion started by: SravsJaya
4 Replies

9. Shell Programming and Scripting

Windows batch script to Shell script

Hi everyone, I've below windows batch script which is used to filter the file contents line by line and assign the matched values to the variables in for loop. for /F "tokens=1,3 delims=:" %%A in (%LOG_DIR%\PM_IS_workflow_status.log) do ( set "ATTR_NAME=%%A" if /i "!ATTR_NAME!" EQU "Folder"... (1 Reply)
Discussion started by: Kathraji
1 Replies

10. Shell Programming and Scripting

C Shell script not run with Windows 10

Hi all, I have a script has been writing for Unix or Linux. Now I want to run under Windows 10. is give me Error: if:Badly formed number How to fix this please help *** This is a copy of a part of Script. set absolute_gap = 0 if ($min_p_to_p != "" && $min_p_to_p != "N/A" && $min_p_to_t... (5 Replies)
Discussion started by: dovo
5 Replies
PWD(1)							    BSD General Commands Manual 						    PWD(1)

NAME
pwd -- return working directory name SYNOPSIS
pwd [-LP] DESCRIPTION
pwd writes the absolute pathname of the current working directory to the standard output. The following options are available: -L If the PWD environment variable is an absolute pathname that contains neither "/./" nor "/../" and references the current directory, then PWD is assumed to be the name of the current directory. -P Print the physical path to the current working directory, with symbolic links in the path resolved. The default for the pwd command is -P. pwd is usually provided as a shell builtin (which may have a different default). EXIT STATUS
The pwd utility exits 0 on success, and >0 if an error occurs. SEE ALSO
cd(1), csh(1), ksh(1), sh(1), getcwd(3) STANDARDS
The pwd utility is expected to be conforming to IEEE Std 1003.1 (``POSIX.1''), except that the default is -P not -L. BUGS
In csh(1) the command dirs is always faster (although it can give a different answer in the rare case that the current directory or a con- taining directory was moved after the shell descended into it). pwd -L relies on the file system having unique inode numbers. If this is not true (e.g., on FAT file systems) then pwd -L may fail to detect that PWD is incorrect. BSD
October 30, 2003 BSD
All times are GMT -4. The time now is 01:37 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy