Dear all,
This is the Bionic Fysh again. I have two quick questions:
1- when writing shell scripts, how does one allow the tilda ~ into the script ?
e.g
ls ~;
ls ~me;
user=you;
ls ~$user (N.B I think that for this one you need: ls `~$user`)
2- In FreeBSD 4.0, I would like for a... (6 Replies)
Hi All,
I have written 4 sql queries . Now I want to write one SHELL SCRIPTING program for all these queries...
i.e
1.select * from head;
2. select * from detail;
3. delete from head;
4. delete from detail;
Please let me know how to write a shell script...
Thank you (1 Reply)
Hi,
I have an input file which have many lines,from which i need to extract only the complete sql statements and write this alone to an output file.
please help us in this.
Regards
Meva (7 Replies)
Hi,
Would someone know if I can fire nested sql queries in a shell script? Basically what I am trying to do is as follows:
my_sql=$(sqlplus -s /nolog<<EOF|sed -e "s/Connected. *//g"
connect... (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 All,
I tried executing set of queries from shell script but not able to capture the input query in the log file. The code looks something similar to below
sqlplus user/pwd@dbname << EOF > output.log
$(<inputfile.txt)
EOF
The above code is capturing the output of queries into... (9 Replies)
I have n number of SQL queries needs to executed in Shell. Result of this query need to assign in a variable. Once all the queries are executed script needs to exit.
Sample Query:
SQL 1: Select Count(*) from TABLE GROUP BY COL1,COL2
SQL 2: Select Count(*) from TABLE GROUP BY COL1,COL2
... (2 Replies)
how to store the count of queries in variables inside a filein shell script
my output :
filename
-------
variable1=result from 1st query
variable2=result from 2nd query
.
.
.
. (3 Replies)
How to run multiple Queries in a ksh Script
I have a KSH script that has one SQL Query and generates and emails output of the query in HTML format. I want to change the script so that it has three SQL queries and the last query generates and emails the HTML output page of just that query.
So far... (5 Replies)
Discussion started by: JolietJake
5 Replies
LEARN ABOUT BSD
ratfor
RATFOR(1) General Commands Manual RATFOR(1)NAME
ratfor - rational Fortran dialect
SYNOPSIS
ratfor [ option ... ] [ filename ... ]
DESCRIPTION
Ratfor converts a rational dialect of Fortran into ordinary irrational Fortran. Ratfor provides control flow constructs essentially iden-
tical to those in C:
statement grouping:
{ statement; statement; statement }
decision-making:
if (condition) statement [ else statement ]
switch (integer value) {
case integer: statement
...
[ default: ] statement
}
loops: while (condition) statement
for (expression; condition; expression) statement
do limits statement
repeat statement [ until (condition) ]
break
next
and some syntactic sugar to make programs easier to read and write:
free form input:
multiple statements/line; automatic continuation
comments:
# this is a comment
translation of relationals:
>, >=, etc., become .GT., .GE., etc.
return (expression)
returns expression to caller from function
define:
define name replacement
include:
include filename
Ratfor is best used with f77(1).
SEE ALSO f77(1)
B. W. Kernighan and P. J. Plauger, Software Tools, Addison-Wesley, 1976.
7th Edition April 29, 1985 RATFOR(1)