Hi
I want to get the a field from a SQL query into unix shell script variable. the whole situation is like this.
1. Opened a cursor to a table in DB2 databse.
2. Fetching individual rows with the help of cursor.
3. Each row has 4 fields.
I want each of the field in individual shell... (1 Reply)
Hi
I would like to know if there is a way to just have one ORACLE connection established, using which we can execute different queries and store the results under different variables.
For e.g the following uses to two silent ORACLE connection to store the result under two different... (4 Replies)
Can someone tell me why I'm getting error when I try to run this?
#!/bin/csh -f
source ~/.cshrc
#
set SQLPLUS = ${ORACLE_HOME}/bin/sqlplus
#
set count=`$SQLPLUS -s ${DB_LOGIN} << END
select count(1) from put_groups where group_name='PC' and description='EOD_EVENT' and serial_number=1;... (7 Replies)
I want to store the sql query output into a variable
#!/bin/ksh
ORACLE_SID=DB01;
export ORACLE_SID;
export FILE_PATH=/home/asg/Tmp
# Order Checking
echo " removing old files "
rm $FILE_PATH/Malformed_Order.txt
echo " Enter the Malformed Order ....!"
read orders
echo "Regrade... (5 Replies)
While assisting a forum member, I recommended running SQL/Plus in a coprocess (to make database connections and run a test script) for the duration of his script rather than starting/stopping it once for every row in a file he was processing.
I recalled I made a coprocess example for folks at... (2 Replies)
Hello everyone,
I have a RHEL 5 system and have been trying to get a batch of 3-4 scripts each in a separate variables and they are not working as expected.
I tried using following syntax which I saw a lot of people on this site use and should really work, though for some reason it doesn't... (3 Replies)
Hello,
I am very new to shell scripting and I am not sure of how best to handle the following scenario. I need to query a list of values from a table. I need to store those results and use them to selectively delete values in yet another table in a separate database. I do know how to store the... (3 Replies)
Hi,
I am new to linux...
How to Assign SQL Query Results to Variables in Linux,i want ti generate it in param files, Can anyone please explain me.
Ex: SQL> Select * from EMP;
O/P: Emp_No Emp_Name
1 AAA
2 BBB
3 CCC
and I want expected... (5 Replies)
Using ksh, I am using SQLPlus to execute a query with a filter using a string variable.
REPO_DB=DEV1
FOLDER_NM='U_nmalencia'
FOLDER_CHECK=$(sqlplus -s /nolog <<EOF
CONNECT user/pswd_select@${REPO_DB}
set echo off heading off feedback off
select subj_name
from subject
where... (5 Replies)
Discussion started by: nkm0brm
5 Replies
LEARN ABOUT PHP
mysqli_store_result
MYSQLI_STORE_RESULT(3) 1 MYSQLI_STORE_RESULT(3)mysqli::store_result - Transfers a result set from the last query
Object oriented style
SYNOPSIS
mysqli_result mysqli::store_result ([int $option])
DESCRIPTION
Procedural style
mysqli_result mysqli_store_result ([int $option])
Transfers the result set from the last query on the database connection represented by the $link parameter to be used with the
mysqli_data_seek(3) function.
PARAMETERS
o $
link -Procedural style only: A link identifier returned by mysqli_connect(3) or mysqli_init(3)
o $option
- The option that you want to set. It can be one of the following values:
Valid options
+------------------------------+---------------------------------------------------+
| Name | |
| | |
| | Description |
| | |
+------------------------------+---------------------------------------------------+
| | |
|MYSQLI_STORE_RESULT_COPY_DATA | |
| | |
| | Copy results from the internal mysqlnd buffer |
| | into the PHP variables fetched. By default, |
| | mysqlnd will use a reference logic to avoid copy- |
| | ing and duplicating results held in memory. For |
| | certain result sets, for example, result sets |
| | with many small rows, the copy approach can |
| | reduce the overall memory usage because PHP vari- |
| | ables holding results may be released earlier |
| | (available with mysqlnd only, since PHP 5.6.0) |
| | |
+------------------------------+---------------------------------------------------+
RETURN VALUES
Returns a buffered result object or FALSE if an error occurred.
Note
mysqli_store_result(3) returns FALSE in case the query didn't return a result set (if the query was, for example an INSERT state-
ment). This function also returns FALSE if the reading of the result set failed. You can check if you have got an error by checking
if mysqli_error(3) doesn't return an empty string, if mysqli_errno(3) returns a non zero value, or if mysqli_field_count(3) returns
a non zero value. Also possible reason for this function returning FALSE after successful call to mysqli_query(3) can be too large
result set (memory for it cannot be allocated). If mysqli_field_count(3) returns a non-zero value, the statement should have pro-
duced a non-empty result set.
NOTES
Note
Although it is always good practice to free the memory used by the result of a query using the mysqli_free_result(3) function, when
transferring large result sets using the mysqli_store_result(3) this becomes particularly important.
EXAMPLES
See mysqli_multi_query(3).
SEE ALSO mysqli_real_query(3), mysqli_use_result(3).
PHP Documentation Group MYSQLI_STORE_RESULT(3)