10-16-2002
substituting shell variables
I have a script run_batch.sh as below :-
PAR_VALIDATION=val_siconf
PAR_RUN_LEVEL=1
PAR_EXCLUSIVE_RUN_YN=Y
DATABASE_USER="/@"$TWO_TASK
sqlplus -s $DATABASE_USER |&
print -p -- 'set feed off pause off pages 0 head off veri off line 500'
print -p -- 'set term off time off serveroutput on'
print -p -- "set sqlprompt ''"
print -p -- "SELECT run_command from tmp_run_batch;"
read -p run_command
echo $run_command
print -p -- "execute dbms_output.put_line($run_command);"
The sql statement "SELECT run_command from tmp_run_batch;" gives the output :-
pack_claims_clload_mesg.func_main($PAR_VALIDATION,$PAR_RUN_LEVEL,$PAR_EXCLUSIVE
_RUN_YN)
Now if I run the shell using the command :-
ksh run_batch.sh
It echoes :-
pack_claims_clload_mesg.func_main($PAR_VALIDATION,$PAR_RUN_LEVEL,$PAR_EXCLUSIVE
_RUN_YN)
without substituting the shell variables with their values and the next statement of executing the database package also fails.
Can you suggest any method to substitute the shell variables with their values ?
Cheers
Suds
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello
please how can i change this infrormation within a file dynamically without using vi " || $6 ~ /^229*/ " the * means any number within
the file has this content :
cat lec|awk -F '|' 'length($6) >= 12 || length($6) <= 10' |awk -F '|' '$6 ~ /^24/ || $6 ~ /^22924/ &&$7 ~... (1 Reply)
Discussion started by: neyo
1 Replies
2. Shell Programming and Scripting
Hi All,
I have the following problem:
1. I have a file containing a line:
a,b,d,${d},e,f
2. From within a script I grep the file for '^a,' to get the line
3. I obtain the fourth field as follows:
Field4="$( print -r $fileEntry | cut -d, -f4 )"
4. The script exports variables at the... (1 Reply)
Discussion started by: oneillc9
1 Replies
3. Programming
I have a Linux C program I'm writing that has one section where, within a large string, I need to substitute a smaller string for another, and those probably won't be the same size.
For instance, if I have a string:
"Nowisthetimeforallgoodmen"
and I want to substitute 'most' for 'all' the... (2 Replies)
Discussion started by: cleopard
2 Replies
4. Shell Programming and Scripting
Can SED be used to substitute a character (y) with a character (Y) in a specified field?
File has 12000 : delimeted rows as;
HHC 1 BDE:Lastname, Firstname MI:firstname.mi.lastname@mil:SGT
HHC 2 BDE:Lastname, Firstname MI:Firstname.MI.Lastname@mil:SGT
I wish to replace the capital letters... (6 Replies)
Discussion started by: altamaha
6 Replies
5. Shell Programming and Scripting
Hi Gurus
this is working finee with tested values
#!/bin/ksh
V_DATE="2007-11-30"
V_ID=789
V_NAME="john_${V_ID}_has_${V_DATE}_s"
FILE_NAME=`echo ${V_NAME}`
echo ${FILE_NAME}
Buttt the problem is
the first two values will come dynamically
and the file will looks like... (2 Replies)
Discussion started by: SeenuGuddu
2 Replies
6. Shell Programming and Scripting
have a fileA containing about 260 lines wherein i have to match 2 lines
fileA
blah blah
OF 90 DAYS DOCS PERIOD 12/06/0"
Pairs_Id 52006
Amount1 -300000.0
Amount2 15091500.10
Codifiers_Id 0
OriginalId 0
EOT
--blah blah blah
TBL Tradt_IN
CardRate 0.0
hashAmount -15091500.0... (2 Replies)
Discussion started by: sunnyboy
2 Replies
7. UNIX for Dummies Questions & Answers
Hi All,
my requirement is as below.
I need to replace a value in a particular column with a substitution variable(date value) and modified value of the current column value in the same position.
for ex.
i have a record like
02;aaaa;bbbbb;cccccc;dddddd;123456789;hhhhh;12hs;asdf ;... (3 Replies)
Discussion started by: ganesh_248
3 Replies
8. UNIX for Dummies Questions & Answers
Hi All,
OS HPUX 11.11
I am using following script to take controlfile backup. I have used SID variable to hold "ffin1" value, which I again subsitute in "'/db/ffin1/home/oraffin1/$SID_$wdate.ctl'" command. Well, after running this, SID variable does not subsittue it's value, while wdate... (6 Replies)
Discussion started by: alok.behria
6 Replies
9. Shell Programming and Scripting
Hi guys,
I'm trying to figure out how to use a shell variable inside my sed command.
I just want to remove a certain part of a path. I've tried three different combinations and none of them work. Here are the three combinations:
echo $file | sed 's/'$test'//'
echo $file | sed "s/$test//"... (7 Replies)
Discussion started by: chu816
7 Replies
10. Shell Programming and Scripting
I am trying to use nawk sub to substitute a string in a file. Both the pattern and the replacement I set as variables using bash.
here is the code:
#!/bin/bash -x
ydate=`/usr/local/bin/date +%Y%m%d`
echo $ydate
test_ca=/home/mdadmin/test_ca
for i in `cat ${test_ca}`
do
if ]; then... (9 Replies)
Discussion started by: smenago
9 Replies
LEARN ABOUT PHP
pdostatement.execute
PDOSTATEMENT.EXECUTE(3) 1 PDOSTATEMENT.EXECUTE(3)
PDOStatement::execute - Executes a prepared statement
SYNOPSIS
public bool PDOStatement::execute ([array $input_parameters])
DESCRIPTION
Execute the prepared statement. If the prepared statement included parameter markers, you must either:
ocall PDOStatement.bindParam(3) to bind PHP variables to the parameter markers: bound variables pass their value as input and
receive the output value, if any, of their associated parameter markers
oor pass an array of input-only parameter values
PARAMETERS
o $input_parameters
- An array of values with as many elements as there are bound parameters in the SQL statement being executed. All values are
treated as PDO::PARAM_STR. You cannot bind multiple values to a single parameter; for example, you cannot bind two values to a
single named parameter in an IN() clause. You cannot bind more values than specified; if more keys exist in $input_parameters
than in the SQL specified in the PDO::prepare, then the statement will fail and an error is emitted.
RETURN VALUES
Returns TRUE on success or FALSE on failure.
CHANGELOG
+--------+---------------------------------------------------+
|Version | |
| | |
| | Description |
| | |
+--------+---------------------------------------------------+
| 5.2.0 | |
| | |
| | The keys from $input_parameters must match the |
| | ones declared in the SQL. Before PHP 5.2.0 this |
| | was silently ignored. |
| | |
+--------+---------------------------------------------------+
EXAMPLES
Example #1
Execute a prepared statement with bound variables
<?php
/* Execute a prepared statement by binding PHP variables */
$calories = 150;
$colour = 'red';
$sth = $dbh->prepare('SELECT name, colour, calories
FROM fruit
WHERE calories < :calories AND colour = :colour');
$sth->bindParam(':calories', $calories, PDO::PARAM_INT);
$sth->bindParam(':colour', $colour, PDO::PARAM_STR, 12);
$sth->execute();
?>
Example #2
Execute a prepared statement with an array of insert values (named parameters)
<?php
/* Execute a prepared statement by passing an array of insert values */
$calories = 150;
$colour = 'red';
$sth = $dbh->prepare('SELECT name, colour, calories
FROM fruit
WHERE calories < :calories AND colour = :colour');
$sth->execute(array(':calories' => $calories, ':colour' => $colour));
?>
Example #3
Execute a prepared statement with an array of insert values (placeholders)
<?php
/* Execute a prepared statement by passing an array of insert values */
$calories = 150;
$colour = 'red';
$sth = $dbh->prepare('SELECT name, colour, calories
FROM fruit
WHERE calories < ? AND colour = ?');
$sth->execute(array($calories, $colour));
?>
Example #4
Execute a prepared statement with question mark placeholders
<?php
/* Execute a prepared statement by binding PHP variables */
$calories = 150;
$colour = 'red';
$sth = $dbh->prepare('SELECT name, colour, calories
FROM fruit
WHERE calories < ? AND colour = ?');
$sth->bindParam(1, $calories, PDO::PARAM_INT);
$sth->bindParam(2, $colour, PDO::PARAM_STR, 12);
$sth->execute();
?>
Example #5
Execute a prepared statement using array for IN clause
<?php
/* Execute a prepared statement using an array of values for an IN clause */
$params = array(1, 21, 63, 171);
/* Create a string for the parameter placeholders filled to the number of params */
$place_holders = implode(',', array_fill(0, count($params), '?'));
/*
This prepares the statement with enough unnamed placeholders for every value
in our $params array. The values of the $params array are then bound to the
placeholders in the prepared statement when the statement is executed.
This is not the same thing as using PDOStatement::bindParam() since this
requires a reference to the variable. PDOStatement::execute() only binds
by value instead.
*/
$sth = $dbh->prepare("SELECT id, name FROM contacts WHERE id IN ($place_holders)");
$sth->execute($params);
?>
NOTES
Note
Some drivers require to close cursor before executing next statement.
SEE ALSO
PDO.prepare(3), PDOStatement.bindParam(3), PDOStatement.fetch(3), PDOStatement.fetchAll(3), PDOStatement.fetchColumn(3).
PHP Documentation Group PDOSTATEMENT.EXECUTE(3)