Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: input parameters pls help!
Top Forums Shell Programming and Scripting input parameters pls help! Post 302107625 by yarik20 on Monday 19th of February 2007 05:11:23 PM
Old 02-19-2007
input parameters pls help!
Hi i am a newbie who is trying to input parameters into this script, but not sure where to start.

The parameters that need to be input are the baseline label "abc.0111.BL " mantioned bellow, and database string "abc/abcp@db2 @counter.sql "
Environment: Windows XP
Running script: Cygwin 3.2

If anyone can help me, or try to direct me where to go from there i'll really appreciate.
Thanks.

Code:
#!/bin/bash

SCRIPT_DIR=$(dirname $0)
SCRIPT_DIR=$(cd $SCRIPT_DIR && pwd)
DATA_DIR=${SCRIPT_DIR}/../../installer/data/
SOURCE_DIR_MAINT=/cygdrive/c/maint_view/RBS

echo "######################UPDATING MAINTANANCE VIEW##########################  "
#update view 
(cd $SOURCE_DIR_MAINT; cleartool update) >log.lst

cd $DATA_DIR
cleartool find . -name '*.sql' -cview -version '{!lbtype(abc.0111.BL)}' -nxname -print | sed -e 's/[.]\\//g' -e 's/_data[.]sql//g' | sort >file.lst
echo ===============================================================================================
for f in `cat file.lst`; do count=$(grep "insert into" ${f}_data.sql|wc -l); echo "$f,$count"; done
echo ===============================================================================================
echo "set heading off;" >counter.sql
for f in `cat file.lst`; do echo "select '$f,'||count(*) from $f;" ; done >>counter.sql
echo "quit" >> counter.sql
cat counter.sql
for f in `cat file.lst`; do count=$(grep "insert into" ${f}_data.sql|wc -l); echo "$f,$count"; done >version_controlcount.txt
sqlplus -S abc/abcp@db2 @counter.sql | sed -e '/^$/d' >db_count.txt
cat db_count.txt
diff version_control_count.txt db_count.txt
exit 0

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Accept input parameters

Dear All, I got a table creation file in a standard format. I need to accept parameters from the user & then based on the input change the data in the file. For. eg. i will accept the database name, dbspace name & user name from the user and accordingly change the same in the table creation... (2 Replies)
Discussion started by: lloydnwo
2 Replies

2. Shell Programming and Scripting

Input parameters

I have a script which take 3 input parameters 1st - a date (i.e. current date) 2nd - type (i.e. A) 3rd - limit (i.e. 40) normally the date parameter would be current date, so I thought I could do this calculate.sh $(date +%Y-%m-%d) A 40 however, it seems like it can't be done,... (3 Replies)
Discussion started by: mpang_
3 Replies

3. Shell Programming and Scripting

Validating Input parameters

Hi All, I have tried to use ckdate (sun) command in script. It checks the input parameter which should be in 'YYYYMMDD format. date=$( echo $1 | ckdate -f "%Y%m%d") | true if ] then print " success" else print "no success" fi But in whatever format i pass the parameter,... (3 Replies)
Discussion started by: Amit.Sagpariya
3 Replies

4. Shell Programming and Scripting

Verify input parameters

I have to write a script to verify input parameters; say esr should be YES or NO other wise the script should print an error. This is what i tried in my script but I get the following error : esr="YES" if ; then print " Error should specify esr options YES/NO" else esr =$esr fi ... (2 Replies)
Discussion started by: ramky79
2 Replies

5. Shell Programming and Scripting

Problem with Input parameters

