06-17-2008
Shell Script Please any one can help urgent
Hi,
I want to know shell script and pl/sql script for database monitoring to get alerts when users executing sql on production.
Please help me out ----------------
Thanks
Haasini
5 More Discussions You Might Find Interesting
1. HP-UX
Hi,
I am facing some problem in connecting the database(allbase) present on HP3000 through pro c programmin language that is being executed from HP 9000 machine could any one of you please help me!!!
when i run the code on HP9000 machine it is connecting to database(access the local host)... (0 Replies)
Discussion started by: ahmedwaseem2000
0 Replies
2. UNIX for Dummies Questions & Answers
While executing a ksh file with a input parameter in background like the following
bash-2.03$nohup fil.ksh 4 &
the nohup session is stopped.
The same ksh file while executed like
bash-2.03$fil.ksh 4
works fine.
I am trying the above in Solaris 5.8 in bash shell. Please let me... (2 Replies)
Discussion started by: kkna
2 Replies
3. Emergency UNIX and Linux Support
Hi,
this might sound somewhat weird, but I need a command to remove all packages on my machine with dpkg.
I know dpkg -l will list all packages, but the troublemaker isn't on the list, and the problems started as I updated the program :wall:.
Thanks in advance, I REALLY appreciate it :b: (8 Replies)
Discussion started by: pasc
8 Replies
4. Shell Programming and Scripting
Hi all,
I have 2 files, One file contain data like this
FHIT
CS
CHRM1
PDE3A
PDE3B
HSP90AA1
PTK2
HTR1A
ESR1
PARP1
PLA2G1B
These names are mentioned in the second file(Please see attached second file) as
# Drug_Target_X_Gene_Name:(Where X can be any number (1-1000) (1 Reply)
Discussion started by: manigrover
1 Replies
5. Shell Programming and Scripting
I am trying to write a shell script which takes an input file as an arguement in the terminal e.g. bash shellscriptname.sh input.txt. I would like for the file to be read line by line each time checking if the .txt file contains certain words or letters(validating the syntax). If the line being... (1 Reply)
Discussion started by: Gurdza32
1 Replies
LEARN ABOUT PHP
fbsql_read_blob
FBSQL_READ_BLOB(3) 1 FBSQL_READ_BLOB(3)
fbsql_read_blob - Read a BLOB from the database
SYNOPSIS
string fbsql_read_blob (string $blob_handle, [resource $link_identifier])
DESCRIPTION
Reads BLOB data from the database.
If a select statement contains BLOB and/or CLOB columns FrontBase will return the data directly when data is fetched. This default behav-
ior can be changed with fbsql_set_lob_mode(3) so the fetch functions will return handles to BLOB and CLOB data. If a handle is fetched a
user must call fbsql_read_blob(3) to get the actual BLOB data from the database.
PARAMETERS
o $blob_handle
- A BLOB handle, returned by fbsql_create_blob(3).
o $
link_identifier -A FrontBase link identifier returned by fbsql_connect(3) or fbsql_pconnect(3).If optional and not specified, the
function will try to find an open link to the FrontBase server and if no such link is found it will try to create one as if
fbsql_connect(3) was called with no arguments.
RETURN VALUES
Returns a string containing the specified BLOB data.
EXAMPLES
Example #1
fbsql_read_blob(3) example
<?php
$link = fbsql_pconnect("localhost", "_SYSTEM", "secret")
or die("Could not connect");
$sql = "SELECT BLOB_COLUMN FROM BLOB_TABLE;";
$rs = fbsql_query($sql, $link);
$row_data = fbsql_fetch_row($rs);
// $row_data[0] will now contain the blob data for the first row
fbsql_free_result($rs);
$rs = fbsql_query($sql, $link);
fbsql_set_lob_mode($rs, FBSQL_LOB_HANDLE);
$row_data = fbsql_fetch_row($rs);
// $row_data[0] will now contain a handle to the BLOB data in the first row
$blob_data = fbsql_read_blob($row_data[0]);
fbsql_free_result($rs);
?>
SEE ALSO
fbsql_create_blob(3), fbsql_read_clob(3), fbsql_set_lob_mode(3).
PHP Documentation Group FBSQL_READ_BLOB(3)