|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Handling SQL prompt through Perl expect module
Post 302481241 by arun_maffy on Friday 17th of December 2010 03:43:42 AM
12-17-2010
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I'm using KSH and calling a SQL statement inside my script which returns more than 1 record.
Result=`sqlplus -s $DB_USER/$DB_PWD@$DB_STRING <<END
set echo off
set head off
spool junk.txt
select Name from abc where job = 'Manager';
spool off
exit;
END`
echo $Result
The above... (5 Replies)
Discussion started by: decci_7
5 Replies
2. Shell Programming and Scripting
Hi,
I am using isql and putting the output in a file in a shell script in Linux.
However in my output i am getting the banner and a SQL prompt(at the start and the end of query output)
+---------------------------------------+
| Connected! |
| ... (6 Replies)
Discussion started by: lifzgud
6 Replies
3. Shell Programming and Scripting
Hi
Thanks for this amazing forum first, I've been searching answers in it for problems that I've encountered at work.
The only problem I haven't been able to find a fix for, is a ever waiting for prompt problem in Expect when encounter a $ prompt.
I usually set the timeout to -1 cause the... (2 Replies)
Discussion started by: Ikaro0
2 Replies
4. Shell Programming and Scripting
I have an Expect script which works very well. It logs into my remote routers and runs some commands and then to the next until finished. I need two things, first I need to save the output to a file from where the log_user 1 begins.
expect << EOF
set timeout 15
#set var "exit "
match_max... (1 Reply)
Discussion started by: numele
1 Replies
5. Shell Programming and Scripting
Hi,
I have got the success in running script using expect module.It is connecting to the remote host but not able to change the password.Please let me know how I can finish this task.Thanks in Advance!!
OUTPUT:
Server1 $ passwd
Changing password for dbaguest
Old password:
+ read line
Main... (0 Replies)
Discussion started by: manish_1678
0 Replies
6. Shell Programming and Scripting
All,
Is it possible to call a subroutine from the perl expect module after logging to a system that is within the same program. My situation is I need to run a logic inside a machine that I'm logging in using the expect module, the logic is also available in the same expect program.
Thanks,... (5 Replies)
Discussion started by: arun_maffy
5 Replies
7. Shell Programming and Scripting
Good Day Everyone,
I was hoping to get a little insight into an expect script that I've written.
Basically we have this expect script to perform an sftp upload, key authentication is not an option, and sftp is the only method supported by our vendor, thus the need for this.
I want to be... (3 Replies)
Discussion started by: thaller
3 Replies
8. Shell Programming and Scripting
Hi.
Here is beginning of my script
#!/usr/local/bin/expect --
set timeout 15
spawn /usr/local/account.sh -n modify
expect "Password:" {send "mypassword\r"}
But due to some terminal control sequences (or something else, dunno exactly) my password prompt is looking like this:
and expect... (3 Replies)
Discussion started by: urello
3 Replies
9. Shell Programming and Scripting
Hi guys,
I am trying to install a software which is a shell script. I am using expect to do the silent installation.
There is a strange line during the installation of the software like this below. The prompt goes to the next line.
ENTER AN ABSOLUTE PATH, OR PRESS <ENTER> TO ACCEPT THE... (0 Replies)
Discussion started by: kapkap
0 Replies
10. Shell Programming and Scripting
I have a script that does an SSH into a remote node. It should expect the prompt and send the password.
#!/usr/bin/expect
set user ;
set pass ;
spawn ssh $user@E-Internal
expect {
-re "RSA key fingerprint" {send "yes\r"}
timeout... (1 Reply)
Discussion started by: Junaid Subhani
1 Replies
LEARN ABOUT REDHAT
kas_quit
KAS_QUIT(8) AFS Command Reference KAS_QUIT(8) NAME
kas_quit - Leaves interactive mode SYNOPSIS
quit [-help] q [-h] DESCRIPTION
The kas quit command ends interactive mode, severing the authenticated connection to one or more Authentication Server processes and returning the issuer to the normal shell prompt. This command is operative only during interactive mode, so omit the kas command suite name from the command line. OPTIONS
-help Prints the online help for this command. All other valid options are ignored. EXAMPLES
The following example demonstrates how the normal command shell prompt returns when the issuer leaves interactive mode. ka> quit % PRIVILEGE REQUIRED
None, and no password is required. SEE ALSO
kas(8), kas_interactive(8) COPYRIGHT
IBM Corporation 2000. <http://www.ibm.com/> All Rights Reserved. This documentation is covered by the IBM Public License Version 1.0. It was converted from HTML to POD by software written by Chas Williams and Russ Allbery, based on work by Alf Wachsmann and Elizabeth Cassell. OpenAFS 2012-03-26 KAS_QUIT(8)