08-16-2013
Hi Durden_Tyler,
Thank you very much for your help.
You are correct, the PER12.sql script does have the ACCEPT statement, I will now modify and try...
before:
ACCEPT v_personId PROMPT 'Enter a valid PERSON_ID for the employee: '
PROMPT
ACCEPT v_payElements PROMPT 'Display Payroll Element Entries (Y|N): '
After:
ACCEPT v_personId = &1
REM PROMPT 'Enter a valid PERSON_ID for the employee: '
REM PROMPT
ACCEPT v_payElements = &2
REM PROMPT 'Display Payroll Element Entries (Y|N): '
Let me give this a bash.
Cheers!!!
Mahomed
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi ,
I want to pass parameters from a shell script to a sql script and use the parameter in the sql query ..and then I want to spool a particular select query on to my unix box... for 4 different locations by writing only one sql script
Right now no file is generated on the unix box...it is a... (2 Replies)
Discussion started by: phani
2 Replies
2. Shell Programming and Scripting
hi,
I am using a shell script from where i will be conecting to sqlplus..
i am having a problem in passing a variable to sqlplus query..
i will be assigning the variable in the unix environment..whenever i am trying to pass a variable having the contents greater than 2500 characters, i am... (3 Replies)
Discussion started by: kripssmart
3 Replies
3. Shell Programming and Scripting
if
then
# mail -s "Import failed file does not exist" sanjay.jaiswal@xyz.com
echo "FILE does not exist"
exit 1
fi
echo "FILE EXIST"
size=-1
set $(du /export/home/oracle/nas/scott21.dmp.gz)
while
do
echo "Inside the loop"
size=$1
set $(du... (1 Reply)
Discussion started by: sanora600
1 Replies
4. Shell Programming and Scripting
Hi All,
I have a 2 files. File1 i am generating using an ETL tool, which is a comman seperated delimited file which contains country code & load date.
everytime, this country code will be updated from a table. It might be AB or BA & ld_date will be for which date we need to load the file.
... (7 Replies)
Discussion started by: Amit.Sagpariya
7 Replies
5. AIX
I would like to run a compress script on files in certain directories.
My compress_script.sh is just basically
compress file*
In order for me to use this I have to copy it into each directory and run it.
How can I state the directory on the command line with the compress script so it... (2 Replies)
Discussion started by: NycUnxer
2 Replies
6. SCO
OS SCO Open Server 6.0 MP4
I am trying to change the value of a enviornment variable thru a script and want to pass a parameter on the commande line, If I hard code the value inside the script the script changes the enviornment variable
. mytest
where my test is
MYVAR=$1
export MYVAR... (6 Replies)
Discussion started by: atish0
6 Replies
7. Shell Programming and Scripting
Hi,
I have one shell script which use two parameter however one of its parameter have space in between.
eg.
a.sh 20110114 b c d
here b c d is one parameter
I used 'b c d' but its not giving correct result.
Also i tried b\c\d but this one also didnt work.
Any help would be... (5 Replies)
Discussion started by: diehard
5 Replies
8. UNIX for Dummies Questions & Answers
hi All,
i m trying to pass a user choice paramter from unix to sqlplus connect command
here i want the user to enter the username and password he wants to connect in sql plus through read in unix and then automatically connect to that instance.
sqlplus -s $1/$2
where $ 1 and $2 will b... (2 Replies)
Discussion started by: Jcpratap
2 Replies
9. Shell Programming and Scripting
Hello All,
I am interested in finding out a way to pass parameters that are entered at the prompt from HP unix and passed to SQLPlus code with a Shell Script. Is this possible?
Thanks (4 Replies)
Discussion started by: compprog11
4 Replies
10. Shell Programming and Scripting
Hello All,
I am trying below
+++++++++
#/bin/bash
set -x
Host=$1
Port=$2
User=$3
Pass=$4
Warning=$5
Critical=$6
SCRIPT_LOC=/opt/agent/
Parameters="'""hostname=$Host&""port=$Port&""username=$User&""password=$Pass&""jvm=UsedMemory,$Warning,$Critical""'"
echo $Parameters... (10 Replies)
Discussion started by: sundari127
10 Replies
GCAP.1(1p) User Contributed Perl Documentation GCAP.1(1p)
NAME
gcap - Youtube closed caption downloader
SYNOPSIS
gcap [-i] [-t] [-r <regexp>] [--proxy=<addr> | --no-proxy]
[--help] <url> | <video_id>
DESCRIPTION
gcap is a command line tool for downloading Youtube closed captions. The downloaded closed captions are saved in SubRip (srt) file format.
The srt files are saved as "$videoid_$langid.srt" by default.
OPTIONS
--help
Print help and exit.
--version
Print version and exit.
-q, --quiet
Be quiet.
-i, --interactive
Open the interactive prompt which can be used to select the items. gcap selects all items by default. See also "INTERACTIVE PROMPT".
-t, --title
Parse video title and use it in the output filename(s) instead of video ID. The default is no.
-r, --regexp=arg
Cleanup video title using the specified arg regular expression. The default is "/(w|s)/g".
--proxy arg
Use arg for HTTP proxy, e.g. "http://foo:1234". Overrides the http_proxy environment setting.
--no-proxy
Disable use of HTTP proxy. Overrides both "--proxy" and http_proxy environment settings.
INTERACTIVE PROMPT
Use the "--interactive" switch to open the prompt. Note that gcap uses (as of 0.1.0) the Umph::Prompt module for this. Once the prompt
opens, type "help" to get a list of commands available to the prompt.
EXAMPLES
gcap 0QRO3gKj3qw
gcap "http://www.youtube.com/watch?v=0QRO3gKj3qw"
Both yield the same results.
gcap -ti 0QRO3gKj3qw
Same as above two but use video title in the filename and choose which of the closed captions should be downloaded.
EXIT STATUS
Exits 0 on success, otherwise 1.
FILES
$HOME/.gcaprc, for example:
echo "--interactive" >> ~/.gcaprc
NOTES
Availability
The following error message produced by gcap (or the XML::DOM module) typically indicates that the video does not have any closed
captions available for it (URL omitted for brewity):
Couldn't parsefile [...] with LWP: no element found at line 1,
column 0, byte -1 at [...]/XML/Parser.pm [...]
http_proxy
gcap depends on XML::DOM which uses LWP::UserAgent to download the data. Note that LWP::UserAgent reads http_proxy environment setting.
e.g.:
env http_proxy=http://foo:1234 gcap video_id
WWW
<http://gcap.googlecode.com/>
<http://repo.or.cz/w/gcap.git>
AUTHOR
Toni Gundogdu <legatvs at sign cpan org>
perl v5.12.4 2011-11-15 GCAP.1(1p)