---------- Post updated at 01:21 PM ---------- Previous update was at 01:07 PM ----------
This parameter file will be used by above script to trigger this queries. While i am executing the query output is not being assigned to Array variables. Please help me with this..
Last edited by Franklin52; 08-16-2013 at 04:58 AM..
Reason: Please use code tags
Hi,
When i execute the below statement , the value is not getting stored in the variable.
AnneeExercice=`sqlplus $LOGSQL/$PASSWORDSQL << FIN >> $GEMOLOG/gemo_reprev_reel_data_ventil_$filiale.trc
SELECT bi09exercice
FROM bi09_scenario
WHERE bi09idfiliale=UPPER('de')
AND ... (1 Reply)
Hi All,
I need some help with arrays. I need to take input from the user for hostname, username and password until he enters .(dot) or any other character and store the values in the variable array.
I would further connect to the hostname using username and passwd and copy files from server to... (7 Replies)
hi
this is an example of code:
use strict;
use warnings;
open FILE, "/tmp/result_2";
my $regex="\\ Starting program ver. (.*)";
my $res="Program started, version <$1> - OK.\n";
while (<FILE>) {
if ($_ =~ /($regex)/) {
print "$res";
}
}
close FILE;
This finds $regex and print... (3 Replies)
Hello
Apologies for not having the most accurate of thread titles.. I'm using IBM Rational Synergy CM software. I use the Synergy commands in tandem with Unix commands.
I have a directory containing source code objects:
bash-3.00$ ccm ls *.fmb *.rdf *.pll *.mmb
cre_applications.fmb-1... (1 Reply)
I need to know how to store output from one command so that it can initiate another command.
chktraf -s | cut -c1-4
output would look like
321
142
256
342
123
Then if the value of the output = 0, then initiate next command.
if
then
for xx in 01 02 03 04 05 06 07 08 09 10
do
... (4 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)
Hi,
I have a script where I make a sqlplus connection. In the script I have multiple sql queries within that sqlplus connection. I want the result of the queries to be stored in shell variables declared earlier. I dont want to use procedures. Is there anyway else.
Thanks in advance..
Cheers (6 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)
Hi All,
I want to run multiple sql queries and store the data in variable but i want to use sql command only once. Is there a way without running sql command twice and storing.Please advise.
Eg :
Select 'Query 1 output' from dual;
Select 'Query 2 output' from dual;
I want to... (3 Replies)
Discussion started by: Rokkesh
3 Replies
LEARN ABOUT PHP
sqlitedatabase.query
SQLITEDATABASE.QUERY(3)SQLITEDATABASE.QUERY(3)SQLiteDatabase.query - Executes a query against a given database and returns a result handleSYNOPSIS
resource sqlite_query (resource $dbhandle, string $query, [int $result_type = SQLITE_BOTH], [string &$error_msg])
DESCRIPTION
resource sqlite_query (string $query, resource $dbhandle, [int $result_type = SQLITE_BOTH], [string &$error_msg])
Object oriented style (method): SQLiteResult SQLiteDatabase::query (string $query, [int $result_type = SQLITE_BOTH], [string
&$error_msg])
Executes an SQL statement given by the $query against a given database handle.
PARAMETERS
o $dbhandle
- The SQLite Database resource; returned from sqlite_open(3) when used procedurally. This parameter is not required when using the
object-oriented method.
o $query
- The query to be executed. Data inside the query should be properly escaped.
o $result_type
-The optional $result_type parameter accepts a constant and determines how the returned array will be indexed. Using SQLITE_ASSOC
will return only associative indices (named fields) while SQLITE_NUM will return only numerical indices (ordinal field numbers).
SQLITE_BOTH will return both associative and numerical indices. SQLITE_BOTH is the default for this function.
o $error_msg
- The specified variable will be filled if an error occurs. This is specially important because SQL syntax errors can't be fetched
using the sqlite_last_error(3) function.
Note
Two alternative syntaxes are supported for compatibility with other database extensions (such as MySQL). The preferred form is the
first, where the $dbhandle parameter is the first parameter to the function.
RETURN VALUES
This function will return a result handle or FALSE on failure. For queries that return rows, the result handle can then be used with func-
tions such as sqlite_fetch_array(3) and sqlite_seek(3).
Regardless of the query type, this function will return FALSE if the query failed.
sqlite_query(3) returns a buffered, seekable result handle. This is useful for reasonably small queries where you need to be able to ran-
domly access the rows. Buffered result handles will allocate memory to hold the entire result and will not return until it has been
fetched. If you only need sequential access to the data, it is recommended that you use the much higher performance
sqlite_unbuffered_query(3) instead.
CHANGELOG
+--------+---------------------------------+
|Version | |
| | |
| | Description |
| | |
+--------+---------------------------------+
| 5.1.0 | |
| | |
| | Added the $error_msg parameter |
| | |
+--------+---------------------------------+
NOTES
Warning
SQLite will execute multiple queries separated by semicolons, so you can use it to execute a batch of SQL that you have loaded from
a file or have embedded in a script. However, this works only when the result of the function is not used - if it is used, only the
first SQL statement would be executed. Function sqlite_exec(3) will always execute multiple SQL statements.
When executing multiple queries, the return value of this function will be FALSE if there was an error, but undefined otherwise (it
might be TRUE for success or it might return a result handle).
SEE ALSO sqlite_unbuffered_query(3), sqlite_array_query(3).
PHP Documentation Group SQLITEDATABASE.QUERY(3)