CUBRID_IS_INSTANCE(3) 1 CUBRID_IS_INSTANCE(3)cubrid_is_instance - Check whether the instance pointed by OID existsSYNOPSIS
int cubrid_is_instance (resource $conn_identifier, string $oid)
DESCRIPTION
The cubrid_is_instance(3) function is used to check whether the instance pointed by the given $oid exists or not.
PARAMETERS
o $conn_identifier
-Connection identifier.
o $oid
-OID of the instance that you want to check the existence.
RETURN VALUES
1, if such instance exists;
0, if such instance does not exist;
-1, in case of error
EXAMPLES
Example #1
cubrid_is_instance(3) example
<?php
$conn = cubrid_connect("localhost", 33000, "demodb");
$sql = <<<EOD
SELECT host_year, medal, game_date
FROM game
WHERE athlete_code IN
(SELECT code FROM athlete WHERE name='Thorpe Ian');
EOD;
$req = cubrid_execute($conn, $sql, CUBRID_INCLUDE_OID);
$oid = cubrid_current_oid($req);
$res = cubrid_is_instance ($conn, $oid);
if ($res == 1) {
echo "Instance pointed by $oid exists.
";
} else if ($res == 0){
echo "Instance pointed by $oid doesn't exist.
";
} else {
echo "error
";
}
cubrid_disconnect($conn);
?>
The above example will output:
Instance pointed by @0|0|0 doesn't exist.
SEE ALSO cubrid_drop(3), cubrid_get_class_name(3).
PHP Documentation Group CUBRID_IS_INSTANCE(3)
Check Out this Related Man Page
CUBRID_LOCK_WRITE(3) 1 CUBRID_LOCK_WRITE(3)cubrid_lock_write - Set a write lock on the given OIDSYNOPSIS
bool cubrid_lock_write (resource $conn_identifier, string $oid)
DESCRIPTION
The cubrid_lock_write(3) function is used to put write lock on the instance pointed by the given $oid.
PARAMETERS
o $conn_identifier
-Connection identifier.
o $oid
-OID of the instance that you want to put write lock on.
RETURN VALUES
TRUE, when process is successful.
FALSE, when process is unsuccessful.
EXAMPLES
Example #1
cubrid_lock_write(3) example
<?php
$conn = cubrid_connect("localhost", 33000, "demodb", "dba");
@cubrid_execute($conn, "DROP TABLE foo");
cubrid_execute($conn, "CREATE TABLE foo(a int AUTO_INCREMENT, b set(int), c list(int), d char(10))");
cubrid_execute($conn, "INSERT INTO foo(a, b, c, d) VALUES(1, {1,2,3}, {11,22,33,333}, 'a')");
cubrid_execute($conn, "INSERT INTO foo(a, b, c, d) VALUES(2, {4,5,7}, {44,55,66,666}, 'b')");
$req = cubrid_execute($conn, "SELECT * FROM foo", CUBRID_INCLUDE_OID);
cubrid_move_cursor($req, 1, CUBRID_CURSOR_FIRST);
$oid = cubrid_current_oid($req);
cubrid_lock_write($conn, $oid);
$attr = cubrid_col_get($conn, $oid, "b");
var_dump($attr);
cubrid_put($conn, $oid, "b", array(2, 4, 8));
$attr = cubrid_col_get($conn, $oid, "b");
var_dump($attr);
cubrid_close_request($req);
cubrid_disconnect($conn);
?>
The above example will output:
array(3) {
[0]=>
string(1) "1"
[1]=>
string(1) "2"
[2]=>
string(1) "3"
}
array(3) {
[0]=>
string(1) "2"
[1]=>
string(1) "4"
[2]=>
string(1) "8"
}
SEE ALSO cubrid_lock_read(3).
PHP Documentation Group CUBRID_LOCK_WRITE(3)
hello,
How to search a Word in a shell file and if that exists echo that the word exists and stop that operation and if that doesn't exists then echo word not found.
Thanks in advance.
Bye (4 Replies)
sample code as following:
test_sql(){
#test#echo test_sql
str=`$ORACLE_BIN/sqlplus -s $user/$passwd <<EOM
set verify off
set heading off
set feedback off
#--------start pl/sql
{
DECLARE
CURSOR pah_cs IS
select id from table
where letter = 'abcd';... (6 Replies)
Hi all,
Sorry about this i'm sure this is a very silly question hence an easy answer but:
I'm trying to write a script, part of which I want to check if a directory exists, if it doesn't then create it.
Thanks for your help
Tez (3 Replies)
gents
i need to look for a file with the latest date ... to make it clearer, here's what it looks like:
/afc/data/EOD/Eoddev/Enqueue/Devices/Processed/060920212734/CDAuthorisedSet_0_7408.xml
/afc/data/EOD/Eoddev/Enqueue/Devices/Processed/060920214314/CDAuthorisedSet_0_7409.xml... (3 Replies)
i was trying to compile a c program and got the error below. i need help on how to resolve this
$ make -ef putput
`if ; then echo getinf.awk ; else echo getora.awk;fi` EI.sql
`if ; then echo esql -static ; else echo esqlo8i;fi` -O -I. -c EI`if ; then echo .ec; else echo... (4 Replies)
Hi
This will be useful who is looking for checking the files in a directory
#chmod 777 /cronacle/tools/teradata/opo/bin/file_check.sh
SUBJECT=`echo "File Not Found"`
SUBJECT1=`echo "File Found"`
#RECIPIENT=Madhu.Reddy@ge.com
cd /cronacle/tools/teradata/opo/bin
file_list=attach.sh
if
... (3 Replies)
Unix prompt
=========
echo "Enter the query"
read q
==========
User has entered :
SELECT * FROM employee
=====================
Now the problem starts..
echo $q
Output: SELECT "all files names in the PWD" FROM employee
================================================
... (5 Replies)
Hi Guys,
First time in scripting & first time here...:D
I need help in this situation -
My requirements is:
I have a list e.g.
list=`echo ls -l *` OR
list=`sql.... select emp_id from employee ...`
The Input is:
ls -l OR emp_id
A 4567
B 2231
C ... (2 Replies)
Hi. I'd like to have an IF-Then-Else statement where I can check to see if a file exists? We have the Bourne Shell by default. I'm looking for the syntax to do something like this:
if myfile.txt exists then
...my code
else
...my code
end if
Any help would be greatly... (5 Replies)
Hi,
I am trying to write a script which checks if any file exists with "*.log" or "*.out" in Directory
below is the code
#------------------
path=/abd/xyz/
if ; then
echo "Good"
else
echo "Failure"
fi
#--------------------------
its always going to else part and printing... (8 Replies)
Hi friends,
I am trying to check if the two files i am expecting are created in a specific location.
if both files does not exist, do an echo
if -a ]; then
echo "files not found"
fi
It gives me the following message:
bash: Please help! :) (3 Replies)
Although i tried multiple option i couldn't find a way to get the rigt ouput.
Say i have the following data
cat file.txt
C request
C response
C request
C response
The output should look like (9 Replies)
I tried executing set of queries from shell script but not able to capture the input query in the log file,but the input query is not displayed along with output. Only the outputs are being captured in the log file. Is there a way to capture the input query along with the corresponding input?? (8 Replies)
hi
i wanted to check if the file exist or not(multiple files)
DIRE=/home/V478
if ;
then
echo "file present"
else
echo "file not present"
fi
But i am getting the error as
: [: unexpected operator/operand (3 Replies)
I need to check whether a file exists and has been changed.
The file should contain a specific string. The file should also have been changed within the last ten seconds.
How do I do that? (3 Replies)