Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

how to connect DB from batch script?

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting how to connect DB from batch script?
# 1  
Old 07-31-2012
how to connect DB from batch script?
1. run few scripts from windows to access unix environment.

scripts will have
1. login to putty
2. connect to server with another set of credentials ( Here, user input is required for password as pass word generated randomly by RSA token)
3. connect server2 with another set of credentials
4. connect DB.

Step1 done as like below

SET /p userin=Please enter your full name:
SET /p pasw=Please enter your password:

cd "C:\Documents and Settings\All Users\Desktop"
start putty.exe -ssh %username%@192.168.210.246 -pw %pasw%

how to connect next set of servers.. can u pls give me an idea through scripts
# 2  
Old 07-31-2012
putty is a graphical program and not meant to be run noninteractively.

The same people who made putty made plink, a batch-based equivalent to putty which is.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

SFTP or scp with password in a batch script without using SSH keys and expect script

Dear All, I have a requirement where I have to SFTP or SCP a file in a batch script. Unfortunately, the destination server setup is such that it doesn't allow for shell command line login. So, I am not able to set up SSH keys. My source server is having issues with Expect. So, unable to use... (5 Replies)
Discussion started by: ss112233
5 Replies

2. Shell Programming and Scripting

Batch script to execute shell script in UNIX server

Hi team, My requirement is to transfer pdf files from windows machine to unix server and then from that unix server we should sftp to another server. I have completed the first part i.e From windows to using to unix server with the help of psftp.exe code: psftp user@host -pw password <... (1 Reply)
Discussion started by: bhupeshchavan
1 Replies

3. 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

4. Shell Programming and Scripting

Dos batch script to execute unix shell script

Can anyone help me with a dos batch script to execute a shell script residing in an unix server. I am not able to use ssh. Thanks in advance (2 Replies)
Discussion started by: Shri123
2 Replies

5. Shell Programming and Scripting

Executing a batch of files within a shell script with option to refire the individual files in batch

Hello everyone. I am new to shell scripting and i am required to create a shell script, the purpose of which i will explain below. I am on a solaris server btw. Before delving into the requirements, i will give youse an overview of what is currently in place and its purpose. ... (2 Replies)
Discussion started by: goddevil
2 Replies

6. Windows & DOS: Issues & Discussions

help with batch script

I have a file named xyz.txt with the contents eg: abc/pluto/tag/ver_1.0(b0123) abc/pippo/tag/ver_1.0(b0124) . and so on I need a script which read one by one the enteries from the file xyz.txt create folders pluto/ver_1.0(b0123) and pippo/ver_1.0(b0124) ans so on and run a command svn... (1 Reply)
Discussion started by: nerd1976
1 Replies

7. 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

8. Shell Programming and Scripting

Running a BATCH script from my korn script with multiparameters

I've this BATCH script to run from my korn script... The command is /usr/local/BATCH/runBatch.sh PARAM1 'PARAM2 -PARAM21 PARAM22' (runBatch takes parameter 1 = PARAM1 parameter 2 = 'PARAM2 -PARAM21 PARAM22' ) If i run this command from command line it just runs fine... ... (7 Replies)
Discussion started by: prash184u
7 Replies

9. Shell Programming and Scripting

how to execute a batch script from shell script

Hi, I am new to shell scripting. Can anyone tell how to invoke a batch program from my shell script thnx (1 Reply)
Discussion started by: lakshmis10
1 Replies

10. Shell Programming and Scripting

how to convert unix .ksh script to windows .batch script

I am using awk in my .ksh script but when I am trying to run in windows its not recognising awk part of the ksh script , even when I changed it to gawk it does not work, this is how my .ksh and .bat files look like. thanx. #!/bin/ksh egrep -v "Rpt 038|PM$|Parameters:|Begin |Date: |End... (1 Reply)
Discussion started by: 2.5lt V8
1 Replies
Login or Register to Ask a Question