SQL Error "The cursor or statement is not available"

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Bash script - Print an ascii file using specific font "Latin Modern Mono 12" "regular" "9"

Hello. System : opensuse leap 42.3 I have a bash script that build a text file. I would like the last command doing : print_cmd -o page-left=43 -o page-right=22 -o page-top=28 -o page-bottom=43 -o font=LatinModernMono12:regular:9 some_file.txt where : print_cmd ::= some printing...

2. Shell Programming and Scripting

Source command returns error when it strikes conditional statement "ifeq"

Hello All, I am running source command on my project configuration file app.cfg which has conditional statements with make file systax E.g ifeq ($(APP_CMP_DIR),trunk). When I source this file it throws error: syntax error near unexpected token...

3. Shell Programming and Scripting

"if" statement based off "grep"

Hello, I am somewhat new to Linux/Unix. I am currently working on a shell script that is suppose to cat a file, grep the same file for a certain line, if that line is found save the file in a different location, else remove the file. This is a rough example of what I want. $Dating = False...

4. UNIX for Dummies Questions & Answers

What is the meaning of "-s" option in "if" statement?

Hi Guys, I'm sorry but I can't find answer for this, what is the meaning of -s option in "if" statement on unix scipting. Please see sample below: opath=/home/output for i in N1 N2 N3 N4 do echo $i if then grep $i $opath/N5_CRAI > $opath/N5_$i.crai chmod 777 $opath/N5_$i.crai ...

5. UNIX for Dummies Questions & Answers

Unix "look" Command "File too large" Error Message

I am trying to find lines in a text file larger than 3 Gb that start with a given string. My command looks like this: $ look "string" "/home/patrick/filename.txt" However, this gives me the following message: "look: /home/patrick/filename.txt: File too large" So, I have two...

6. Shell Programming and Scripting

awk command to replace ";" with "|" and ""|" at diferent places in line of file

Hi, I have line in input file as below: 3G_CENTRAL;INDONESIA_(M)_TELKOMSEL;SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL My expected output for line in the file must be : "1-Radon1-cMOC_deg"|"LDIndex"|"3G_CENTRAL|INDONESIA_(M)_TELKOMSEL"|LAST|"SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL" Can someone...

7. Shell Programming and Scripting

ksh93 if statement gives "not found" error

Why do I get the error on the second example?. This works: if ];then > echo "true" > else > echo "false" > fi true This doesn't, and gets the error shown: if ];then > b=1 > else > b=0 > fi -ksh93: line 2: . b=1: not found.

8. Shell Programming and Scripting

What "-a" operator means in "if" statement

Hi I am trying to figure out what the following line does, I work in ksh88: ] && LIST="$big $LIST" Not sure what "-a" means in that case. Thanks a lot for any advice -A

9. Red Hat

"if" and "then" statement is not working in RedHat

Dear experts, I'm trying to write a script to calculate the usage of Log Archive in a directory, so if it gets to a point where the directory size is 60%, then send out an FYI.. email. So if then it reaches to 80%, move the logs from that directory. I have written the script as follow but...

10. HP-UX

ERROR: more than one instance of overloaded function "vprintf" has "C" linkage

Hi people! I've got this own library: -------------------------------------------- Personal.h -------------------------------------------- #ifdef __cplusplus extern "C" { #endif #include <stdio.h> #include <stdarg.h> #include <string.h> ...

LEARN ABOUT PHP

cubrid_lob_get

CUBRID_LOB_GET(3)							 1							 CUBRID_LOB_GET(3)

cubrid_lob_get - Get BLOB/CLOB data

SYNOPSIS

       array cubrid_lob_get (resource  $conn_identifier, string  $sql)

DESCRIPTION

       cubrid_lob_get(3)  is  used  to	get  BLOB/CLOB	meta  info from CUBRID database, CUBRID gets BLOB/CLOB by executing the SQL statement, and
       returns all LOBs as a resource array. Be sure that the SQL retrieves only one column and its data type is BLOB or CLOB.

	Remember to use cubrid_lob_close(3) to release the LOBs if you don't need it any more.

PARAMETERS

	      o $conn_identifier
		-Connection identifier.

	      o $sql
		-SQL statement to be executed.

RETURN VALUES

	Return an array of LOB resources, when process is successful.

       FALSE, when process is unsuccessful.

EXAMPLES

       Example #1

	      cubrid_lob_get(3) example

	      <?php
	      $conn = cubrid_connect ("localhost", 33000, "demodb", "dba");

	      cubrid_execute($conn,"DROP TABLE if exists doc");
	      cubrid_execute($conn,"CREATE TABLE doc (id INT, doc_content CLOB)");
	      cubrid_execute($conn,"INSERT INTO doc VALUES (5,'hello,cubrid')");

	      $lobs = cubrid_lob_get($conn, "SELECT doc_content FROM doc WHERE id=5");
	      echo "Doc size: ".cubrid_lob_size($lobs[0])." bytes";
	      cubrid_lob_export($conn, $lobs[0], "doc_5.txt");
	      cubrid_lob_close($lobs);
	      cubrid_disconnect($conn);
	      ?>

SEE ALSO

       cubrid_lob_close(3), cubrid_lob_size(3), cubrid_lob_export(3), cubrid_lob_send(3).

PHP Documentation Group 													 CUBRID_LOB_GET(3)

UNIX for Dummies Questions & Answers