Sponsored Content
Top Forums Shell Programming and Scripting division operation in shell script Post 302093793 by jim mcnamara on Monday 23rd of October 2006 02:12:04 PM
Old 10-23-2006
First off, SQL provide for division:
Code:
result=\
`sqlplus -s batch_user/batch_user@acsblest << EOF1 
set heading off
SET FEEDBACK OFF
SET PAGESIZE 0
SET LINESIZE 900
select cp_num_run_ / cp_max_task 
      from fusionhc_chk 
      where cc_alias = 'eCustomerCMEObjMgr_enu';
EOF1`
echo $result

Floating point division in scripts depends on the shell - a general solution :
Code:
result=`echo "$num_tasks / max_tasks " | bc -l`
echo $result

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

division in shell scripts

Iam not able to device variables in a shell script.. here is the lines that i tried.. please help.. sum = echo `expr $up / ( $down )` (6 Replies)
Discussion started by: esham
6 Replies

2. UNIX for Dummies Questions & Answers

what does the operation '>&' mean in a shell script

hi, all, i saw a syntax like this usr/local/mpiexec -np 8 /home/XXXX/program_exe >& ./temp/out the output will be put into ./temp/out. I want to know the meaning of the operation symbol '>&'. Thanks (3 Replies)
Discussion started by: cy163
3 Replies

3. Shell Programming and Scripting

Column operation : cosne and sine operation

I have a txt file with several columns and i want to peform an operation on two columns and output it to a new txt file . file.txt 900.00000 1 1 1 500.00000 500.00000 100000.000 4 4 1.45257346E-07 899.10834 ... (4 Replies)
Discussion started by: shashi792
4 Replies

4. Shell Programming and Scripting

Division in bash script

I use this simple command result=$(echo "7 / 9" |bc -l) echo $result .77777777777777777777 .... but I like to get 0.7777777777777777777 How can I do in order to get also the 0 ? How to use code tags when posting data and code samples. (3 Replies)
Discussion started by: emi65
3 Replies

5. Shell Programming and Scripting

How to perform floating division in shell script?

I want to perform the below division operation in shell script and round the value. val1=6000 val2=5000 res=val1/val2 ----> 1.2---> Round to 2 Please help. (3 Replies)
Discussion started by: vel4ever
3 Replies

6. Shell Programming and Scripting

Unix Script -- Unable to perform division

I'm new to scripts, i wrote the below script to capture the percentage of FreeMemory available in Linux box. Output of UsedfreeMemory is displayed as '0'. I'm expecting the output like 0.89 (or) .89 --- ( 0.89 perferable) Anyone can help me on this pls. ... (3 Replies)
Discussion started by: murali1687
3 Replies

7. Shell Programming and Scripting

Help me to perform count & group by operation in shell scripting?

Hi All, I want to display the distinct values in the file and for each distinct value how may occurance or there. Test data: test1.dat 20121105 20121105 20121105 20121105 20121106 20121106 20121106 20121105 I need to display the output like Output (2 Replies)
Discussion started by: bbc17484
2 Replies

8. AIX

AIX 6, operation on time in script

Hi I have a question, On linux (centos) I am executing a script: #!/bin/bash st1=`date "+%T"` SD=`date -u -d $st1 +"%s"` #some operations ... st2=`date "+%T"` FD=`date -u -d $st2 +"%s"` time_oper=`date -u -d "0 $FD sec - $SD sec" +"%H:%M:%S"` echo "Time script execution -... (1 Reply)
Discussion started by: primo102
1 Replies

9. Shell Programming and Scripting

String operation in csh shell

Hi, to everybody i have a string which Looks like this FT47;3;1;1;;;1;09.02.2017 21:21:19;2;2 and i would like to change to value on one Position only e.g. the values on Position 6 should change to 1 nevertheyless which values was there before AIX 4.3.2.0 and csh i try... (10 Replies)
Discussion started by: Nadielosabra
10 Replies

10. Shell Programming and Scripting

awk script to find data in three file and perform replace operation

Have three files. Any other approach with regards to file concatenation or splitting, etc is appreciated If column55(billngtype) of file1 contains YMNC or YPBC then pick the value of column13(documentnumber). Now find this documentnumber in column1(Billdoc) of file2 and grep the corresponding... (4 Replies)
Discussion started by: as7951
4 Replies
SQL::Translator::Parser(3pm)				User Contributed Perl Documentation			      SQL::Translator::Parser(3pm)

NAME
SQL::Translator::Parser - describes how to write a parser DESCRIPTION
Parser modules that get invoked by SQL::Translator need to implement a single function: parse. This function will be called by the SQL::Translator instance as $class::parse($tr, $data_as_string), where $tr is a SQL::Translator instance. Other than that, the classes are free to define any helper functions, or use any design pattern internally that make the most sense. When the parser has determined what exists, it will communicate the structure to the producer through the SQL::Translator::Schema object. This object can be retrieved from the translator (the first argument pass to parse) by calling the schema method: my $schema = $tr->schema; The Schema object has methods for adding tables, fields, indices, etc. For more information, consult the docs for SQL::Translator::Schema and its related modules. For examples of how this works, examine the source code for existing SQL::Translator::Parser::* modules. AUTHORS
Ken Youens-Clark, <kclark@cpan.org<gt>, darren chamberlain <darren@cpan.org>. SEE ALSO
perl(1), SQL::Translator, SQL::Translator::Schema. perl v5.14.2 2012-01-18 SQL::Translator::Parser(3pm)
All times are GMT -4. The time now is 04:36 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy