Hi all,
I am running an sql file from unix .In the log file along with the output
i am getting details of connecting and disconnecting sqlplus like
It saves the output with "Connected to Oracle8i Enterprise Edition Release
8.1.7.4.0 Connected as apps" and "disconnected... (1 Reply)
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)
Hi I am getting this error while connecting to sql through a shell script, whereas i am able to connect to sql directly.
It was working properly earlier, no clue why i am getting this.
Please find the log below:
FTP to <IP> completed Wed Apr 30 11:42:01 BST 2008
Program ended. Wed Apr 30... (1 Reply)
I've installed unixODBC and I would like to connect to a MS SQL (2005) database from a bash script. Can you post a code example?
Thank you! :D
J. (0 Replies)
Hi Experts:
I have a shell script that's kicked off by cron. Inside this shell script, I need to kick off two or more oracle sql scripts to process different groups of tables. And when both sql scripts are done, I will continue in the shell script to do other things like checking processing... (3 Replies)
Hi, I have a file which contains the following data
File.dat
<filenum>
W10
</filenum>
<hello>Heading </hello>
I need to replace the contents of file.dat with
database value inplace of W10
Can some one please tell me how to search this <filenum>
W10</filenum>
and replace... (1 Reply)
Hi All,
In a Shell scriipt with a SQL block I want to issue a query against a local DB and a remote DB on a remote server. The shell script is running locally.
This is how I connect to the local server. But I want the query to reference remote table in the join. Question can I specify a... (1 Reply)
I am connecting to sql databases through shell script. Databases that i am connecting will need password change every 60 days. This is according to our security policy and cannot be changed. But this is creating problem when connecting to Databases through shell script . To connect to oracle DB we... (2 Replies)
Hi All,
I want to run multiple sql queries and store the data in variable but i want to use sql command only once. Is there a way without running sql command twice and storing.Please advise.
Eg :
Select 'Query 1 output' from dual;
Select 'Query 2 output' from dual;
I want to... (3 Replies)
Discussion started by: Rokkesh
3 Replies
LEARN ABOUT OPENSOLARIS
ssignal
ssignal(3C) Standard C Library Functions ssignal(3C)NAME
ssignal, gsignal - software signals
SYNOPSIS
#include <signal.h>
void(*ssignal (int sig, int (*action)(int)))(int);
int gsignal(int sig);
DESCRIPTION
The ssignal() and gsignal() functions implement a software facility similar to signal(3C). This facility is made available to users for
their own purposes.
ssignal()
Software signals made available to users are associated with integers in the inclusive range 1 through 17. A call to ssignal() associates a
procedure, action, with the software signal sig; the software signal, sig, is raised by a call to gsignal(). Raising a software signal
causes the action established for that signal to be taken.
The first argument to ssignal() is a number identifying the type of signal for which an action is to be established. The second argument
defines the action; it is either the name of a (user-defined) action function or one of the manifest constants SIG_DFL (default) or SIG_IGN
(ignore). The ssignal() function returns the action previously established for that signal type; if no action has been established or the
signal number is illegal, ssignal() returns SIG_DFL.
gsignal()
The gsignal() raises the signal identified by its argument, sig.
If an action function has been established for sig, then that action is reset to SIG_DFL and the action function is entered with argument
sig. The gsignal() function returns the value returned to it by the action function.
If the action for sig is SIG_IGN, gsignal() returns the value 1 and takes no other action.
If the action for sig is SIG_DFL, gsignal() returns the value 0 and takes no other action.
If sig has an illegal value or no action was ever specified for sig, gsignal() returns the value 0 and takes no other action.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|MT-Level |Unsafe |
+-----------------------------+-----------------------------+
SEE ALSO raise(3C), signal(3C), attributes(5)SunOS 5.11 29 Dec 1996 ssignal(3C)