06-03-2010
No. 'a1.sql' has commit at the end
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
hi everybody...
can anyone help me in executing the .sql file with shell scripting....
thanx in advance (2 Replies)
Discussion started by: abuanas
2 Replies
2. Shell Programming and Scripting
Hi-
I am trying to achieve the following in a script so I can schedule it on a cron job. I am fairly new to the unix environment...
I have written a shell script that reads a flat file and loads the data into an Oracle table (Table1) via SQLLDR. This Works fine. Then, I run a nested insert... (5 Replies)
Discussion started by: rajagavini
5 Replies
3. Shell Programming and Scripting
Hi people, i need youre help on this.
I need to create an Shell SCript to list in a directory some sql files and then execute them one by one .
Also i need to have Logs from the executed Sql's to send to our costummers.
Can anyone help me on this
Regards,
osramos (2 Replies)
Discussion started by: osramos
2 Replies
4. Programming
hi all,
I'm new to shell scripting, i want to know how to use the sql statements from the shell script? is there any documents or pdf to learn from the begining? plese provide me some useful links on the same.
Thanks all in advance..,:b: (3 Replies)
Discussion started by: vij_krr
3 Replies
5. Shell Programming and Scripting
Hi!
I would like to do a single connection to sqlplus and execute some querys.
Actually I do for every query one connection to database
i.e
echo 'select STATUS from v$instance;
exit' > $SQL_FILE
sqlplus user/pass@sid @$SQL_FILE > $SELECT_RESULT
echo 'select VERSION from v$instance;... (6 Replies)
Discussion started by: guif
6 Replies
6. Shell Programming and Scripting
Hi All,
Am in need of some inputs to overcome the following problem,
A tar file(/var/execute/scripts/ that contains different types of scripts(may be perl,shell, python etc...). I have written a shell script which is located @ /var/execute.sh to untar the file in some location say... (1 Reply)
Discussion started by: SMNK
1 Replies
7. UNIX and Linux Applications
using sqlplus I want to execute a .sql script that has dbms_output statments in rhe script. I want to write the dbms_output statements from .sql file to a log file. is this possible. thanks
any help would be appreciated
:wall: (1 Reply)
Discussion started by: TRS80
1 Replies
8. Shell Programming and Scripting
hello forum ,
I am new to shell scripting. as part of my assignment i have to execute a sql querry from the shell script. please help me.
example.
sql queerry:db2 "select emp_id from tsble emp".
i have to execute the above querry from the script.
advance thanks to forum
Siva ranganath (1 Reply)
Discussion started by: workforsiva
1 Replies
9. Shell Programming and Scripting
Hi All,
I want some help in writing a shell script which will be in the below form:
A logical representation of shell scripts:
->Shell scripts start
->Connect to database
->Execute a sql and store the output in a cursor(need to know is there any concept of cursor in unix)
->Using a loop... (2 Replies)
Discussion started by: Chitragupta
2 Replies
10. Shell Programming and Scripting
Hi Experts,
Need your support.
Not able to use sql query alias in shell script.
Could you please help me in finding right way to use alias with sql query in shell script.
Below is the code i am using.
#!/bin/bash
sqlplus -s abc/abc@abc << EOF> bcd.csv
set trimspool on
select zone_id... (4 Replies)
Discussion started by: as7951
4 Replies
LEARN ABOUT DEBIAN
pam-script
PAM-SCRIPT(7) Miscellaneous Information Manual PAM-SCRIPT(7)
NAME
pam-script - a PAM module that can invoke scripts within the PAM stack.
SYNOPSIS
pam-script.so [onerr=(success|fail)][dir=/some/path/]
DESCRIPTION
pam-script allows you to execute scripts during authorization, passwd changes, and on session opening or closing.
Such scripts can perform necessary tasks or influence the outcome of the PAM stack. For example, if the following entry was included in
pam.conf
sshd auth required pam_script
then if the script, pam_script_auth, exits with a non-zero value this would cause the user to be denied SSH access to the machine.
OPTIONS
A summary of options is included below.
onerr=(success|fail)
the default behavior if the module can not find or execute the script. The default is to fail if the option is not given.
dir=/some/path/
where to find the pam-scripts to invoke for each of the various module-types as described below. The default is dir=/usr/share/lib-
pam-script if not given.
List of scripts
pam_script_auth
Executed under auth which handles the authentication stage of establishing the user via some challenge-response (i.e. username/pass-
word)
pam_script_acct
invoked under account module-type for non-authentication based account management.
pam_script_passwd
invoked under passwd for changing the password tokens.
pam_script_ses_open
invoked when a session is first opened.
pam_script_ses_close
run after a session is first closed.
All the scripts will be passed several environment variables: PAM_USER, PAM_RUSER, PAM_RHOST, PAM_SERVICE, PAM_AUTHTOK, PAM_TTY, and
PAM_TYPE referring to the module-type. The pam_script.so arguments in the pam.conf will be passed on the command line, which can be
used to modify the script behavior.
FILES
/lib/security/pam_script.so - the PAM module
/usr/share/libpam-script - where the scripts should be placed by default
VERSION
pam-script 1.1.5
SEE ALSO
PAM(7) and the PAM "The System Administrators' Guide"
AUTHOR
pam-script was written by Jeroen Nijhof <jeroen@jeroennijhof.nl>
with some additions and modifications by R.K. Owen, Ph.D. <rkowen@nersc.gov>.
This manual page was written by R.K. Owen <rkowen@nersc.gov>,
for the Debian project (but may be used by others).
August 22, 2007 PAM-SCRIPT(7)