CUBRID_GET_QUERY_TIMEOUT(3) 1 CUBRID_GET_QUERY_TIMEOUT(3)cubrid_get_query_timeout - Get the query timeout value of the requestSYNOPSIS
int cubrid_get_query_timeout (resource $req_identifier)
DESCRIPTION
The cubrid_get_query_timeout(3) function is used to get the query timeout of the request.
PARAMETERS
o $req_identifier
-Request identifier.
RETURN VALUES
Success: the query timeout value of the current request. Units of msec.
Failure: FALSE
EXAMPLES
Example #1
cubrid_get_query_timeout(3) example
<?php
$host = "localhost";
$port = 33000;
$db = "demodb";
$conn =
cubrid_connect_with_url("CUBRID:$host:$port:$db:::?login_timeout=50000&query_timeout=5000&disconnect_on_query_timeout=yes");
$req = cubrid_prepare($conn, "SELECT * FROM code");
$timeout = cubrid_get_query_timeout($req);
var_dump($timeout);
cubrid_set_query_timeout($req, 1000);
$timeout = cubrid_get_query_timeout($req);
var_dump($timeout);
cubrid_close($conn);
?>
The above example will output:
int(5000)int(1000)SEE ALSO cubrid_set_query_timeout(3).
PHP Documentation Group CUBRID_GET_QUERY_TIMEOUT(3)
Check Out this Related Man Page
CUBRID_AFFECTED_ROWS(3) 1 CUBRID_AFFECTED_ROWS(3)cubrid_affected_rows - Return the number of rows affected by the last SQL statementSYNOPSIS
int cubrid_affected_rows ([resource $conn_identifier])
DESCRIPTION
int cubrid_affected_rows ([resource $req_identifier])
The cubrid_affected_rows(3) function is used to get the number of rows affected by the SQL statement (INSERT, DELETE, UPDATE).
PARAMETERS
o $conn_identifier
-The CUBRID connection. If the connection identifier is not specified, the last link opend by cubrid_connect(3) is assumed.
o $req_identifier
- Request Identifier, could be returned from either cubrid_prepare(3) or cubrid_execute(3). If the request identifier is not spec-
ified, the last identifier requested by cubrid_prepare(3) or cubrid_execute(3) is assumed.
RETURN VALUES
Number of rows affected by the SQL statement, when process is successful.
-1, when SQL statement is not INSERT, DELETE or UPDATE.
FALSE, when the request identifier is not specified, and there is no last request.
EXAMPLES
Example #1
cubrid_affected_rows(3) example
<?php
$conn = cubrid_connect('localhost', 33000, 'demodb', 'dba', '');
cubrid_execute($conn, "DROP TABLE IF EXISTS cubrid_test");
cubrid_execute($conn, "CREATE TABLE cubrid_test (d varchar)");
$sql_stmt = "INSERT INTO cubrid_test(d) VALUES('php-test')";
$req = cubrid_prepare($conn, $sql_stmt);
for ($i = 0; $i < 10; $i++) {
cubrid_execute($req);
}
cubrid_commit($conn);
$req = cubrid_execute($conn, "DELETE FROM cubrid_test WHERE d='php-test'", CUBRID_ASYNC);
var_dump(cubrid_affected_rows());
var_dump(cubrid_affected_rows($conn));
var_dump(cubrid_affected_rows($req));
cubrid_disconnect($conn);
print "done!";
?>
The above example will output:
Rows deleted: 5
SEE ALSO cubrid_execute(3).
PHP Documentation Group CUBRID_AFFECTED_ROWS(3)
hi,
i am reading a string values from a file.the values are
2000
20000
300
10
5000
now retrieving each value one by one and printing if they are greater than 1000.
i use this statement for the same (in perl script)
if ($_ gt 1000){
print $_
}
but its now prininting all... (3 Replies)
hi
i have a file contains data
Line timeout:
START->SIGNON_REPLY,
SIGNON_REPLY->SIGNON,
Received SOT req
SOT request:
SIGNON->SOT_REPLY,
SOT_REPLY->DATA_RECEIVE,
DATA_RECEIVE->EOD,
i need to write into one line , separated by commas
please help
thanks
Satya (2 Replies)
i am using Putty to do ssh to all the unix nodes that we have in our work environment. it is very strange that all my network connections will timeout quickly in 10 mins, it can either be a putty connection, sqlplus or toad. is there some setting that can help to prevent this. please let me know... (3 Replies)
Hi
I have AIX 5.3
I want schedule a cronjob that can remove first 5000 lines every weekend.
Is anybody know the commmand to remove first 5000 lines from unix file?
Any Help will be Greatly appreciated.
Thanks,
Vishal (5 Replies)
hello..
I have big file and so far I was able to shink it and make smaller with certains values that I need..
vendor1|2000|1
vendor2|1000|1
vendor2|5000|1
vendor2|500|2
vendor3|1000|2
vendor3|500|3
vendor4|500|3
Vendor5|500|1
vendor6|500|3
Vendor7|1000|1
Vendor8|1000|774... (3 Replies)
Recently the network auditor found a security hole at port 50000. The port 50000 is used by db2.
When I enter command "netstat -Aan |grep 50000", it showed some established connections and are all db2 processes.
I have asked the application team and they answered that the port 50000 connection... (2 Replies)
Hi Frndz,
I have req in which i need to run the query stored in some file and then store the resultset of the query in some other file.
PFB the code i have written:
#----Start job log---
SQLLOG='/opt/app/vertica2/cdr_dev/logs/conn_orac_db.log'
ORA_USER='abc'
ORA_PASSWD='xyz'
... (7 Replies)
I'm converting decimal to integer with bc, and I'd like to assign the integer output from bc to a variable 'val'.
E.g. In the code below: If b is 5000.000, lines 6 and 8 will output:
5000
(5000.000+0.5)/1 | bc
I'd like val to take the value 5000 though, rather than 5000.000
Does someone... (3 Replies)