06-18-2012
Oh gosh!!! O[]O!!!Really easy!
A million thanks, prvin27. It's okay now.
![Smilie Smilie](https://www.unix.com/images/smilies/smile.gif)
)
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
How do I create a K Shell which would silently (without user input) logon to Oracle and
run an SQL script?
Any help will be greatly appreciated.
Steve (1 Reply)
Discussion started by: stevefox
1 Replies
2. Shell Programming and Scripting
hi Friends,
Please help me in writing shell script to run list of sql files.
database is Oracle 9i,
unix os is solaris
Requirement is
1. sql file must take two inputs a)feed id and b)business date
2.shell script must out put .xls or .csvfile as out put without trimming any column name and... (1 Reply)
Discussion started by: balireddy_77
1 Replies
3. Shell Programming and Scripting
Hello,
If I run this command on the server it works.
# dbc "update config set radio_enabled = 0;"
how can I execute the same command in perl. I have defined the dbc path. Can any one please correct the last line.
#!/usr/bin/perl
#database path
$dbc='/opt/bin/psql -Userver... (0 Replies)
Discussion started by: sureshcisco
0 Replies
4. Shell Programming and Scripting
Hello,
I want to connect to ssh, run a query, and store that into a variable in the shell script. Also I need to pass the variable back to php to display the query results.
I have created a public/private key pair for ssh connection and that is working fine. Also I am able to run query in the... (8 Replies)
Discussion started by: shekhar2010us
8 Replies
5. Shell Programming and Scripting
I need to run sql script from shell script which takes the input from a file and contents of file will be like :
12345
34567
78657
and query will be like :
select seq_nbr from bus_event where event_nbr='12345';
select seq_nbr from bus_event where event_nbr='34567';
select seq_nbr... (1 Reply)
Discussion started by: rkrish
1 Replies
6. Shell Programming and Scripting
I need to run a SQL select query in Oracle database and have to capture the list of retrieved records in shell script. Also i would like to modify the query for certain condition and need to fetch it again. How can i do this?
Is there a way to have a persistent connection to oracle database... (9 Replies)
Discussion started by: vel4ever
9 Replies
7. Shell Programming and Scripting
Hi,
I have a query regarding execution of a sql query having long listing of parameters ..I need to execute this query inside a shell script.
The scenario is like....
Suppose I have a file abc.txt that has the card numbers..it could be in thousands..
then I need to fire a query like
... (12 Replies)
Discussion started by: vsachan
12 Replies
8. UNIX for Dummies Questions & Answers
Please read How To Ask Questions The Smart Way (1 Reply)
Discussion started by: balu_279013
1 Replies
9. Shell Programming and Scripting
I am running this test.ksh on server1. It successfully logins to server2 but runs the queries of query.sql on server1. query.sql is present in both server1 and server2
Can anybody please help.
I need to run queries on server2 itself.:confused:
Below is the test script... (10 Replies)
Discussion started by: shruthimithra
10 Replies
10. Shell Programming and Scripting
I want to run sql query in shell script and output data save as delimited text (delimited text would be comma)
Code:
SPOOL_FILE=/pgedw/dan.txt
SQL=/pgedw/dan.sql
sqlplus -s username/password@myhost:port/servicename <<EOF
set head on
set COLSEP ,
set linesize 32767
SET TRIMSPOOL ON
SET... (8 Replies)
Discussion started by: Jaganjag
8 Replies
GOSH(1) Gauche Commands GOSH(1)
NAME
gosh - a Scheme script interpreter
SYNOPSIS
gosh [-biqV] [-I path ] [-A path ] [-u module ] [-l file ] [-e expr ] [-E expr ] [-f flag ] [--] [ script argument ... ]
DESCRIPTION
Gosh is a stand-alone Scheme interpreter built on top of the Gauche Scheme script engine.
When script is given, gosh loads the script, evaluating Scheme code in it. Then, if the script defines a procedure named main, gosh calls
it with a single argument which is a list of the script name and subsequent arguments. When main returns an integer value, gosh exits with
it as an exit code. If main returns non-integer value, or an error is signaled during evaluation, gosh exits with exit code 70 (EX_SOFT-
WARE). See SRFI-22 (http://srfi.schemers.org/srfi-22/srfi-22.html) for details. If there's no main procedure defined in the script, gosh
exits with code 0 after loading the script file.
If no script file is given, gosh goes into an interactive mode. By default, gosh prompts the user to enter a Scheme expression, read and
evaluates it, then prints the result, until EOF is read. If the standard input is not a terminal, however, gosh doesn't print a prompt; it
allows a user to use gosh as a filter program. This behavior can be controlled by -i or -b option; see below.
OPTIONS
Command line options are processed before loading the script file or entering the interactive mode.
The options -I, -A, -u, -l, -L, -e and -E are processed in the order of appearance. For example, adding a load path by -I option affects
the -l options after it, but not the ones before it.
-V Prints gosh version and exits.
-b Batch mode. Doesn't print prompt even the standard input is a terminal. Supersedes -i.
-i Interactive mode. Forces to print prompt, even the standard input is not a terminal.
-q Prevents reading the default initialization file.
-Ipath
Adds path in front of the load path list.
-Apath
Appends path to the tail of the load path list.
-umodule
Loads and imports module, as if "(use module )" is specified in the code.
-lfile
Loads a Scheme file file.
-Lfile
Like -l, but doesn't complain if file doesn't exist.
-eexpr
Evaluates a Scheme expression expr.
-Eexpr
Same as -e, except that the expr is read as if it is surrounded by parenthesis.
-ptype
Turns on the profiler. Currently type can only be 'time'.
-fflag
Sets various flags.
case-fold uses case-insensitive reader (as in R5RS)
load-verbose report while loading files
no-inline don't inline primitive procedures and constants
(combined no-inline-globals, no-inline-locals, and
no-inline-constants.)
no-inline-globals don't inline global procedures.
no-inline-locals don't inline local procedures.
no-inline-constants don't inline constants.
no-post-inline-pass don't run post-inline optimization pass.
-Ffeature
Makes feature available in cond-expand forms.
-- Specifies that there are no more options. If there are more arguments after this, they are taken as script file name and its argu-
ments.
ENVIRONMENT
GAUCHE_LOAD_PATH
A colon separated list of the load paths.
The paths are appended before the system default load paths.
GAUCHE_DYNLOAD_PATH
A colon separated list of the load paths for dynamically loaded
objects. The paths are appended before the system default load paths.
AUTHORS
Shiro Kawai (shiro @ acm . org)
SEE ALSO
gauche-config(1)
Gauche Scheme script engine:
http://practical-scheme.net/gauche/
For the information about Scheme language, see
http://www.schemers.org/
Gauche 0.9.1 GOSH(1)