09-03-2009
No quotes when double quotes
When I used double quotes, the grep statement translates without any quotes.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
HI guys
I need to store the output of a sql query in a variable, can you tell me how to do that
eg) select count(*) from s_escl_req
$count = count(*) from s_escl_req
how would i store the count(*) from the sql statement in a variable called $count.
thanks (3 Replies)
Discussion started by: ragha81
3 Replies
2. Shell Programming and Scripting
Hi Gurus,
I have a requirement of writting the shell script where it should ask me two values
FND_TOP=/d02/app/oracle/xxx/fnd/11.5.0
CDCRM_TOP=/d02/app/oracle/xxx/cdcrm/11.5.0
and then keep these values stored as variables for the execution of rest of the script.
Because, I have to... (2 Replies)
Discussion started by: isingh786
2 Replies
3. Shell Programming and Scripting
I have a variable $exe in a shell script file a.sh which I need to access in another shell script file b.sh. How can I do that? :rolleyes:
Thanks!! (2 Replies)
Discussion started by: looza
2 Replies
4. Shell Programming and Scripting
Hi All,
I have a shell script called sample1.sh where I have 2 variables. Now I have another shell script called sample2.sh. I want the variables in sample1.sh to be available to sample2.sh.
For example. In sample1.sh I am finding the sum of 2 numbers namely a and b. Now I want to access... (2 Replies)
Discussion started by: rsendhilmani
2 Replies
5. UNIX for Dummies Questions & Answers
I have the following script that is supposed to calculate the runtime of the script as a whole (edited for brevity):
#!/bin/sh
# set endtime and print elapsed time
set starttime=`date +%s`
echo "Value of starttime: " $starttime
sleep 1
set endtime=`date +%s`
echo "Value of endtime: "... (2 Replies)
Discussion started by: figaro
2 Replies
6. HP-UX
hi everyone,
i'm writing shell script on hp-ux server that run by root user then (inside the script) su to database user and appl user..the reason for this script is to run some commands involve all users root and database and appl..anyway, variables when root in control is ok but when su, the... (1 Reply)
Discussion started by: neemoze
1 Replies
7. UNIX for Dummies Questions & Answers
I should preface this by saying I have never worked with shell scripts before so this is all new to me. I was able to make something that worked, but is terribly optimized, and I have no idea how to improve it. If anything it's a pretty hilarious script:
#/bin/bash
get_char() {
... (4 Replies)
Discussion started by: ricco19
4 Replies
8. UNIX for Dummies Questions & Answers
Dear Unix gurus,
We have a config shell script file which has 30 variables which needs to be passed to master unix shell script that invokes oracle database sessions. So those 30 variables need to go through the database sessions (They are inputs) via a shell script. one of the variable name... (1 Reply)
Discussion started by: dba1981
1 Replies
9. Shell Programming and Scripting
Dear Unix gurus,
We have a config shell script file which has 30 variables which needs to be passed to master unix shell script that invokes oracle database sessions. So those 30 variables need to go through the database sessions (They are inputs) via a shell script. one of the variable name... (1 Reply)
Discussion started by: dba1981
1 Replies
10. Shell Programming and Scripting
Hi All,
I have a script which intends to create as many variables at runtime, as the number of parameters passed to it. The script needs to save these parameter values in the variables created and print them
abc.sh
----------
export Numbr_Parms=$#
export a=1
while
do
export... (3 Replies)
Discussion started by: dev.devil.1983
3 Replies
LEARN ABOUT PHP
odbc_execute
ODBC_EXECUTE(3) 1 ODBC_EXECUTE(3)
odbc_execute - Execute a prepared statement
SYNOPSIS
bool odbc_execute (resource $result_id, [array $parameters_array])
DESCRIPTION
Executes a statement prepared with odbc_prepare(3).
PARAMETERS
o $result_id
- The result id resource, from odbc_prepare(3).
o $parameters_array
- Parameters in $parameter_array will be substituted for placeholders in the prepared statement in order. Elements of this array
will be converted to strings by calling this function. Any parameters in $parameter_array which start and end with single quotes
will be taken as the name of a file to read and send to the database server as the data for the appropriate placeholder. If you
wish to store a string which actually begins and ends with single quotes, you must add a space or other non-single-quote character
to the beginning or end of the parameter, which will prevent the parameter from being taken as a file name. If this is not an
option, then you must use another mechanism to store the string, such as executing the query directly with odbc_exec(3)).
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
odbc_execute(3) and odbc_prepare(3) example
In the following code, $success will only be TRUE if all three parameters to myproc are IN parameters:
<?php
$a = 1;
$b = 2;
$c = 3;
$stmt = odbc_prepare($conn, 'CALL myproc(?,?,?)');
$success = odbc_execute($stmt, array($a, $b, $c));
?>
If you need to call a stored procedure using INOUT or OUT parameters, the recommended workaround is to use a native extension for your
database (for example, mssql for MS SQL Server, or oci8 for Oracle).
CHANGELOG
+--------+---------------------------------------------------+
|Version | |
| | |
| | Description |
| | |
+--------+---------------------------------------------------+
| 4.2.0 | |
| | |
| | File reading is now subject to safe mode and |
| | open-basedir restrictions in $parameters_array. |
| | |
+--------+---------------------------------------------------+
SEE ALSO
odbc_prepare(3).
PHP Documentation Group ODBC_EXECUTE(3)