03-28-2017
Can you post the content of /opt/ca/SAP_Tooling/sql/self_monitoring/check_number_of_open_connections_database.sql If we can adjust that, then for sure you can get a total. If not, then if we can decipher it then we can write another bit to count them all.
Robin
10 More Discussions You Might Find Interesting
1. Post Here to Contact Site Administrators and Moderators
Hi guys!
I was wondering what the outcome was of your survey of a few months ago? One of the questions was if people were willing to pay for additional services like an own account, like username@unix.com with mail box, etc.
Sorry if I missed the results if you had already posted them.
Ivo (1 Reply)
Discussion started by: Ivo
1 Replies
2. Shell Programming and Scripting
Hi there
If I run a 'swap -l' on my solaris box, i get
swapfile dev swaplo blocks free
/dev/dsk/c1t0d0s1 54,65 8 67119560 65655144
/dev/dsk/c1t0d0s2 54,65 8 33119522 32655122
I wanted to run a for loop adding up the totals of each column 4 , excluding the... (2 Replies)
Discussion started by: hcclnoodles
2 Replies
3. Shell Programming and Scripting
I need some help with adding lines to file and substitute a pattern.
Ok I have a file:
#cat names.txt
name: John Doe
stationed: 1
name: Michael Sweets
stationed: 41
.
.
.
And would like to change it to:
name: John Doe
employed
permanently
stationed: 1-office (7 Replies)
Discussion started by: hemo21
7 Replies
4. Shell Programming and Scripting
I'm trying to add the paths of all the xml files in certain directories to an array. I want to use the array later in my code. Anyway, for some reason this isn't working. Any help would be appreciated.
Path_Counter=0
for result in "find * -name '*.xml'"; do
XmlPath="$result"
echo... (2 Replies)
Discussion started by: Fly_Moe
2 Replies
5. Shell Programming and Scripting
Here is one I am baffled with; I have not used unix for a while and now that I am back it has been fun remembering and I have enjoyed it, for the most past. this is in ksh.
I need to search in a file for the line with X1 and cut columns 20-25, put them into a variable, added them (dollar... (3 Replies)
Discussion started by: CougarMutt
3 Replies
6. Shell Programming and Scripting
Hello ,
When using vim, can ctag and cscope support recording search results and displaying the history results ? Once I jump to one tag, I can use :tnext to jump to next tag, but how can I display the preview search result? (0 Replies)
Discussion started by: 915086731
0 Replies
7. UNIX for Dummies Questions & Answers
Hi,
I am trying to use awk to do the following:
For a column:
5
3
4
2
7
I want to start with the first entry then add the second to the first, third to second ..etc:
5
8
12
14
21 (5 Replies)
Discussion started by: cosmologist
5 Replies
8. Shell Programming and Scripting
# echo '1 2 3 ' | awk -F' ' '{print NF}'
3
# echo '1:2:3:' | awk -F':' '{print NF}'
4 (1 Reply)
Discussion started by: lazycat79
1 Replies
9. Shell Programming and Scripting
Good morning all,
This is the file name in question OD_Orders_2019-02-19.csv
I am trying to create a bash script to read into files with yesterdays date on the file name while retaining the rest of the files name. I would like for $y to equal, the name of the file with a formula output with... (2 Replies)
Discussion started by: Ibrahim A
2 Replies
10. UNIX for Beginners Questions & Answers
I have an array in an external file, "array.txt", which contains:
char *testarray={"Zero", "One", "Two", "Three", "Four", "Five", "Six", "Seven", "Eight", "Nine"};I want to be able to add an element to this array, and have that element display, whenever I call it, without having to recompile... (29 Replies)
Discussion started by: ignatius
29 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)