Hi:
Im trying to change the display setting from my Linux server to Linux workstation but a Refused connection by server appear.
The first task that I doing is to export the DISPLAY variable on my Linux Workstation so I tried to execute several X programs with the Refused Connection message.... (2 Replies)
I have a variable that is outputting a lot of space.
here has been 45 lines returned ...
how can I remove the spaces between the "been and the 45"
CODE:
fil_len=`wc -l < coshb.txt`
if ; then
cat coshb.txt | more
echo " "
echo "There has been ${fil_len} lines... (4 Replies)
I'll be reading user name and password from the person while running a shell
script so that he is authenticated.
The challenge here is to read the password variable without displaying on screen. Is there a way?
I presently do it displaying it on the screen as
echo " please enter your... (9 Replies)
I'm trying to open an xwindow on my Sun server. What am I doing wrong?
# echo $SHELL
/sbin/sh
#
# export DISPLAY=localhost:0.0
DISPLAY=localhost:0.0: is not an identifier
Thank you! (1 Reply)
Guys Quick help...
----------------------------
#!/usr/bin/ksh
db2 -x "select count(*) from ${SCHEMA}.EMP"> $HOME/count.dat
COUNT=`cat $HOME/count.dat`
echo Table Count: $COUNT
if ( $COUNT -eq 0 ); then
echo Record Count in Table is 0
exit 1
fi
echo Records Exist... (2 Replies)
Hi...
I m working on UNIX z/OS. Actually i have to pass the parameters from the JCL to java-db2 program thru PARM. I am able to pass the arguments but the problem occured is, it is throwing an exception while loading the db2 driver as 'Javaclassnotfound:com.ibm.db2.jcc.DB2Driver'... (0 Replies)
I need to pass a variable as a parameter from shell script into a DB2 database.
var=bhuk_1123_Q_11/22/09
select * from tbl1 where serial_id='$var';
I have tried executing it using
db2 -tvf scriptname
Somebody please help me out with this. It is throwing an error. Please tell me how... (2 Replies)
I've seen articles which say "export DISPLAY=<IP>:0" and others which say "export DISPLAY=<IP>:0.0". Can someone explain what the difference is?
TIA (4 Replies)
Hi All,
I have browsed through the forums for a similar topic, but there is no topic which explains about this problem, when the backend is DB2.
I want to assign the output of a select count(*) from tablename to a unix variable in a shell script.
I am using ksh.
The database used to... (3 Replies)
Hello
For this future package for community, i'd like to know your preference on this presented 'issue'.
Writing some commands which will display some strings, using another command supporting 3 strings to be supplied, i wonder how the 'default output' should look like.
Let me use a... (2 Replies)
Discussion started by: sea
2 Replies
LEARN ABOUT PHP
db2_pclose
DB2_PCLOSE(3) 1 DB2_PCLOSE(3)db2_pclose - Closes a persistent database connectionSYNOPSIS
bool db2_pclose (resource $resource)
DESCRIPTION
This function closes a DB2 client connection created with db2_pconnect(3) and returns the corresponding resources to the database server.
Note
This function is only available on i5/OS in response to i5/OS system administration requests.
If you have a persistent DB2 client connection created with db2_pconnect(3), you may use this function to close the connection. To avoid
substantial connection performance penalties, this function should only be used in rare cases when the persistent connection has become
unresponsive or the persistent connection will not be needed for a long period of time.
PARAMETERS
o $connection
- Specifies an active DB2 client connection.
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
Closing a persistent connection
The following example demonstrates a successful attempt to close a connection to an IBM DB2 i5/OS database.
<?php
$conn = db2_pconnect('', '', '');
$rc = db2_pclose($conn);
if ($rc) {
echo "Connection was successfully closed.";
}
?>
The above example will output:
Connection was successfully closed.
SEE ALSO db2_close(3), db2_pconnect(3).
PHP Documentation Group DB2_PCLOSE(3)