Hi, I am facing a weird problem with input parameters. Please find more details about my problem below: a) I am executing a korn shellscript with 11 input parameters from "Appworx" tool (it's a scheduling tool) and immediately displaying those 11 parameter values in unixscript and noticed... (4 Replies)
Discussion started by: npk2210
4 Replies

6. Shell Programming and Scripting

How to validate input parameters?

Hi, I wonder how I can know if the input parameters to the script are numbers or text Thanks (11 Replies)
Discussion started by: Gengis-Kahn
11 Replies

7. Shell Programming and Scripting

Problem with input parameters

Hi I wrote a script which lists the content of a given directory. I have just one problem. If you give 2 or more parameters, then it gives a strange error. After that error, it gives also an error from my script, but normally it shouldn't give that error. Here's my script.You can test it. ... (3 Replies)
Discussion started by: hss
3 Replies

8. Shell Programming and Scripting

How can I take input parameters after the first one?

Hi, Is there a simple way to take input of parameters after the first one? As following example, if I assign others=$2, it only takes the second one, if I assign others=$@, it will include the first one. I may try to assign others="$2 $3 $4 $5 $6 $7 $8 $9", it looks very ugly and could missing... (1 Reply)
Discussion started by: hce
1 Replies

9. AIX

Input parameters

friends and I can validate whether to run the shell has input parameters m event date, I occasionally happen something like this does not work if $ 1 is null then echo has entered input parameters else echo "parameter ok" fi (2 Replies)
Discussion started by: tricampeon81
2 Replies

10. Shell Programming and Scripting

Pls HELP: Redirecting input to SFTP connection

Hi, Can somebody please let me know if we can redirect variable value to the sftp connection. I am trying to run the attached snippet but facing an error. dev@UAT.com> export USER1=ftp dev@UAT> export HOST1=XX.XX.XX.XX dev@UAT> export INPUTDATA2='lcd /Z02/apps/output/UAT/CMUP/incoming cd... (9 Replies)
Discussion started by: Khan28
9 Replies

LEARN ABOUT OPENDARWIN

dsaparam

DSAPARAM(1)							      OpenSSL							       DSAPARAM(1)

NAME

       dsaparam - DSA parameter manipulation and generation

SYNOPSIS

       openssl dsaparam [-inform DER|PEM] [-outform DER|PEM] [-in filename] [-out filename] [-noout] [-text] [-C] [-rand file(s)] [-genkey]
       [-engine id] [numbits]

DESCRIPTION

       This command is used to manipulate or generate DSA parameter files.

OPTIONS

       -inform DER|PEM
	   This specifies the input format. The DER option uses an ASN1 DER encoded form compatible with RFC2459 (PKIX) DSS-Parms that is a
	   SEQUENCE consisting of p, q and g respectively. The PEM form is the default format: it consists of the DER format base64 encoded with
	   additional header and footer lines.

       -outform DER|PEM
	   This specifies the output format, the options have the same meaning as the -inform option.

       -in filename
	   This specifies the input filename to read parameters from or standard input if this option is not specified. If the numbits parameter
	   is included then this option will be ignored.

       -out filename
	   This specifies the output filename parameters to. Standard output is used if this option is not present. The output filename should not
	   be the same as the input filename.

       -noout
	   this option inhibits the output of the encoded version of the parameters.

       -text
	   this option prints out the DSA parameters in human readable form.

       -C  this option converts the parameters into C code. The parameters can then be loaded by calling the get_dsaXXX() function.

       -genkey
	   this option will generate a DSA either using the specified or generated parameters.

       -rand file(s)
	   a file or files containing random data used to seed the random number generator, or an EGD socket (see RAND_egd(3)).  Multiple files
	   can be specified separated by a OS-dependent character.  The separator is ; for MS-Windows, , for OpenVMS, and : for all others.

       numbits
	   this option specifies that a parameter set should be generated of size numbits. It must be the last option. If this option is included
	   then the input file (if any) is ignored.

       -engine id
	   specifying an engine (by it's unique id string) will cause req to attempt to obtain a functional reference to the specified engine,
	   thus initialising it if needed. The engine will then be set as the default for all available algorithms.

NOTES

       PEM format DSA parameters use the header and footer lines:

	-----BEGIN DSA PARAMETERS-----
	-----END DSA PARAMETERS-----

       DSA parameter generation is a slow process and as a result the same set of DSA parameters is often used to generate several distinct keys.

SEE ALSO

       gendsa(1), dsa(1), genrsa(1), rsa(1)

0.9.7d								    2003-11-20							       DSAPARAM(1)
All times are GMT -4. The time now is 01:20 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy