|
|
Sponsored Content
Top Forums
UNIX for Advanced & Expert Users
To pass one month range in sql script
Post 302964818 by rohit_shinez on Tuesday 19th of January 2016 04:49:41 PM
01-19-2016
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I am trying to close of multiple users in an Oracle database. Each users has records in multiple tables what I need to do is use a script that call each SQL seperately passing either CLI arguments or gathered arguments from the users during run time.
## Accept variable(s) from the command line... (1 Reply)
Discussion started by: jagannatha
1 Replies
2. Shell Programming and Scripting
Hi all, I have a shell script which invoke a sql script using command
db2 -tf /home/me/db_housekeep.sql -z /home/me/db_housekeep.log
however, this mentioned sql script requires several input arguments, I wonder if one can pass variables from shell script to sql script? thanks! (0 Replies)
Discussion started by: mpang_
0 Replies
3. Shell Programming and Scripting
Hello,
i am using '#!/bin/bash', i want to make a loop in pl/sql, this loop takes values from a table according to some conditions, each time the loop choose 3 different variables. What i am not able to do is that during the loop i want my shell script to read this 3 variables and run a shell... (1 Reply)
Discussion started by: rosalinda
1 Replies
4. Shell Programming and Scripting
Hi Guys,
I like to pass a variable to a sql file in a unix script..
I tried a below code..
var=200903
db2 -vf test.sql 200903
test.sql is as below.
select * from db2.users where quarter = $1;
Please tell me where i go wrong..
Thanks in advance,
Magesh (2 Replies)
Discussion started by: mac4rfree
2 Replies
5. UNIX for Advanced & Expert Users
Hi,
I am unable to use parameter in sql script passed from unix script.
my sql script CREATE_SBI_LIST_GROUP.sql is like this -
-------------------------------
SELECT
SDS.ID "SO_ID",
SDS.SO a1,
sgp.sga__code SGA_CODE,
FROM
sga sga,sales_genl_provision sgp , comm_product_condn cpc... (2 Replies)
Discussion started by: apskaushik
2 Replies
6. Shell Programming and Scripting
Hi Guys,
Can someone please help me on adding/inserting a variable date to an sql scipt? Basically I want to assign a 7 days date range. As shown below..
#!/usr/bin/perl
use strict;
use Env qw(ORACLE_HOME);
my $SQLPLUS='/opt/oracle/product/10.1.0/db_1/bin/sqlplus -S... (1 Reply)
Discussion started by: pinpe
1 Replies
7. Shell Programming and Scripting
There are 4 parameters that I have to pass from korn shell to sql script.
1) I have to check if $1 , $2 , $3 and $4 are null values or not .
How can I do that ?
2) Once its determined that these values are null (in the sense they are empty) how can I pass null values to sql script... (11 Replies)
Discussion started by: megha2525
11 Replies
8. Shell Programming and Scripting
Hello,
i`m looking for some way to add to some date an partial number of months, for example to 2015y 02m 27d + 2,54m
i need to write this script in php or bash or sh or mysql or perl in normal time o unix time
i`m asking or there are any simple way to add partial number of month to some... (14 Replies)
Discussion started by: bacarrdy
14 Replies
9. Shell Programming and Scripting
Hi all,
$ echo $SHELL
/bin/bash
Requirement - How to pass oracle sql script as argument to unix shell script?
$ ./output.sh users.sql
Below are the shell scripts and the oracle sql file in the same folder.
Shell Script
$ cat output.sh
#!/bin/bash
.... (7 Replies)
Discussion started by: a1_win
7 Replies
10. Shell Programming and Scripting
Hi All,
I am new to shell script. I am trying to pass value from .sh file to .sql file .
But I am able to run the .sql file from .sh file with values in sql file.
But I am unable to pass the values from .sh file. can some one please help to resolve this.
here is my .sh file
s1.sh
... (4 Replies)
Discussion started by: reddy298599
4 Replies
LEARN ABOUT DEBIAN
tv_check
TV_CHECK(1p) User Contributed Perl Documentation TV_CHECK(1p) NAME
tv_check - Check TV guide listings SYNOPSIS
tv_check --configure|--scan [other options] DESCRIPTIONS
tv_check is a Perl script that reads in a file with show information and checks it against a TV guide listing, reporting on upcoming episodes and alerting you to unexpected episodes or schedule changes. OPTIONS
--configure Run configuration GUI. Either this option or --scan must be provided. --season-reset special --configure option to remove everything but the title to help new season setup. The idea is to keep everything a "title-only" search until seasons begin. Then you update the details including record device. *expirimental* --scan Scan TV listings. Either this option or --configure must be provided. --myreplaytv=UNIT,USERNAME,PASSWORD ** Feature removed ** This option used to auto-populate a config file based on myreplaytv.com. --shows=FILE Specify the name of XML shows file (default: shows.xml). --guide=FILE, --listings=FILE Specify the name of XML guide file (default: guide.xml). --html Generate output in HTML format. --bluenew Highlights new episodes in blue (helpful back when there was an off-season) --output=FILE Write to FILE rather than standard output --help Provide a usage/help listing. SEE ALSO
xmltv(5). AUTHOR
Robert Eden; manpage by Kenneth J. Pronovici. perl v5.14.2 2011-06-13 TV_CHECK(1p)