03-25-2019
How do you call your script on the command line, what parameters do you pass to the script?
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I know htis isnt exactly unix.... but hopefully someone can help me or direct me someplace to get help.
I can run sql queries in scripts against my informix db using:
dbaccess mydb myquery.sql >> sql.output
I need to write my script to select based on todays date. Its very... (5 Replies)
Discussion started by: MizzGail
5 Replies
2. Shell Programming and Scripting
Hi,
I need to get the value from the table using the sql command and store this value into the unix variable so that i can use this value for furthure use..
Please can any body help me in this regards
Thanks & Regards
Abdul Hafeez Shaik (17 Replies)
Discussion started by: abdulhafeez
17 Replies
3. Shell Programming and Scripting
Hi,
I have a unix varaible called as account which hold values which i want to use in a PL/SQL block in a shell script.
This variable value is being used in multiple places in the PL/SQL block and i get an erroe whenenevr is use this varaible with $prompt.
Help Urgently (1 Reply)
Discussion started by: sumi_mn
1 Replies
4. Shell Programming and Scripting
Hi All
I have a requirement where in I am stuck. There is a shell script that is being developed by me. It consist of the sql stmt also. I need to export a variable called HOMEPAGE with a value say www.abc.com. and then use this $HOMEPAGE variable in the sql stmt. My ultimate aim is to fetch all... (1 Reply)
Discussion started by: amitsinha
1 Replies
5. Shell Programming and Scripting
Hi Guys,
I am trying to pass a string variable from Unix shell script to sqlplus as a parameter.
I have tried using single quotes with the variable name but it does not work. Please help me with it.
I am using BASH.
My code:
Your help is much appreciated.
Thanks,
shil (2 Replies)
Discussion started by: infintenumbers
2 Replies
6. Shell Programming and Scripting
Hi,
I have a requirement to store oracle sqlplus output to some unix variable, count the records and then print the output on the screen.
Can you please point me to any sample program for reference purpose.
Thanks a lot for your time. (0 Replies)
Discussion started by: bhupinder08
0 Replies
7. Shell Programming and Scripting
The following is my script :
#!/bin/bash
echo "please give app_instance_id"
read app_instance_id
echo "id is $app_instance_id"
export app_id=app_instance_id
sqlplus -s nnviewer/lookup@//nasolora008.enterprisenet.org:1521/LOAD3 @test.sql<<EOF
SPOOL /home/tibco/MCH/Data/qa/raak/name.xls... (4 Replies)
Discussion started by: raakeshr
4 Replies
8. Shell Programming and Scripting
I have a sql statement , i need to assign to a variable in Unix
sel count(*) AS num_files from TABLE_A;
i need to use "num_files" in unix statements. let me know how to assign unix variable to above num_files (1 Reply)
Discussion started by: nani1984
1 Replies
9. Shell Programming and Scripting
Hi
I am new to UNIX. I am trying the below and getting the error.
I am trying to assign the variable with the value of the query result. I want this value to use in the next steps.
Created UNIX file (Batch.sh) as below
#!/bin/ksh
sqlplus callidus/callidus4u@attstcal @Batch.sql
... (2 Replies)
Discussion started by: KrishBalu
2 Replies
10. Shell Programming and Scripting
Hi All,
I want to run multiple sql queries and store the data in variable but i want to use sql command only once. Is there a way without running sql command twice and storing.Please advise.
Eg :
Select 'Query 1 output' from dual;
Select 'Query 2 output' from dual;
I want to... (3 Replies)
Discussion started by: Rokkesh
3 Replies
gretl(1) econometrics gretl(1)
NAME
gretl - GNU Regression, Econometrics and Time-series Library
SYNOPSIS
gretl [ options ] [ datafile | scriptfile | sessionfile ]
DESCRIPTION
gretl is an econometrics package, built around a shared library which may be accessed using a command-line client program (gretlcli) or a
graphical user interface (gretl_x11). The program gretl is a wrapper script that calls the GUI if the DISPLAY environment variable is set,
otherwise the command-line client.
For details, please start up either the GUI or the command-line client and consult the online help, or read the printed manual, which is
available in PDF format via the gretl website, http://gretl.sourceforge.net.
OPTIONS
These are the options supported by the gretl_x11 program; gretlcli is a little different.
-r script, --run script
Open a script.
-c, --dump
Dump the configuration file.
-d database, --db database
Open a local database.
-e, --english
Force use of English.
-r script, --run script
Open a script.
-w database, --webdb database
Open a remote database.
-h, --help
Give help information and exit.
-v, --version
Give version information and exit.
FILES
~/.gretl2rc per-user configuration file
~/.gretl directory for user runtime files
ENVIRONMENT VARIABLES
HOME Specifies the user's home directory
DISPLAY
Specifies the X window display to use
SEE ALSO
gretlcli(1)
AUTHOR
The gretl team
The gretl team 1.9.5 gretl(1)