FBSQL_CREATE_CLOB(3) 1 FBSQL_CREATE_CLOB(3)fbsql_create_clob - Create a CLOBSYNOPSIS
string fbsql_create_clob (string $clob_data, [resource $link_identifier])
DESCRIPTION
Creates a CLOB from the given data.
PARAMETERS
o $clob_data
- The CLOB data.
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 resource handle to the newly created CLOB, which can be used with insert and update commands to store the CLOB in the database.
EXAMPLES
Example #1
fbsql_create_clob(3) example
<?php
$link = fbsql_pconnect("localhost", "_SYSTEM", "secret")
or die("Could not connect");
$filename = "clob_file.txt";
$fp = fopen($filename, "rb");
$clobdata = fread($fp, filesize($filename));
fclose($fp);
$clobHandle = fbsql_create_clob($clobdata, $link);
$sql = "INSERT INTO CLOB_TABLE (CLOB_COLUMN) VALUES ($clobHandle);";
$rs = fbsql_query($sql, $link);
?>
SEE ALSO fbsql_create_blob(3), fbsql_read_blob(3), fbsql_read_clob(3), fbsql_set_lob_mode(3).
PHP Documentation Group FBSQL_CREATE_CLOB(3)
Check Out this Related Man Page
FBSQL_CLOSE(3) 1 FBSQL_CLOSE(3)fbsql_close - Close FrontBase connectionSYNOPSIS
bool fbsql_close ([resource $link_identifier])
DESCRIPTION
Closes the connection to the FrontBase server that's associated with the specified link identifier.
Using fbsql_close(3) isn't usually necessary, as non-persistent open links are automatically closed at the end of the script's execution.
PARAMETERS
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 TRUE on success or FALSE on failure.
EXAMPLES
Example #1
fbsql_close(3) example
<?php
$link = fbsql_connect("localhost", "_SYSTEM", "secret")
or die("Could not connect");
echo "Connected successfully";
fbsql_close($link);
?>
SEE ALSO fbsql_connect(3), fbsql_pconnect(3).
PHP Documentation Group FBSQL_CLOSE(3)
How can I get the results of a find back without the pathname
for example if i do
find ../../ -name \*.sql
i dont want to see
directory/directory/filename.sql
I only want to see filename.sql (3 Replies)
Hi,
sqlplus -s / <<EOF > /dev/null
insert into table1 (a1, a2, a3) values ('a',1,'b');
commit;
EOF
in the above code can i pass the values to the insert command from shell script like this:
insert into table1 (a1, a2, a3) values ('$a',$b,'$c');
If yes, how is it passed??
Any... (2 Replies)
Hi all,;)
i need to exexute OS commands from oracle prompt.
For that i did the following steps
1) created a java source called "Host".
2)created a pl/sql procedure called'Host_Command '.
3)issued the following statements
EXEC dbms_java.grant_permission( 'TMS','SYS:java.io.FilePermission',... (2 Replies)
Hi Guys,
Can someone help with this.
I have to find out a file name which calls the following sql script "abhishek_to_sdw.sql". In other words it contains a pattern like "abhishek_to_sdw.sql".
I have found out using "find" command that the file abhishek_to_sdw.sql is existing on the... (4 Replies)
How can I loose a part of the filename
I want to drop the “_<Number>.sql”
Below I have a listing of file names in a file
Eg :
CREDIT_DEL_033333.sql I want it to be CREDIT_DEL
ATM_DEBIT_CARD_0999999.sql I want it to be ... (3 Replies)
Hi,
I have a sql file which has CREATE and INSERT commands in it. Basically, inside this file, a table will be created and the data will be inserted into the table. I was wondering if there is a way for me to create directories from this file?
Thanks in advance (4 Replies)
Hi -
I am looking for a replacing a string in a in multiple *.sql files in directory with a new string without using a temporary file
Normally I can use sed command as below
for W in ls `FILE*.sql`
do
sed 's/OLD/NEW/g' $W > TEMPFILE.dat
mv TEMPFILE.dat $W
done
But Here in my... (9 Replies)
Hello friends,
I need to insert data from a file to another. I need this to form an sql query file which will consist of 50.000 INSERT INTO sentences.
my sql query file will consist of 50.000 times the below line consecutively:
insert into subscriber... (6 Replies)
Hello,
I created a sql file to create a Procedure, and it was successfully created.
I created a sql file to execute the procedure, and it did without any errors, but i dont see the data been updated.
The Execute procedure.sql script is:
BEGIN
set serveroutput on size 1000000
execute... (5 Replies)
Hi,
I have a directory nsk,
files a.sql, b.sql, c.sql, d.sql,
assuming that I have line 'INSERT ALL INTO abc' in a.sql and c.sql
I need to list a filename, line number and complete line which contains ''INSERT ALL INTO abc' irrespective of case.
also in my files mentioned 'INSERT ALL... (4 Replies)
hi! i made an sql script but i do not know how to just output all the lines that starts with an specific string. and that string, you will input it before i run the sql
for example:
INPUT NAME: JOHN
i just want to output lines that starts with JOHN (2 Replies)
hey i am using this code to connect to sql , store the value in variable and then
compare it with another variable after some time by executing the same query
but the desired result is not coming
#!/bin/bash
val=$(sqlplus -s rte/rted2@rel76d2 <<ENDOFSQL
set heading off
set feedback off... (11 Replies)
I want to print the filename
keyword="XXTNL_AVSKRIV2ING"
ftype="sql'
I wan to search the keyword in all the sql files and the output shoul dbe filename:count
grep -iwc "$keyword" *.$ftype | grep -v ":0$"
But the output does not dispaly the filename which contains space as... (4 Replies)
New to using sql server and unix, but say I have here /home/foo/file.txt
Can I use some kind of process to push that .txt into a sql server?
Or
Is there a sql server utility that can be configured to find a unix box and go into /home/foo/file.txt and slurp it up:)
Or is there any PC and... (5 Replies)