12-08-2005
Hi Bakunin,
The issue, I believe, is the eval statement. However I need to use the eval statement to get the contents of the variable.
Cheers
Helen
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I apologize for the simple question but can someone please help me with how to evaluate a number?
I will be reading in a file and if a number is >= 100000000, I will do something, if not, I will exit the if statement.
Thanks in advance (1 Reply)
Discussion started by: hedrict
1 Replies
2. UNIX for Dummies Questions & Answers
Hi
I have a script in which I have several variables
var1
var2
var3
var4
etc......
and
field1
field2
field3
field4
etc.......
The script similar to this: (6 Replies)
Discussion started by: Bab00shka
6 Replies
3. UNIX for Dummies Questions & Answers
Hi all,
I ve a script like....
TBL=employee
sql=`cat abhi.sql` \\ abhi.sql contains ------- select a from $TBL
echo $TBL
echo $sql
SQL=`echo $sql`
echo $SQL
now i want SQL as select a from employee
and as select a from $TBL
How can I achieve this?
Help appriciated (3 Replies)
Discussion started by: abzi
3 Replies
4. UNIX for Dummies Questions & Answers
how do i evaluate the value of date
if ( $(date +%m) > 8 ) then
FY_STAMP=FY$(echo $(($(date +%Y) + 1)) | cut -c3-4)
else
FY_STAMP=FY$(date +%y)
fi
i want this to make the FY_STAMP increment by 1 if the month is september and up. but cant seem to make it work (3 Replies)
Discussion started by: rsf01
3 Replies
5. Shell Programming and Scripting
How can I evaluate a decimal value in an if statement?
echo "Enter limit:"
read limit (enter a decmal value, ie: 2.5)
decimallimit=`echo $limit+0|bc|quit`
echo $decimallimit
if
then
echo $decimallimit
else
echo "failed"
fi (4 Replies)
Discussion started by: larrys721
4 Replies
6. Shell Programming and Scripting
Hi,
I have the following requirement.
V="First"
R="V"
echo $$R
The output should be First. How do i achieve this.
how do we evaluate the $R and evaluate it to $V as $R contains V
and $V is First.
Thanks
Vijay (2 Replies)
Discussion started by: vijaykrc
2 Replies
7. Shell Programming and Scripting
I have the following in my makefile:
RESULT=`../${TOOLS_ROOT_PATH}/ext_tools.sh 11`; \
set $$RESULT > tMp; \
rm tMp; \
if ; then \
echo copying external-local tool: $< \($$*\); \
mkdir -p ${EXTERNAL_LOCAL_BIN_DIR}/$<; \
cp -f... (4 Replies)
Discussion started by: jake_ryan
4 Replies
8. Shell Programming and Scripting
Hi all,
Thanks in advance for your time.
I have a data file like this:
1 7.465753425
2 8.980821918
1 1.717808219
1 6.550684932
0 5.432876712
I wish to write a bash script to check both columns and output a 1 if col1==1 AND col2<3. Otherwise I want to output a 0. In the above... (5 Replies)
Discussion started by: jem8271
5 Replies
9. Shell Programming and Scripting
Does anyone know of a way to force a variable name held in another variable to return the value of the first variable? Best if I give an example, that does not work:
/usr/local/bin >cat mike.sh
NUM1ref=16
NUM2ref=32
echo "=============="
for VAR in NUM1 NUM2
do
XXXX=${VAR}ref
echo $XXXX... (4 Replies)
Discussion started by: mikejordan
4 Replies
10. UNIX for Dummies Questions & Answers
Hi Guys,
Good day ULF :) I hope you can help me again with my problem. I have a file which looks like this:
Command was launched from partition 0.
------------------------------------------------
Executing command in server server3
Dec 18 21:31:12 AHM04 nseventmgr: EVENT-SET:... (4 Replies)
Discussion started by: rymnd_12345
4 Replies
LEARN ABOUT PHP
db2_num_rows
DB2_NUM_ROWS(3) 1 DB2_NUM_ROWS(3)
db2_num_rows - Returns the number of rows affected by an SQL statement
SYNOPSIS
int db2_num_rows (resource $stmt)
DESCRIPTION
Returns the number of rows deleted, inserted, or updated by an SQL statement.
To determine the number of rows that will be returned by a SELECT statement, issue SELECT COUNT(*) with the same predicates as your
intended SELECT statement and retrieve the value.
If your application logic checks the number of rows returned by a SELECT statement and branches if the number of rows is 0, consider modi-
fying your application to attempt to return the first row with one of db2_fetch_assoc(3), db2_fetch_both(3), db2_fetch_array(3), or
db2_fetch_row(3), and branch if the fetch function returns FALSE.
Note
If you issue a SELECT statement using a scrollable cursor, db2_num_rows(3) returns the number of rows returned by the SELECT state-
ment. However, the overhead associated with scrollable cursors significantly degrades the performance of your application, so if
this is the only reason you are considering using scrollable cursors, you should use a forward-only cursor and either call SELECT
COUNT(*) or rely on the boolean return value of the fetch functions to achieve the equivalent functionality with much better perfor-
mance.
PARAMETERS
o $stmt
- A valid stmt resource containing a result set.
RETURN VALUES
Returns the number of rows affected by the last SQL statement issued by the specified statement handle.
PHP Documentation Group DB2_NUM_ROWS(3)