02-20-2002
Unix and databases
I had a person ask me if a Sql database can be run with Unix? I don't know can this be done? They only have Sql dba's and no oracle dba but want to use a Unix box????
8 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I have been asked to use ASP on UNIX and I have no idea what the limitations are. I have pages using ASP on NT with SQL7, is there an easy transition for my current pages to work on UNIX? Any help is much appreciated. THX (5 Replies)
Discussion started by: dkropolis
5 Replies
2. Cybersecurity
Help!
SCO Unix 5.05.
A relatievely new system went down on me today. I got the dreaded error:
Out of Space on Device (1/42).
I was able to clear up some space in the /tmp directory, however, when I try to boot, the system prompts me to go into single user mode and I get the... (2 Replies)
Discussion started by: gseyforth
2 Replies
3. UNIX for Dummies Questions & Answers
I want to check which databases are installed on my FreeBSD installation. This is what I did: pkg_info | grep mysql
How do I check all in one go whether also sqlite, postgresql, firebird is installed?
Thanks in advance (3 Replies)
Discussion started by: figaro
3 Replies
4. Solaris
I am facing problems with SVM installed on vmware workstation on intel platform. I have created replicas and a mirror volume using unmountable slices. But when I reboot my hardware I am not able to execute any SVM cmd's getting an error "there are no existing databases."
Below are o/p's of few... (0 Replies)
Discussion started by: rahul_11d
0 Replies
5. Shell Programming and Scripting
Hello,
I have two databases one is student_Name and another is student_Name1...Two tabled contain 200 records each..I found that near 30 names are entered in both databases..I would like to remove the duplicates..and i have to keep the name which is newly added..Please hepl how to remove... (7 Replies)
Discussion started by: Anjali_vee
7 Replies
6. UNIX for Dummies Questions & Answers
How can we compare query results from different databases using Unix diff command from command-line in Ab Initio tool? (1 Reply)
Discussion started by: eshalife
1 Replies
7. Shell Programming and Scripting
Hi Everyone,
I am new to DBA stuff. I wonder if anyone can help me. Task is that, I have 10 databases and need to take backups of all the databases using data pump in Unix/Linux, compress them using gzip and use cron to schedule the job twice a day.
Appreciate if anyone can help me in... (1 Reply)
Discussion started by: sreepriya0987
1 Replies
8. Programming
Hello all again,
How do you guys backup your MySQL databases?
I have a few programs that have an default back up that make an .sql file which is great but I also use OpenX which runs on PHP and has a database. That does not have an auto-back-up feature so do I just download the... (2 Replies)
Discussion started by: AimyThomas
2 Replies
LEARN ABOUT PHP
cubrid_lob2_write
CUBRID_LOB2_WRITE(3) 1 CUBRID_LOB2_WRITE(3)
cubrid_lob2_write - Write to a lob object.
SYNOPSIS
bool cubrid_lob2_write (resource $lob_identifier, string $buf)
DESCRIPTION
The cubrid_lob2_write(3) function reads as much as data from $buf and stores it to the LOB object. Note that this function can only append
characters now.
PARAMETERS
o $lob_identifier
-Lob identifier as a result of cubrid_lob2_new(3) or get from the result set.
o $buf
-Data that need to be written to the lob object.
RETURN VALUES
TRUE if the process is successful and FALSE for failure.
EXAMPLES
Example #1
cubrid_lob2_write(3) example 1
<?php
// test_lob (id INT, contents CLOB)
$conn = cubrid_connect("localhost", 33000, "demodb", "dba", "");
cubrid_execute($conn,"DROP TABLE if exists test_lob");
cubrid_execute($conn,"CREATE TABLE test_lob (id INT, contents CLOB)");
$req = cubrid_prepare($conn, "INSERT INTO test_lob VALUES(2, ?)");
$lob = cubrid_lob2_new($conn, 'CLOB');
$len = cubrid_lob2_write($lob, "Hello world");
cubrid_lob2_bind($req, 1, $lob);
cubrid_execute($req);
cubrid_disconnect($conn);
?>
Example #2
cubrid_lob2_write(3) example 2
<?php
// test_lob (id INT, contents CLOB)
$conn = cubrid_connect("localhost", 33000, "demodb", "dba", "");
cubrid_execute($conn,"DROP TABLE if exists test_lob");
cubrid_execute($conn,"CREATE TABLE test_lob (id INT, contents CLOB)");
$req = cubrid_prepare($conn, "INSERT INTO test_lob VALUES(1, ?)");
$lob1 = cubrid_lob2_new($conn, 'CLOB');
$len = cubrid_lob2_write($lob1, "cubrid php driver");
cubrid_lob2_bind($req, 1, $lob1);
cubrid_execute($req);
$req = cubrid_execute($conn, "select * from test_lob");
$row = cubrid_fetch_row($req, CUBRID_LOB);
$lob2 = $row[1];
cubrid_lob2_seek($lob2, 0, CUBRID_CURSOR_LAST);
$pos = cubrid_lob2_tell($lob2);
print "pos before write: $pos
";
cubrid_lob2_write($lob2, "Hello world");
$pos = cubrid_lob2_tell($lob2);
print "pos after write: $pos
";
cubrid_disconnect($conn);
?>
SEE ALSO
cubrid_lob2_read(3), cubrid_lob2_seek(3), cubrid_lob2_seek64(3), cubrid_lob2_tell(3), cubrid_lob2_tell64(3), cubrid_lob2_size(3),
cubrid_lob2_size64(3).
PHP Documentation Group CUBRID_LOB2_WRITE(3)